how do we apply sql query on selected variables?

Answers were Sorted based on User's Feedback



how do we apply sql query on selected variables?..

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

how do we apply sql query on selected variables?..

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

how do we apply sql query on selected variables?..

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

More Business Objects Interview Questions

What is meant by Adhoc reports?Can any body will explain with examples...Thanks in Advance .........prakash

7 Answers   TCS,


What is sdlc in bo?

2 Answers  


Can i use personal database connection to the Webintellegence reports?

1 Answers   Infotech,


generally how do we get information for creating universes and reports

1 Answers   Satyam,


Can any one gve me the complete information abt Certfication of Business Objects ?

2 Answers  


What is meant by data federator and what is the use of it?

2 Answers   TCS,


what are the types of universes? what is the difference between metri universe and simple universe? in what context we use metric universe?

4 Answers   Fujitsu, Virtusa,


Hi, Webi report is created using universeA and this report needs to be shifted to UniverseB.So when i am trying to change report to new universeB from edit query properties, the report just hangs at the point of changing source to target.The reports which hangs mainly are the crosstab reports that has large data and many formulas. Any help on this is much appreciated. Thanks

1 Answers  


Anyone suggest where can i get SAP Business Objects dumps for the below: C_BOE_30 C_BOWI_30 C_BOWI_40 C_BOBIP_40 C_BOBIP_41 C_BODI_20 C_BOSUP_90

1 Answers   CSC,


WHAT IS INPUT CONTROL IN BO?

3 Answers   PWC,


WHAT ALL DIFFERENT OPTIONS PRESENT IN WEBI?

1 Answers   Wipro,


What is Indexing? how did u implement indexing?

1 Answers   TCS,


Categories