Answer Posted / mohan
when my query hits same characterstics and keyfigures daily to reduce the query time i made an aggregate with that particular info objects..
Adv is improve the query performance.
disadv is it takes extra space for same data.so if your customer accepts then you create aggregates or else if it satisfy Thumb rules.
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Give an example of the content key figure OTOTALSTCK (quantity total stock)?
How does a navigational attribute differ from other attributes in terms of linking it with the infocube?
Explain table partition?
Which datastore object is used?
List the steps to configure sd and mm for bw.
How would you change the default template?
What is the t-code for query monitor?
What are the steps to create classes?
Do you have any idea how to improve the performance of the bw?
what is direct schedule and what is meta chain
What exactly do you know about business warehouse statistics?
Can you tell something about the data ware-house hierarchy?
What are the Oracle specific tuning should be done?
What is an exception cell?
Describe transfer rules?