Multiple choice technology architecture

If we have to calculate an average, it should be achieved at

  1. Universe level

  2. Report level

  3. Database level

  4. None of the above

Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Averages should be calculated at the report level where they can be dynamically computed based on current data filters and query context. Universe-level aggregation is less flexible and database-level aggregation doesn't adapt to report-level conditions.