Multiple choice technology packaged enterprise solutions

Aggregates can be created for which of the following

  1. Multiproviders

  2. InfoCubes

  3. DSO

  4. Virtual Provider
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

In SAP BW/BI, aggregates can only be created for InfoCubes. Aggregates are pre-summarized data structures that improve query performance. InfoCubes are the physical data store that supports aggregation. Multiproviders are logical views that combine multiple providers but don't store data. DSOs (DataStore Objects) and Virtual Providers don't support aggregate creation.

AI explanation

Aggregates in SAP BW are pre-calculated, summarized data sets built on top of an InfoCube to speed up query performance. They are defined directly against InfoCubes (not against Multiproviders, DSOs, or Virtual Providers, which either combine other objects or aren't optimized for that kind of pre-aggregation), so InfoCubes are the object type aggregates are created on.

Keep practicing — related questions