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 |
Is it possible to join more than one universe in Business Objects? If its so how is that possible ? thanks in advance for the answers
Can we create universe with no cache??
How to take backup of CMS database and Auditing database, please suggest me with a best possible ways.?
What are Alerter, Filters, Breaks and Conditions?
Ihave one report.Now i want to display that report as one row as one color and another row as another color.The entire report i need like that
Can we get the data from two different databasess in reporting level?
what is the difference between breaks and sections?
Shall we connect to the oltp systems directly .,
it is possible to link two universes of separate functional domain ?
what r the advantages of creating the universe?
What are the steps to be taken to schedule the report?
please explain me with the real time tables on how aggregate tables are created and how aggregate awareness is addressed to it.