how do u deceided to go create Aggregates for cube. what
purpose u want to create aggregates?
Answer Posted / vivek
you can check it from RSDDSTAT_OLAP table that which query
is being used mostly, and wht is the performance on that
basis you will create the aggregates on the cubes.
Aggregates are the small cubes through which the data
extraction is faster
| Is This Answer Correct ? | 12 Yes | 3 No |
Post New Answer View All Answers
What steps do you take when you add a new company code to the already running delta datasource ? The datasource is already extracting specific company code delta data , so how will add new company code without disturbing delta
How the dimensions are optimized?
When is idoc data transfer used?
What do you mean by start routines
When a query is run with a loop, what does it generate? A) Cartesian product b)An incompatible combination of objects c) An SQL statement generation error d)Results returning too many rows e)Results returning too few rows
how would you do the unloading non-cumulative cubes.
What are the conversion routines for units and currencies in the update rule?
what is the data model and how it is use ?
In compression level all requests are becoming zero which data is compressing tell me detail
What is the attributes only flag?
What is the use of the info area in the sap bw system?
What are the elementary tests you can run?
What is ?User master comparison? in roles?
What is the benefit of using bw reporting over sap reporting?
Name two types of multi providers and compare them to each other?