124Solving Operational Business Intelligence with InfoSphere Warehouse Advanced Edition
–Rename CDR_MO_NM to MONTH
–Rename CDR_MO_NUM MONTH_OF_YEAR
–Rename DAY_NUM_CDR_YR to DAY_OF_YEAR
Click OK to add these new attributes to the model, as shown in Figure 4-23.
Figure 4-23 New calendar attributes added to dimension
3.Expand the Levels directory and right-click the Levels heading. Select Add
Level. Give the new level a name; in our case, we start with YEAR. Select the
Chapter 4. Data modeling: End to end 125
Time or Date type option, and the ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month, and much more.