How ASO Works and How to Design for Performance • 255
• ([Price Paid], [Prev Year], [1 to 13 years])
• ([Price Paid], [Prev Year], [14 to 19 years])
• ([Price Paid], [Prev Year], [50 to 64 year
A View aggregated only at level-1 of the [Age] dimension would have records for:
• ([Original Price], [Curr Year], [Teens])
• ([Price Paid], [Prev Year], [Teens])
• ([Price Paid], [Prev Year], [Senior])
How many records would be in the resulting set overall? at is hard to determine,
unless we make a few assumptions: at data had existed for all 9 level-0 members of
[Age] and that any combination of the other dimensions that existed, existed equally
(i.e., there were the same combinations of all other dimensions) for all 9 members, then
we can say that ...