why u go for aggregate? tell me one example?

Answer Posted / anand

Aggregates are the Small Cubes.We create Aggregates only on
Cubes.We use this Aggregates to Improve the Reporting
Performence.Inspite of fetching the Whole data from Cube we
can selectively Fetches the data with aggregates.

Is This Answer Correct ?    14 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a validity determining characteristic?

1606


what is structure in reporting?

1128


Differentiate between v1, v2, v3 jobs in extraction.

588


What are the combined tests?

1486


What is the licensing requirement you should be aware of?

1651






What is partitioning and what are the benefits of partitioning in an infocube?

606


What are the advantages of BW 3.x web server (WAS)?

1685


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

1874


Explain the display properties?

1800


How we do the sd and mm configuration for bw?

637


Give an example for this URL command?

1676


Is it possible to create aggregates for cumulative?

1749


What is the importance of 0requid?

691


What is the read mode in generic navigation block web item- read mode specifies

1688


How do you transform open hub data?

764