Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / 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.
| Is This Answer Correct ? | 16 Yes | 1 No |
Post New Answer View All 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?
Which property of matrix gives the total number of rows in the matrix ?
What is reconcile Adjustment Account in SAP Business One
Can sap business one be customized?
What are the different types of datasources ?
How is sap business one implemented ?
What will happen if we remove eventfilters ?
Which tool is provided by sap for keeping the track of events ?
Explain different parts of di api?
What are the limitations of di server?
my name is sandeep i want to join SAP Bi/BO hyd. can anyone suggest best institue or tranier with material also .sucess rate of them should be very good.. bcoz its very hard select insistiue in ameerpet...one and other all are same many people are misguided.. failling in interviews...if any one know please help answer this question so this will help others also
Can we load the datatable directly using sql query ?
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?
Which table saves the details of country ?
What is dbdatasource ?
