Interested to Buy Any Domain ? << Click Here >> for more details...
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
How would you change the default template?
What is update routines.
What is extended star schema? Which of the tables are inside and outside cube in an extended star schema?
Explain ods?
What is the alpha check execution program?
What is scoring ?
I have 3 cubes for that I created multiprovider and I created a report for that but I didn’t get data in that report what happen?
How we do the sd and mm configuration for bw?
What is an infocube? What are its different types?
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
Which datastore object is used?
You want to see if the execution of a query has been slow or fast. How would you do that?
WHAT IS PBJECT DOCUMENTATION? WHERE YOU CAN DO IT? WHAT IS THE USE OF THAT?
Where do we use write optimized dso?
What is an open hub service?
