how do we apply sql query on selected variables?

Answers were Sorted based on User's Feedback



how do we apply sql query on selected variables?..

Answer / vams_gk

first of all u have to know ur reqiurement.as per requ. u
can drap and drop the variables in ur objectsresults and
conditions panel in deskI.on top we have icon with SQl
named .simply click on that u will get a whole sql query .

Is This Answer Correct ?    0 Yes 0 No

how do we apply sql query on selected variables?..

Answer / narsi

if u drag the variable, automatically sql query will be
added.

or
if u select new variable, one window will appear. in this
window u select the qualification(dia or detail or measure)
in defination window. go for formula tab, window will
appear here write a formula by using objects & operators.
if u have any errors or not plz check once parse condition.
Click apply > click ok.

Is This Answer Correct ?    0 Yes 1 No

how do we apply sql query on selected variables?..

Answer / ansari

If we drag the variables automatically SQL query will added

and if you want to modify that query go to query panel->
click sql at the top and there is one options Do not
generate the sql query before running just click that option
and modify the query whatever you want.

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More Business Objects Interview Questions

. User wants to modify a report and wants to add additional data. How will you approach.

2 Answers  


5.what is LOV? where it is store?

3 Answers   TCS,


What is the difference between master-detail and Breaks?

3 Answers  


what will be the contents for a functional requirements specifications

0 Answers  


1.How to convert deski document to webi in infoview? 2.what is connection type for free hand sql?

3 Answers   Wipro,






Can anybady tell me , what is the aggrigate awareness.how to use it . could u plz give me the practical example.

4 Answers   TCS,


Explain is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?

0 Answers  


how can i add two different reports in the same document?

5 Answers   TCS,


How to solve the following errors coming in report development? 1.Syntax 2.multi value 3. #Error 4.computation and 5.Objects are not compatible

2 Answers  


What is the difference between the public object&schema object?

0 Answers  


How will you test a BO report

3 Answers   Infosys,


can we create aliases for every table beforehand? if yes whar are the disadvantages?

5 Answers   AG Technologies,


Categories