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

which is the best way to resolve loop context r alias why?

3 Answers  


Can we get the data from two different databasess in reporting level?

1 Answers   Infotech,


User name and password is saved by Business objects when we create repository. and this username and password is saved in Table obj_m_actor table in repository. The password in incrypted form. It is possible to Dycrypt That Password.

1 Answers  


What is maximum number of promts we can give in a BO report?

1 Answers   Patni,


What is the difference between business requirement document and use case document.

0 Answers  






1) How to get multi values in a single prompt? 2) How to get ALL in @prompt? 3) Select 1 from fact table? What will be the result? 4) I have created 1 universe say A and generated 100 reports on the universe? Later i had renamed the Universe as A1 and added some objects? Now how i will get the newly added objects in old reports?

1 Answers   iGate,


What is Complex Reports?

3 Answers   TCS,


why less number of records in loop? why more number of records in traps?

1 Answers   Wipro,


what is performance tunning in BO in report level& designer level?

1 Answers   IBM,


how do u implement dense rank in bo reports?

2 Answers   CTS,


Can anybody tell me the difference b/w canned and adhoc reporting?.

5 Answers  


what is tuning of business reports ?

5 Answers   Business Intelligence Analytics, Oracle, TCS,


Categories