Advanced OLAP Modeling with SSAS
Using multiple fact tables in a single cube
Modeling nonstar dimension types, including many-to-many (using intermediate fact tables), fact (degenerate), role-playing, and writeback performing advanced dimension modeling, including modeling for either slowly or rapidly changing dimensions and adding custom error handling
Using the Business Intelligence Wizard for cubes and dimensions to easily enable writeback, semiadditive measures, account/time/dimension intelligence, unary operators, custom member formulas, and attribute ordering.
KeywordsDimension Table Measure Group Fact Table Dimension Attribute Business Requirement
Unable to display preview. Download preview PDF.