Database Reference
In-Depth Information
9.
Create a third user-defined hierarchy for titles grouped by Publishedmonth,
PublishedQuarters, and PublishedYears. You can do this by dragging and dropping
the PublishedYear attribute to the Hierarchies section of the dimension editor. This
creates a new hierarchy.
10. Afterward, drag and drop the PublishedQuarter attribute just beneath the
PublishedYear attribute in the new hierarchy (Figure
10-18
).
11. now, drag and drop the Publishedmonth attribute just beneath the PublishedQuarter
attribute in the new hierarchy (Figure
10-18
).
12. Finally, drag and drop the Title attribute just beneath the Publishedmonth attribute in
the new hierarchy (Figure
10-18
).
13. Rename the new hierarchy to TitlesByPublishedDate using the Properties window.
when you are finished, your dimension editor should look like Figure
10-18
.
Figure 10-18.
The final stage of the dimension editor
