how do we apply sql query on selected variables?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How would you format some text using css to be verdana and bold?

867


Migration of Reports from business objects 5.1.5 to samee version in different hardware?

2094


What's the Functional & Architectural Differences between Business Objects & Web Intelligence Reports?

1878


Give some information on report bursting?

756


What is the difference between business requirement document and use case document.

776


Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye

1633


What is the dense rank?

841


What is the difference between condition & filter?

1161


Can anybody tell me what are the tuning problems?

1786


Explain and tell me about a situation where your analysis of a problem was deemed to be incorrect? What would you have done differently?

1030


I have set of reports in BO4.0 and need to use "Hyperlink" functionality. I had to use native hyperlink functionality provided in BO4.0 but looks like it's available only in Rich Client.Currently,we have only Infoview B04.0 Launch Pad.Is OpenDoc the only hyperlink option on BO4.0 Launch Pad? Thank you.

3217


When to use local filter and when to use global filter?

769


Explain in detail about type 2(scd),

794


Can more than 1 metric be applied on an analytic in business objects?

1855


any difficulitis have you phase while creating bo reports and how did u solve it

3174