Chapter 8. Aggregates and Multi-Cubes
Most users need to access only a subset of information in an InfoCube. In Section 6.2, for example, the East region users were not allowed to access other regions' data. In that case, we could create a new InfoCube, which contained only the East region sales data, a subset of the original InfoCube. Because the new InfoCube is smaller, the required disk I/O volume during query execution will be smaller, too, and the East region users would therefore see improved query performance.
SAP implements this idea in BW and calls the new InfoCube an aggregate. An InfoCube can have multiple aggregates, and the aggregates are transparent to users. It means that we create queries upon InfoCubes, not aggregates. For a query ...
Get SAP® BW: A Step-by-Step Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
