Answer Posted / babu
if we create aggregates on infocube then query performance
will be improved if our query accessing attributes data
frequently.The sequence when we execute the query is:
1.Query first goes into cache if it finds relevant data in
cache will fetch data otherwise
2. it goes into BI ACCELERATOR(BIA)
3. Aggregates
4. Finally it goes into IC if the data is not available in
above 3 stages.
If we maintain aggregates or BIA olap no needs to come
upto IC. So time will be reduced. Query performance will be
improved.
| Is This Answer Correct ? | 16 Yes | 1 No |
Post New Answer View All Answers
What is reconcile Adjustment Account in SAP Business One
What is dbdatasource ?
Why sap business one?
What is used in sdk for developing a form ?
What are the different types of transactions supported by di api ?
Explain different parts of di api?
What is the value returned by a method when it executes successfully?
How is sap business one implemented ?
What are the different objects in di api ?
What are the limitations of di server?
Can we do aggregation in sap crm planning cube?
What is company object in sap business one ?
What is the function of ui api i.e. User interface api ?
Where does di server executes i.e. Client or server ?
What is the value returned when any method of a di api object executes successfully?