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

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

715


WHAT ARE THE META DATA TYPES?WHICH META USING IN BO'S

1780


Which command using Query Analyzer will give you the version of SQL server and operating system ?

4335


How many universes can be created in a project?

678


Can Bo generates the Report from the cubical data Explain?

1704






If 2 tables are joined by Shortcut join, if query is generated based these join, what will be the join type and what will be the generated query? Thanks in advance?

1868


BO Security (creating the restriction sets in Universe and applying on selected groups or users) or Database security (Creating the tables in database insrting the user details in that tables and giving conditions in self restricting joins in Universe )Which Security will improve the performance of the reports and for best practices ? I am thinking BO Security will give the better performance, could you please share your thoughts on this please... Thanks...

1811


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?

10083


how to create metric universe ?

1997


What is a fantrap in business objects?

684


Is there any other repository domains rather than universe, security, document?

702


what is xcelsius architecture?

3847


Explain about an assignment you worked on in which you had to amass a huge amount of data, and then analyze it?

783


Explain what is the difference between business requirement document and use case document.

669


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

4610