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

In Business Objects 4.1 version what is the alternative name for broadcast agent?

1 Answers   HP,


Is it possible to generate reports without having knowledge of the Universe structure?

4 Answers  


IF I WANT TO INSTALL BO ENTERPRISE PRODUCTS IN WINDOWS 2000 PROFESSIONAL SERVER ,WHAT SHOULD BE THE SYSTEM CONFIGURATION?

1 Answers   AG Technologies,


what is confirm dimension ?

11 Answers   IBM, Wipro,


If I have three predefined prompts. In a report it will come randomly. How they will come in a specified format?

0 Answers  






Can we take report on Excel in Business Objects?

6 Answers   Business Intelligence Analytics, Oracle,


how to restrict null values in webi report?

2 Answers   InfoStep,


Explain as a ba (business analyst) approaching a new piece of work, who would you interview and what questions would you ask?

0 Answers  


User name and password is saved by Business objects when we create repository. and this username and password is saved in Table obj_m_actor table in repository. The password in incrypted form. It is possible to Dycrypt That Password.

1 Answers  


When we r going for Short_cut join & It's Resolution??? Plz provide one scenario??

2 Answers   Rolta, TCS,


date format in report like (22/5/2010 "3:20:15 am") like this i want to remove 3:20:15 remove from report how can we do this in bo xi r2

1 Answers   Honeywell,


Hi,can anybody help me to do like this, i have one dp with agerange, first name ,Address. And another dp is agerange,age min , last name. in this two data providers agerange is common . I want to see in my report all the fields . How i can merge it ?

1 Answers  


Categories