Business Currency Supports multi-currency conversion using Implement using DAX expressions. / conversion the Business Intelligence Wizard. Data Scale Extremely large scale (multi-terabyte) Large Scale (Billions of records) access / and storage Data Performance Indexes and preaggregated measure In memory column-based data storage. access values stored on disk. Dimension data Approximately 10x data compression. / and and query results cached in memory. storage Approximately 3x data compression. Data Data sources Relational databases. Relational databases, Excel, Text, OData feeds, access Azure Data Market, Analysis Services. / and storage Data language MDX DAX access MDX (In-Memory mode only) / and storage Data Data storage MOLAP - Dimension, fact, and In-Memory - All data cached in memory utilizing access aggregated data stored on disk. column-oriented xVelocity analytics engine and Dimension data and query results cached / storage in memory. DirectQuery – Data stored in SQL Server 2012. – ROLAP Dimension, fact, and aggregated data stored in a relational database. Data Data Typically 3x. Typically 10x. access compression / and storage
Business Currency conversion / Supports multi-currency conversion using the Business Intelligence Wizard. Implement using DAX expressions. Data access and storage Scale / Extremely large scale (multi-terabyte) Large Scale (Billions of records) Data access and storage Performance / Indexes and preaggregated measure values stored on disk. Dimension data and query results cached in memory. Approximately 3x data compression. In memory column-based data storage. Approximately 10x data compression. Data access and storage Data sources / Relational databases. Relational databases, Excel, Text, OData feeds, Azure Data Market, Analysis Services. Data access and storage language / MDX DAX MDX (In-Memory mode only) Data access and storage Data storage / MOLAP - Dimension, fact, and aggregated data stored on disk. Dimension data and query results cached in memory. ROLAP – Dimension, fact, and aggregated data stored in a relational database. In-Memory - All data cached in memory utilizing column-oriented xVelocity analytics engine DirectQuery – Data stored in SQL Server 2012. Data access and storage Data compression / Typically 3x. Typically 10x.
SQL2012AS%20Multidimensional%20Modeling.docx