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
What is automatic loading of similar/identical requests option?
You want to see the error idocs. Tell the navigation you would use.
R/3 extraction failed - recovery procedure? R/3 extraction is running from past 2 years. Suddenly it failed since 5 days and again today it is running fine. But how i do get data loaded to cube for failed loads? What are the procedures that can be followed?
How would you change the default template?
Explain table partition?
Give some examples of queries delivered with BW statistics?
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
What do you mean by start routines
What is a control query?
What are the data target administration tasks?
How will you add buttons to a template?
What is the purpose of sap bw/bi?
What is the advantage of CO-PA?
What is persistence mode in cache?
How would you do the archiving cubex.