how do we apply sql query on selected variables?
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
hi my question is in a report table how can we write table header without using of individual cell.can we merge column cells togrther??
What is Cartesian product?
What Is Snow Flake Schema?
how to improve the performance of the report
how do u migrate BO 6.x to XI ? My Mail id is gunal_prabhu@yahoo.co.in
What are the Users and User groups?
What is the pivot option ? what is the need of it?
what is difference between Rich client web intelligence and Boxir2 web intelligence
what is zero client and thin client ?
What services the broadcast agent offers on the server side?
Hi Can anyone tell me what is Divergence in Business Object Universe Designer. Thanks, Sheik
Can any body tell me,What is the universe testing ? What is the report testing Explain?