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.

can any working guy help me...by explaining me about any twop reports which u have created.....on sales and purchase

0 Answers   IBM,

Name of the tool used for unit testing

1 Answers   IBM, TCS,

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

0 Answers  

i am raj i have attended lot of interviews but i could not get job. the interviwer asking me some real time scanrions please tell me any one . 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 ?

1 Answers   Deloitte,

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

1 Answers   SAP Labs,

can we load delta load directly without full load ? how ? what are the steps

3 Answers   IBM,

What is di server in sap business one ?

0 Answers  

Which tool is provided by sap for keeping the track of events ?

0 Answers  

WHERE DO YOU STORE THE MASTER DATA IN BI 7.0

8 Answers  

How we know, whether we have to use DSO or Infocube for particular data source?

2 Answers   ABC,

process chain failure notifications

1 Answers   iGate,

What is the value returned by a method when it executes successfully?

0 Answers