ABC wants to see total products by region by year without doing run-time calculation. Which two of the following would ABC use to solve this business challenge?
A.
Create physical tables in a data source that store pre-calculated measures for grouping of data
B.
build aggregates for all possible level combinations
C.
build an aggregate for a fact source only
D.
build aggregates for both dimension and fact sources