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

GENARALLY HOW MANY REPORTS ARE CREATE FOR EACH ONE ?PLZ EXPLAIN AFEW FOR AUTOMOBILE PROJECTS?

4 Answers  


how to coneect to a server in a business objects

1 Answers  


I have 2 doubts regarding the "Input Control" functionality in BI4: 1) Can the Input Controls in BI4 be manipulated? I mean, can we change the IC display as BOLD or change the values from Italics to regular? Or change the colors? 2) How to get hierarchy type control in IC? Let's say my first IC is for Country and second is for State. If I select a particulat country from Ist IC,second one should show me states belonging to selected country. Is that possible? Thanks in advance!!!

0 Answers  


what are the documentations u r created?

2 Answers   Wipro,


Can we Save (save as) WEBI Doc as DESKI?

2 Answers   HCL,


Explain what sort of existing documents should business analysts refer to when starting on a new project?

0 Answers  


How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?

0 Answers  


How to Implement the the Built-in Strategy Script in BO Designer?

2 Answers   Infosys,


Can you please send me the migration related issues .

0 Answers  


Hi All, I have found out this site very interesting and knowledge sharing site.I was wondering if you can tell me where I can get study materials for the BO XI 3.1 or suggest me the one that you have taken recently. Regards, Ace

1 Answers  


What is mean by stored procedure ? and how we can generate stored procedure universe?

3 Answers  


what is crystal reports?how to migrate them?

2 Answers   IBM,


Categories