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 are the different objects in di api ?
hi guys, now i am working in very small company for SAP_BusinessOne...after getting 3 years of exp in this company ..can i move to LEVEL5 Big Mnc's? any chance is there? or can i change technology instead of B1?
What is the value returned when any method of a di api object executes successfully?
How to fill data in recordset ?
hi frnds dc's suma could u tell me. 1. expalin u have created any customize cube? 2. what is ur exp in bex and wad? 3. howmany reports u have created? give one scenario abour calculated key figure and formula? 4. tell me some recently what u have done tickets give me 2 tickets explain briefly? 5.what they (off shore team) have done ? what is cell formatting? and advantages?
What is di api in sap business one?
What are the complex reports you developed in Business Objects.Please tell me 3 reports you developed and the complexity you faced and the solution
Where does di server executes i.e. Client or server ?
What is the function of ui api i.e. User interface api ?
What is di server in sap business one ?
What are the functions of data interface api (di api)?
Which table saves the details of country ?
Which tool is provided by sap for keeping the track of events ?
Why sap business one?
Which property of matrix gives the total number of rows in the matrix ?