how do we apply sql query on selected variables?

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to open a universe with out using the Designer ??

6622


How to do impact analysis for a change in Database field size which is assigned to a Dimension object and used in 10 universes

1973


what will be the contents for a functional requirements specifications

1793


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

4450


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

642






what is document design in boxi,have u participate in that

1663


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

587


is it possible to export the webi reports to crystal reports?with out using businessview?

1823


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...

1725


what is universe null

1991


Explain what task is 98% of the required work of a business analyst?

604


Tell me a business scenario where I can achieve the data through MINUS only not through subquery.

2609


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

606


Difference between zabo and webi?

638


Can I create a master report in webi having 15 dimensions and 150 kpi's with 100GB of data and store it in cache ,So that I can use Cache for building new reports with less dimensions and Kpi's without hitting database againg just using cache??Please suggest...

1628