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 .

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.

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.

How can we acheive Correlated sub-query in Designer?

2 Answers   Infosys, TCCX, Wells Fargo,

---

There is one report running and a user wants to know whether data is from detail table or summary table. what is your approach?

1 Answers  

---

how to do Ad-hoc reporting ?

6 Answers   IBM,

---

Explain is there any default username & pwd for bo designer & supervisor?

0 Answers  

---

what is fantrap?

2 Answers  

---

What are the errors u have faced in creating reports in business objects and explain some?

3 Answers   TCS,

---

how we improve the performance of report and universe?

4 Answers   Accenture, IBM,

---

'Add objects to the folder' (id - 1) for 'Auto Loans' (id - 2626). Please contact your system or permissions administrator if you require this right.

1 Answers  

---

Instead of cms which server you have to use?

2 Answers   CTS,

---

what is crosstab reporting,slice and dise and drill mode??

3 Answers  

---

What is the difference between the Webintelligence and desktopintelligence?

2 Answers   IBM,

---

What is global filters and local filters

3 Answers   IBM,

---