Description of the illustration dwhsg075.eps
This figure illustrates a rollup for a dimension with two hierarchies. In it:
-
year: is at the top of the dimension hierarchy
-
quarter: is below year
-
month: is below quarter
-
day: is at the bottom of the dimension hierarchy
In addition, there is a second rollup. In it:
-
fis_year: is at the top of the dimension hierarchy
-
fis_quarter: is below fis_year
-
fis_month: is below fis_quarter
-
fis_week: is below fis_month
-
day: is at the bottom of the dimension hierarchy
Therefore, day rolls up both hierarchies.