what advantage of ic with aggregates

Answer Posted / 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)

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is ‘sap business one’?

610


What are the sap business one modules?

614


For performing heavy duty operations what is suitable di api or di server ?

591


What is the use of company object in sap business one ?

599


What is reconcile Adjustment Account in SAP Business One

2567






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

604


Where does di server executes i.e. Client or server ?

609


can any one explain end routine...like when it is used...and give an examole.......similarly for end routine..

1958


If we are Extracting Data From SD Application component.ie Ex:- sales and billing 2lis_11_vahdr & 2lis_13_vdhdr Data Sources.Can I load From These 2 Data Sources to sales overview Cube 0sd_c03.Can you Explain the procedure.

3018


What is the function of observerdll.dll ?

803


Why sap business one?

675


What is difference between transfer rules and update rules?

589


hi frnds dc's suma could u tell me. 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 ? what is cell formatting? and advantages?

2173


In sap business one sdk, which object is used for executing sql queries and stored procedures ?

571


Is it possible to alter the standard behaviour of sap business one using sdk ?

597