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

Regarding Hyperlinking in Business Objects. We have a few reports in QA environment where a number of hyperlinks are employed using OpenDoc function.In some of the reports,hyperlink is used to move to another tab within the same report.The formula used include "DocID" and ReportName="tab name".This works fine but now,for the PROD move,this will not work as the Doc Ids are subject to change. Is there a way to overcome this?Without DocID,how will move to a particular tab? Thanks in advance

4692


Explain are data mart and data warehouse normalized or denormalized? Do both of them exist in?

770


What is Indexing? how did u implement indexing?

1935


what will be the contents for a functional requirements specifications

1986


what is the difference b/w the refresh and buffered data?

1944






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

1802


1. 101 vinay hyderabad 123 naresh usa 152 singh delhi 101 vinay usa 123 naresh mumbai 156 raju chennai From the above data we need to retrive current data in a report ? how and explain in detail ?

6314


Are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?

764


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

830


Explain what are the measure objects?

690


Explain about a time when you discovered a more efficient way to do a work task?

807


Explain how to execute the plsql procedure from the report by clicking with mouse?

751


What are all difference between business objects 6.5 and xi r2?

745


What would you consider as your biggest achievement and why?

748


what is the difference between add link and include link in BO? Explain me with a scenario when to go for add link and when to go for include link?

10208