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

what r the universe connection types?

4 Answers  


Is it necessary to give joins to the aggrigate tables in the universe?

2 Answers  


Differences between business objects and web intelligence reports?

0 Answers  


What is diff b/w Alias and Contexts in which situation we are using contexts instead of Alias?

2 Answers  


how change the order of prompts in bo xi? eg. i create first prompt with 'year' and second prompt with 'city'. my question is to display the 'city' prompt first .what can i do for it ?

3 Answers   Cambridge, Patni,






what is difference between Rich client web intelligence and Boxir2 web intelligence

3 Answers   TCS,


Which outer join is used in Merge Dimension. Diff between merge and auto merge dimension.

2 Answers   Cap Gemini, Infinity, TCS,


is there any way to know how long the report executes and how many records will be returned before hitting the "run" option?

3 Answers  


What is BOMain.Key?

5 Answers   Cognizant,


when I am trying to schedule the report its running faster then I tried to run it manually?? why is it so that there is difference of time between scheduling and manual run for report

2 Answers  


1. I have 2 universes. that is u1 and u2. From u1,i created one report that is r1. Now i want to give the connection r1 to u2 and at the same time delete the connection from u1 to r1 ? How is it possible explain? 2.How can i schedule the reports in BOXIR2?

4 Answers   IBM,


Example Country Name is like India/UK or ALL In parameter I selected India or UK it should show only perticular country details in BO.If i select ALL in parameter.It should show both country data in different tables.

6 Answers   TCS,


Categories