Multidimensional Database
Abstract
A key component of Microsoft SQL Server is the analytical database engine. The authors show how to build an OLAP cube to support multidimensional analysis based on the information mart, including the definition of measures and dimensions. They cover basic MDX and DAX querying on these cubes. The chapter demonstrates how to use Microsoft Excel to access the OLAP cube and perform simple calculations and adding charts to the cube. By doing so, they meet the goals of the book, to provide a complete end-to-end demonstration of building a scalable data warehouse using Data Vault 2.0.
Keywords
Get Building a Scalable Data Warehouse with Data Vault 2.0 now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
