Introduction With every new release of SQL Server, partitioning has reached new heights of improvement. For example, though we could create partitioned views for better manageability and scalability s ...
Part III: Using MDX to Analyze Data In This Part CHAPTER 10 MDX Concepts CHAPTER 11 Advanced MDX CHAPTER 12 Cube-Based MDX Calculations CHAPTER 13 Dimension-Based MDX Calculations CHAPTER 14 Extending ...
Chapter 9. Multidimensional Models and Business Intelligence Development Studio In This Chapter Creating a Data SourceDesigning a Data Source ViewDesigning a DimensionDesigning a CubeConfiguring and D ...
Chapter 8. Advanced Modeling In This Chapter Parent-Child RelationshipsAttribute DiscretizationIndirect DimensionsMeasure ExpressionsLinked Measure Groups In the previous chapters, we covered basic a ...
Chapter 7. Measures and Multidimensional Analysis In This Chapter Measures in a Multidimensional CubeMeasure GroupsMeasure Group Dimensions Measures are the values that you are going to analyze; they ...
Chapter 6. Cubes and Multidimensional Analysis In This Chapter Cube DimensionsThe Dimension CubePerspectives The main object you use in multidimensional analysis is the cube. As opposed to the geomet ...
Chapter 5. Dimensions in the Conceptual Model In This Chapter Dimension AttributesDimension HierarchiesAttribute Hierarchies You define multidimensional space by specifying a set of dimensions. There ...
Part II: Creating Multidimensional Models In This Part CHAPTER 4 Conceptual Data Model CHAPTER 5 Dimensions in the Conceptual Model CHAPTER 6 Cubes and Multidimensional Analysis CHAPTER 7 Measures and ...
Chapter 3. Client/Server Architecture and Multidimensional Databases: An Overview In This Chapter Two-Tier ArchitectureOne-Tier ArchitectureThree-Tier ArchitectureFour-Tier ArchitectureDistributed Sys ...
Chapter 2. Multidimensional Space In This Chapter Describing Multidimensional SpaceDimension AttributesCellsMeasuresAggregation FunctionsSubcubes Working with relational databases, we’re used to a t ...
Part I: Introduction to Analysis ServicesIn This Part CHAPTER 1 Introduction to OLAP and Its Role in Business Intelligence CHAPTER 2 Multidimensional Data Model CHAPTER 3 Client/Server Architecture an ...
Introduction Analysis Services began as the project of a small Israeli firm named Panorama, which had responded to a request from a British publishing company to develop an application that would anal ...
