Multiple choice technology packaged enterprise solutions

Aggregates can be created for which of the following?

  1. MultiProviders

  2. Virtual Providers

  3. DSO

  4. InfoCubes
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

In SAP BW, aggregates (pre-summarized data structures for performance) can ONLY be created for InfoCubes (D). MultiProviders (A) are logical views that cannot have aggregates. Virtual Providers (B) provide real-time access and don't support aggregates. DSOs (C) are for data staging, not reporting aggregates.

AI explanation

Aggregates are pre-calculated, condensed summaries of an InfoCube's data used to speed up query performance. They are built directly against the physical data model of an InfoCube, so they only make sense there. MultiProviders and VirtualProviders don't hold their own physical data (they combine or virtually represent other providers), and DSOs are flat, granular tables not designed for aggregate-based query acceleration, so aggregates aren't created against them.

Keep practicing — related questions