Cargando…
Expert Cube Development with SSAS Multidimensional Models : Expert Tips and Tricks for Designing Analysis Services Multidimensional Models /
"An easy-to-follow guide full of hands on examples of real-world Analysis Services cube development tasks. Each topic is explained and placed in context, and for the more inquisitive reader, there also more in-depth details of the concepts used. If you are an Analysis Services cube designer wis...
| Clasificación: | Libro Electrónico |
|---|---|
| Autores principales: | , , |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
Birmingham, UK :
Packt Pub.,
2014.
|
| Edición: | 2nd ed. |
| Colección: | Professional expertise distilled.
|
| Temas: | |
| Acceso en línea: | Texto completo (Requiere registro previo con correo institucional) |
Tabla de Contenidos:
- Cover; Copyright; Credits; About the Authors; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; Chapter 1: Designing the Data Warehouse for Analysis Services; The source database; The OLTP database; The data warehouse; The data mart; Data modeling for Analysis Services; Fact tables and dimension tables; Star schemas and snowflake schemas; Junk dimensions; Degenerate dimensions; Slowly Changing Dimensions; Bridge tables or factless fact tables; Snapshot and transaction fact tables; Updating fact and dimension tables; Natural and surrogate keys.
- Unknown Members, key errors, and NULLabilityPhysical database design for Analysis Services; Multiple data sources; Data types and Analysis Services; SQL queries generated during cube processing; Dimension processing; Dimensions with joined tables; Reference dimensions; Fact dimensions; Distinct Count measures; Indexes in the data mart; Usage of schemas; Naming conventions; Views versus the Data Source View; Summary; Chapter 2: Building Basic Dimensions and Cubes; Multidimensional and Tabular models; Choosing an edition of Analysis Services; Setting up a new Analysis Services project.
- Creating data sourcesCreating Data Source Views; Designing simple dimensions; Using the New Dimension wizard; Using the Dimension Editor; Adding new attributes; Configuring a Time dimension; Creating user hierarchies; Configuring attribute relationships; Building a simple cube; Using the New Cube wizard; Project deployment; Database processing; Summary; Chapter 3: Designing More Complex Dimensions; Grouping and banding; Grouping; Banding; Modeling Slowly Changing Dimensions; Type I SCDs; Type II SCDs; Modeling attribute relationships on a Type II SCD; Handling member status; Type III SCDs.
- Modeling junk dimensionsModeling ragged hierarchies; Modeling parent/child hierarchies; Ragged hierarchies with HideMemberIf; Summary; Chapter 4: Measures and Measure Groups; Measures and aggregation; Useful properties of measures; FormatString; DisplayFolders; Built-in measure aggregation types; Basic aggregation types; DistinctCount; None; Semi-additive aggregation types; ByAccount; Dimension calculations; Unary operators and weights; Custom Member Formulas; Non-aggregatable values; Measure groups; Creating multiple measure groups; Creating measure groups from dimension tables.
- MDX formulas versus pre-calculating valuesHandling different dimensionality; Handling different granularities; Non-aggregatable measures
- a different approach; Using linked dimensions and measure groups; Role-playing dimensions; Dimension/measure group relationships; Fact relationships; Referenced relationships; Data mining relationships; Summary; Chapter 5: Handling Transactional-level Data; Details about transactional data; Drillthrough; Actions; Drillthrough actions; Drillthrough columns order; Drillthrough and calculated members; Drillthrough modeling.