My first Publication Agile-Data-Warehouse-Design-eBook

XIV Agile Data Warehouse Design Previous Value Attribute Pattern .............................................................................................. 188 ! Human Resources Hierarchies ................................................................................................ 189 ! Multi-Valued Hierarchy Map Pattern ........................................................................................ 190 ! Additional Multi-Valued Hierarchy Map Attributes................................................................. 191 ! Handling Multiple Weighting Factors..................................................................................... 192 ! Updating a Hierarchy Map ....................................................................................................... 192 ! Historical Multi-Valued Hierarchy Maps ................................................................................... 193 ! P RODUCT AND S ERVICE D IMENSIONS ................................................................................................ 195 ! Describing Heterogeneous Products ....................................................................................... 196 ! Balancing Ragged Product Hierarchies ................................................................................... 196 ! Multi-Level Dimension Pattern ................................................................................................. 198 ! Parts Explosion Hierarchy Map Pattern ................................................................................... 201 ! S UMMARY ........................................................................................................................................ 202 ! CHAPTER 7 WHEN AND WHERE: DESIGN PATTERNS FOR TIME AND LOCATION ........................................ 203 ! T IME D IMENSIONS ............................................................................................................................. 204 ! Calendar Dimensions............................................................................................................... 205 ! Date Keys.............................................................................................................................. 206 ! ISO Date Keys ...................................................................................................................... 207 ! Epoch-Based Date Keys ....................................................................................................... 207 ! Populating the Calendar........................................................................................................ 208 ! BI Tools and Calendar Dimensions....................................................................................... 208 ! Period Calendars ..................................................................................................................... 209 ! Month Dimensions ................................................................................................................ 209 ! Offset Calendars ................................................................................................................... 210 ! Year-to-Date Comparisons ...................................................................................................... 210 ! Fact-Specific Calendar Pattern ............................................................................................. 212 ! Using Fact State Information in Report Footers.................................................................... 213 ! Conformed Date Ranges ...................................................................................................... 214 ! C LOCK D IMENSIONS ......................................................................................................................... 214 ! Day Clock Pattern - Date and Time Relationships................................................................... 215 ! Time Keys ................................................................................................................................ 216 ! I NTERNATIONAL T IME ........................................................................................................................ 217 ! Multinational Calendar Pattern................................................................................................. 218 ! Date Version Keys ................................................................................................................... 220 ! I NTERNATIONAL T RAVEL .................................................................................................................... 221 ! Time Dimensions or Time Facts? ............................................................................................ 224 ! N ATIONAL L ANGUAGE D IMENSIONS .................................................................................................... 225 ! National Language Calendars.................................................................................................. 225 ! Swappable National Language Dimensions Pattern................................................................ 225 ! S UMMARY ........................................................................................................................................ 226 ! CHAPTER 8 HOW MANY: DESIGN PATTERNS FOR HIGH PERFORMANCE FACT TABLES AND FLEXIBLE MEASURES ......................................................................................................................................... 227 ! F ACT T ABLE T YPES .......................................................................................................................... 228 ! Transaction Fact Table ............................................................................................................ 228 !

My first Publication Agile-Data-Warehouse-Design-eBook | Page 13