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.

Name of the tool used for unit testing

1 Answers   IBM, TCS,

AFTER A PURCHASE ORDER HAS BEEN APPROVED, AND PRINTED, AND THERE IS NEED TO MAKE CHANGES ON THE P O, DO I CANCEL THE OLD P O OR DO I JUST EDIT AND SEND FOR APPROVAL?

4 Answers  

hi 1.while monitoring process chains i got an error that "activation was failed"what is the reason for failure and how did u solve that problem? 2.Process chain is going on running but it is not completing ,stopping?what are the necessary steps we have to take to solve the problem? 3.If there is any duplication in the cube ,how to rectify it and how to solve the duplication in the cube? 4.we have created one new field in the extractions which is not presented in the communication structure ,but the problem is how to bring the created field in to the cube? 5.what is meant by compressin? here the problem is we are deleting the request id,s what about the data depending on the id? 6.For improving the query we will create aggregates ? how the internal process will takes place to improve the query? what is meant by aggregate? 7.how to schedule the process chain "in a month first five days "i have to schedule the process chain? how? 8.what is meant by archiving? Support question service level aggrement: If we are unable to solve the ticket with in the service level aggrement? what are the necesary steps we have to take? these are the question i have faced on ibm interview,ok byee thanks&regards suresh kumar

4 Answers   IBM,

What are the benefits of sap business one?

0 Answers  

what is concept behind incoming payment and outgoing payment?

2 Answers   Wipro,

What are the different components of sap business one client software ?

0 Answers  

What is used in sdk for developing a form ?

0 Answers  

Hi,Could you plz explain me Diff between transfer rule&update rules

2 Answers  

How to fill data in recordset ?

0 Answers  

What are the different objects in di api ?

0 Answers  

What is company object in sap business one ?

0 Answers  

What are the sap business one modules?

0 Answers