Why Store Data in a Cube?
: Why Store Data in a Cube? 3 Analysis services, like the SQL Server relational database, is a platform for storing data. But unlike the relational database, it does not store data in tables–it is stored in other types of structures comprising a cube. Why store data in cubes instead of tables? There are a number of reasons: better query performance fast, optimized aggregations calculations more efficient storage of data through its simplified read-oriented design richer calculation possibilities, supporting stored measures, calculated measures, and key performance indicators (KPI) an easier to understand data model for the end user. OLAP data is engineered to provide dimensional data views, hierarchical browsing, attribute-based breakouts and filtering. And OLAP data does not require or even use table joins! Creating an Analysis Services (OLAP) Database : Creating an Analysis Services (OLAP) Database Dimensions and their associated elements Hierarchies Attributes Measures and their ass
