You want to compare the % increase / Decrease in sales figure for each of your real estate agents in each district from a year ago. Which of the following would best suit your need?
A.
Aliases of fact tables
B.
Slowly changing dimensions
C.
Aggregate tables
D.
Extension tables
E.
Header and details data