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 |
what is variable ?
if i hv 2 reports in one block... first report contains ten rows and second report contains 100 rows. my question is ....if i want to enter the values into first report(i want more than ten rows in first report)..is it possible to get ..
can any one tell me how to create a new universe from scrach with step by step process.
limitaions of cross tab ?
1.what is context? How u create? With example.
i want my connection to be dynamic. How can I make it. I mean the username and password should be dynamic. How?
difference between xir2 and 6.5 version
if we run a report it is taking so much time to display the report,what to do to increase th performance of the report
How do u get requirement from the client? in what format?
What are the advantages of setting up LOVs in the Universe?
2 Answers Cap Gemini, Deloitte,
how to solve the incompatible objects and how they are formed actually.
what is universe