Answer / 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.

Answer / kalyan

the main advantage of infocube with aggregates is,it will
increase the performance .

Answer / sd. abdul rawoof

hi frd aggregate means 1 st say all people improve the query performance.
1. query send request to olap cache, olap cache send request to Ic (data base table)
2. Ic retrieve the data into olap & olap send data into query.

imp: query send request & receive data is called front end time

ic receive request & retrieve data is called db time

processing the data is called olap time.

selected records means sending records db to olap
transfer records means sending olap to query.

Dis Advantage:-

decrease the loading performance.

redundancy of data (data loading one ic to another)

Answer / samar

what advantage of ic with aggregates
good question dear by doing /filling aggregates you can
improve the query performance .by doing agg you will get
summarized data so that no redundancy occur .

Answer / babu

whenever the query execution time is taking more than 500 seconds at that time we are going to create aggregates. if our infocube is having aggregates at the time of execution the query is going to pick the data from the aggregates. so the performance will be increased.

Answer / ravi

The main advantage of infocube with aggregates is used for
Multidimensional Reporting with Quick Access.

how to get certification for SAP B1? What are all the institutes in mylapore and T-Nagar for SAP B1?

1 Answers   SAP Labs,

How do wé delete '0' values in the crm planning infocube 0crm_c01

1 Answers   ITC Infotech,

you run info package in process chain level you got error how to delete that one

1 Answers   IBM,

What is a/r invoice ?

0 Answers  

what is report to report interface and why we use it sap bi

1 Answers   Atos Origin, L&T,

What is a/p invoice ?

0 Answers  

What is reconcile Adjustment Account in SAP Business One

0 Answers  

Can we do aggregation in sap crm planning cube?

0 Answers   Wipro,

What is di api in sap business one?

0 Answers  

what is cell formatting? and advantages?

0 Answers  

What is the function of ui api i.e. User interface api ?

0 Answers  

Hi Friends, 1) What precautions i should take as a BI Consultant when it is to UPGRADE the version of ECC (Eg: from R/3 to ECC 6.0)? 2) Will this upgradation affect BI system anyway?

0 Answers   CMC,