Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest Fabric, Power BI, and SQL learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todayDimensions - Storage
Applies to: 
SQL Server Analysis Services 
Azure Analysis Services
Fabric/Power BI Premium
Dimensions in Microsoft SQL Server SQL Server Analysis Services support two storage modes:
Relational OLAP (ROLAP)
Multidimensional OLAP (MOLAP)
The storage mode determines the location and form of a dimension's data. MOLAP is the default storage mode for dimensions. Related topics:Partition Storage Modes and Processing
Data for a dimension that uses MOLAP is stored in a multidimensional structure in the instance of SQL Server Analysis Services. This multidimensional structure is created and populated when the dimension is processed. MOLAP dimensions provide better query performance than ROLAP dimensions.
Data for a dimension that uses ROLAP is actually stored in the tables used to define the dimension. The ROLAP storage mode can be used to support large dimensions without duplicating large amounts of data, but at the expense of query performance. Because the dimension relies directly on the tables in the data source view used to define the dimension, the ROLAP storage mode also supports real-time OLAP.
Important
If a dimension uses the ROLAP storage mode and the dimension is included in a cube that uses MOLAP storage, any schema changes to its source table must be followed by immediate processing of the cube. Failure to do this may result in inconsistent results when querying the cube. Related topic:Automate Analysis Services Administrative Tasks with SSIS.
Additional resources
Training
Module
Design scalable semantic models - Training
Good modeling practices lead to scalable semantic models that simplify analysis and reporting of large, complex data, enhancing Power BI reports for an optimal user experience.
Certification
Microsoft Certified: Power BI Data Analyst Associate - Certifications
Demonstrate methods and best practices that align with business and technical requirements for modeling, visualizing, and analyzing data with Microsoft Power BI.