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 r the universe connection types?
Is it necessary to give joins to the aggrigate tables in the universe?
Differences between business objects and web intelligence reports?
What is diff b/w Alias and Contexts in which situation we are using contexts instead of Alias?
how change the order of prompts in bo xi? eg. i create first prompt with 'year' and second prompt with 'city'. my question is to display the 'city' prompt first .what can i do for it ?
what is difference between Rich client web intelligence and Boxir2 web intelligence
Which outer join is used in Merge Dimension. Diff between merge and auto merge dimension.
2 Answers Cap Gemini, Infinity, TCS,
is there any way to know how long the report executes and how many records will be returned before hitting the "run" option?
What is BOMain.Key?
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
1. I have 2 universes. that is u1 and u2. From u1,i created one report that is r1. Now i want to give the connection r1 to u2 and at the same time delete the connection from u1 to r1 ? How is it possible explain? 2.How can i schedule the reports in BOXIR2?
Example Country Name is like India/UK or ALL In parameter I selected India or UK it should show only perticular country details in BO.If i select ALL in parameter.It should show both country data in different tables.