1.

What Are Aggregates And When Are They Used?

Answer»

• An aggregate is a materialized, aggregated view of the DATA in an InfoCube. In an aggregate, the dataset of an InfoCube is saved REDUNDANTLY and persistently in a consolidated form. Aggregates make it possible to access InfoCube data QUICKLY in Reporting. Aggregates can be used in following cases:

  • To speed up the execution and NAVIGATION of a specific query.
  • Use attributes often in queries.
  • To speed up reporting with characteristic hierarchies by aggregating specific hierarchy LEVELS.

• An aggregate is a materialized, aggregated view of the data in an InfoCube. In an aggregate, the dataset of an InfoCube is saved redundantly and persistently in a consolidated form. Aggregates make it possible to access InfoCube data quickly in Reporting. Aggregates can be used in following cases:


Discussion

No Comment Found

Related InterviewSolutions