What Perfornialice Improvement Call We Do For Reporting?

1.	What Perfornialice Improvement Call We Do For Reporting?
Answer» Aggregates OLAP cache Pre-calculated web templates Use small amount or result data as starting point of any queries and do the drill down. Avoid reporting on ODs and use INFOSET containing ODs for reporting. If you use exclusion in reporting (< >), the indices are not used. So avoid using the exclusion but use INCLUSION. Use the read mode "H" read when navigating and expanding hierarchies". Use compression on Infocubes since the E table is optimized for queries. Create additional indexes. Run DB statistics often. Use secondary indexes on ODS active table. Use RSRT TRANSACTION to look at the "Explain Plan" statement. If you are running a query on an info provider with non cumulative key figure then suppress summary line items (totals)

Answer»

Aggregates
OLAP cache
Pre-calculated web templates
Use small amount or result data as starting point of any queries and do the drill down.
Avoid reporting on ODs and use INFOSET containing ODs for reporting.
If you use exclusion in reporting (< >), the indices are not used. So avoid using the exclusion but use INCLUSION.
Use the read mode "H" read when navigating and expanding hierarchies".
Use compression on Infocubes since the E table is optimized for queries.
Create additional indexes.
Run DB statistics often.
Use secondary indexes on ODS active table.
Use RSRT TRANSACTION to look at the "Explain Plan" statement.
If you are running a query on an info provider with non cumulative key figure then suppress summary line items (totals)

Discussion