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 |
How would I achieve Traffic Lighting in Business Objects
IS IT POSSIBLE TO CREATE REPORTS FROM DIFFERENT UNIVERSES IN ONE DOCUMENT?
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?
what is a Micro cube?
How to add additional objects or tables into the universe,and what are steps we need to follow to achieve the above task.
how to create a derived table in designer? i need steps regarding derived table
Hi , iam beginer in the Boxi . I am getting errors when i applying the @promtps and functions. I want alredy created universe and i absorve the things how those were applied . is it possible to get it throug internet? if it is possible could u plz help me? anandh1110@gmail.com
What is a universe?
. User wants to modify a report and wants to add additional data. How will you approach.
How to Analyise 'Join' problem and which method is the best to resolve that ?
Iam having an report it contain n number of rows i want to desplay each rows in one colur pls explain me its very important
WHAT IS CARDINALITIES OF JOIN?