Answer / hari priya

When we access the data frequently for reporting and when
the data is in huge quantity, we face delayed data retrival
problem.
To overcome this problem we can go for aggregates.

This improves the query performance.

Answer / vivek

you can check it from RSDDSTAT_OLAP table that which query
is being used mostly, and wht is the performance on that
basis you will create the aggregates on the cubes.
Aggregates are the small cubes through which the data
extraction is faster

best institute in ameerpet for SAP bi/bw

4 Answers  

---

WHAT IS THE MAIN DIFFERENCE BETWEEN INFOPACKAGE & DTP? WHAT ARE THE REPEATED TABLES WE ARE USE IN REALTIM PROJECTS? WHAT IS THE DELTA UPDATE IN LOCOCKPIT? WHAT ARE THE TABLES IN SD,FISL & MM? How to we modify the processchain running errors? what is the repeated error in realtim projects? tel me the realtime flow & hw to answer the interview level?

4 Answers   TCS,

---

can any one explain me...... what are the difference between Extractor queue and delta queue?

3 Answers  

---

What are the conversion routines for units and currencies in the update rule?

0 Answers  

---

When a query is run with a loop, what does it generate? A) Cartesian product b)An incompatible combination of objects c) An SQL statement generation error d)Results returning too many rows e)Results returning too few rows

0 Answers  

---

how to display the date formats for example i hava a year like 2010 to 2011 bu i want to display in report like 2010-11 can u please explain this

0 Answers  

---

List the tools to monitor overall query performance.

0 Answers  

---

What is the transaction to check extractor?

2 Answers  

---

How many dimensions in a cube?

4 Answers  

---

What are the limitations of line item dimension?

1 Answers  

---

When iam executing infopackage status is showing yellow for hours by hours what i have to do?

2 Answers   TCS,

---

how can we enhance the datasources,explain me with example?

4 Answers   Satyam,

---