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
What are the benefits of sap business one?
What is difference between ap or a/p and ar or a/r?
What is difference between matrix and grid in sap business one?
What is the value returned by a method when it executes successfully?
What are the limitations of di server?
Explain core modules of sap business one?
What are the different types of datasources ?
Hi everybody, This is Srinu,recently i got selected for a small comapny with sap b1 but i was new to the technology.I knew c#.net,asp.net,Sql server 2005.My question is what are the pre-required knowledge to learn SAP B1 please suggest me. Thanks & Regards.
In sap business one sdk, which object is used for executing sql queries and stored procedures ?
How to fill data in recordset ?
hi guys, now i am working in very small company for SAP_BusinessOne...after getting 3 years of exp in this company ..can i move to LEVEL5 Big Mnc's? any chance is there? or can i change technology instead of B1?
What is di server in sap business one ?
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
What will happen if we remove eventfilters ?
Why sap business one?
