Answer / tilak

1)usinf aggregated tables
2)using shortcut joins
3)removing unwanted classes and objects
4)removing unwanted joins
5)lov should be based on smaller look up tables

Answer / subhash

By making use of Aggregate tables.

Explain about MTD(Month To Date) and YTD(Year To Date) with one example and where you use this in your project?

2 Answers   TCS,

---

Draw the architecture of traps?

3 Answers   Wipro,

---

Did you face any problems while creating reports? Name? Solutions?

0 Answers   IBM,

---

u drag 2 sources from 2 diff dataproviders,how we take these 2 sources into 1 single report, how we give the link these 2 sources

4 Answers   IBM,

---

how can i add two different reports in the same document?

5 Answers   TCS,

---

How to take backup of CMS database and Auditing database, please suggest me with a best possible ways.?

1 Answers  

---

What is a loop? How can we overcome?

5 Answers  

---

how to optimize the query perfomance in b.o?

1 Answers   TCS,

---

what is optional prompt in boxi r2

4 Answers   Mind Tree,

---

My data source is Excel sheet. How to write the SQL Statement for Excel file in data provider? Is is possible?

3 Answers   TCS,

---

What are the Input and Output Context Operators.

4 Answers   Bosch, iNautix,

---

How can I display the query execution time for a particular DP on Web-I report? Or is there any other way to know the 'exact query execution' time at BO end?

1 Answers  

---