What advantage of ic with aggregates?
Submitted by: Administratorif 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.
Submitted by: Administrator
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.
Submitted by: Administrator
Read Online SAP B1 Job Interview Questions And Answers
Top SAP B1 Questions
☺ | Explain difference between transfer rule&update rules? |
☺ | Explain process chain failure notifications? |
☺ | Can we load delta load directly without full load? How? What are the steps? |
☺ | How to schedule the process chain "in a month first five days "i have to schedule the process chain? how? |
☺ | Why is there a restriction of 16 Dim tables in an Info Cube and 16 key fields in an ODS? |
Top ERP Categories
☺ | SAP Basis Interview Questions. |
☺ | SAP SD Interview Questions. |
☺ | SAP MM Interview Questions. |
☺ | SAP ALE IDocs Interview Questions. |
☺ | SAP PP Interview Questions. |