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.

what are the table created when you created a infoobject

4 Answers   Accenture, IBM,

Hi, I am currently working in midsized company in SAP Business One after getting two years experience can i move to MNC company with SAP B1 or can i change technology to SAP ABAP na Please suggest me......

1 Answers  

Hi. My name is Maya. I am new in SAP B1. I have a task to reset SAP B1 system and upload Opening Balance (OPBAL) in my company. Could anyone teach/show me 'how to' how do it, please? Ty

2 Answers   TIS,

Name of the tool used for unit testing

1 Answers   IBM, TCS,

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

0 Answers   Mind Tree,

what is cell formatting? and advantages?

0 Answers  

What are the functions of data interface api (di api)?

0 Answers  

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

1 Answers   Atos Origin, L&T,

What is the value returned when any method of an di api object executes successfully ?

0 Answers  

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

1 Answers   IBM,

Which are the dll’s used in sap business one sdk?

0 Answers  

how to migrate the cube data from bw to bi? explain and give me the steps

3 Answers