LEADER 05422nam 2200685 450 001 9910787883503321 005 20200520144314.0 010 $a1-84968-991-1 035 $a(CKB)2670000000530574 035 $a(EBL)1572948 035 $a(SSID)ssj0001158020 035 $a(PQKBManifestationID)11649186 035 $a(PQKBTitleCode)TC0001158020 035 $a(PQKBWorkID)11212281 035 $a(PQKB)10971171 035 $a(Au-PeEL)EBL1572948 035 $a(CaPaEBR)ebr10842718 035 $a(CaONFJC)MIL577615 035 $a(OCoLC)871223823 035 $a(CaSebORM)9781849689908 035 $a(MiAaPQ)EBC1572948 035 $a(PPN)228020247 035 $a(EXLCZ)992670000000530574 100 $a20140312h20142014 uy 0 101 0 $aeng 135 $aur|n|---||||| 181 $ctxt 182 $cc 183 $acr 200 10$aExpert cube development with SSAS multidimensional models $eexpert tips and tricks for designing analysis services multidimensional models /$fChris Webb, Alberto Ferrari, Marco Russo ; cover image by Faiz Fattohi 205 $a1st edition 210 1$aBirmingham, [England] :$cPackt Publishing,$d2014. 210 4$dİ2014 215 $a1 online resource (402 p.) 225 1 $aProfessional expertise distilled 300 $aIncludes index. 311 $a1-84968-990-3 327 $aCover; 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 327 $aUnknown 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 327 $aCreating 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 327 $aModeling 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 327 $aMDX 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 327 $aDrillthrough using a transaction detail dimension 330 $aAn 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 wishing to learn more advanced topic and best practices for cube design, this book is for you.You are expected to have some prior experience with Analysis Services cube development. 606 $aClient/server computing 606 $aRelational databases 615 0$aClient/server computing. 615 0$aRelational databases. 676 $a004.36 700 $aWebb$b Chris$0899754 701 $aFerrari$b Alberto$036508 701 $aRusso$b Marco$0282838 701 $aFattohi$b Faiz$01573308 801 0$bMiAaPQ 801 1$bMiAaPQ 801 2$bMiAaPQ 906 $aBOOK 912 $a9910787883503321 996 $aExpert cube development with SSAS multidimensional models$93848991 997 $aUNINA