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 different objects in di api ?
What are the sap business one modules?
Which tool is provided by sap for keeping the track of events ?
Which table saves the details of country ?
What is used in sdk for developing a form ?
What are the different types of datasources ?
Which are the dll’s used in sap business one sdk?
What is the function of observerdll.dll ?
What are the benefits of sap business one?
For performing heavy duty operations what is suitable di api or di server ?
In sap business one sdk, which object is used for executing sql queries and stored procedures ?
can any working guy help me...by explaining me about any twop reports which u have created.....on sales and purchase
How is sap business one implemented ?
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.
Can we do aggregation in sap crm planning cube?