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 |
when I am trying to schedule the report its running faster then I tried to run it manually?? why is it so that there is difference of time between scheduling and manual run for report
what r the types of joins universe supports
In a Webi Report, Once u r entering a month name,it displays the that month details and after and before month details.How it is
filename would be GCP_ARS_BO_TM_BERT MMDDYYYYHH24MISS.xls. how to do it?
Hi, i have 10 data providers in report? i want to see only two data providers remaining are hide? how can do it? Thanks&Regards raghu.shiva
2 table is there , thats column is different name but data type is same, 2 tables values are same. how to you findout both values are same?
If there is no common dimension? Is it possible to combine two different dataproviders?
What is the use of linling the universes?Thanks in advance
What is the test methodology for testing BO Universes?
Explain what are the measure objects?
What are all difference between business objects 6.5 and xi r2?
What is the error that occurs while detecting the cardinalities in the universe pane if we create a join between the normal table and the aggregate table...