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 |
CAN WE CREATE VIEW IN BO (NOT DERIVED TABLES)?
when to go for alias and when to go for contexts
how to solve the incompatible objects and how they are formed actually.
it is possible to link two universes of separate functional domain ?
what do u mean by merged dimensions in Business Objects
2 Answers Business Intelligence Analytics, TCS,
how many times can use the union operator in a report?
What are the advantages of setting up LOVs in the Universe?
2 Answers Cap Gemini, Deloitte,
What is difference between custom hierarchy and report based hierarchy?
TILL WHAT LEVEL OF SECURITY BO SUPPORTS?
How to hide the table s in webi?can any one tell me plzzzzzzzz
in xir2 how to send reports to end user
wat is difference b/w break and section?