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 (Analysis Services - Multidimensional Data)
Applies to: 
SQL Server Analysis Services 
Azure Analysis Services
Fabric/Power BI Premium
In Microsoft SQL Server SQL Server Analysis Services, dimensions are a fundamental component of cubes. Dimensions organize data with relation to an area of interest, such as customers, stores, or employees, to users. Dimensions in SQL Server Analysis Services contain attributes that correspond to columns in dimension tables. These attributes appear as attribute hierarchies and can be organized into user-defined hierarchies, or can be defined as parent-child hierarchies based on columns in the underlying dimension table. Hierarchies are used to organize measures that are contained in a cube. The following topics provide an overview of dimensions, attributes, and hierarchies.
| Topic | Description |
|---|---|
| Introduction to Dimensions (Analysis Services - Multidimensional Data) | Provides an overview of dimension concepts. |
| Attributes and Attribute Hierarchies | Describes attributes and attribute hierarchies. |
| User Hierarchies | Describes user-defined hierarchies of attributes. |
| Write-Enabled Dimensions | Describes write-enabled dimensions. |
| Dimension Translations | Describes translations of dimension meta data. |
Dimensions in Multidimensional Models
Cube Objects (Analysis Services - Multidimensional Data)
Additional resources
Training
Module
Set up dimensions in Dynamics 365 Business Central - Training
If you are responsible for financial reporting, then follow along with this module to learn how to set up dimensions. Dimensions are used to group posted entries for reporting purposes. Dimensions can be used throughout Business Central on entries in journals, documents, and budgets. Additionally, dimensions offer more extensive analysis and reporting functionalities.
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.