how do we apply sql query on selected variables?

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the data types present in bo? What happens if we implement view in the designer and report?

803


What is aggregate table and aggregate fact table ... Any examples of both?

805


i want my connection to be dynamic. How can I make it. I mean the username and password should be dynamic. How?

1807


Explain what is aggregate table and aggregate fact table ... Any examples of both?

837


What Is Snow Flake Schema?

885


please explain me with the real time tables on how aggregate tables are created and how aggregate awareness is addressed to it.

1752


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

2041


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

907


What are the steps to do to use alerts in bo?

858


in sap bi we have wad, then why we go for sap bo

3041


how many reports have u created ? explain a few.

1850


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

1886


What is Indexing? how did u implement indexing?

2011


what are the day to day activities of BO administrator ?

2534


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

2850