Applies to:
SQL Server Analysis Services
Azure Analysis Services
Fabric/Power BI Premium
The Type property setting provides information about the contents of a dimension to server and client applications. In some cases, the Type setting only provides guidance for client applications and is optional. In other cases, such as Accounts or Time dimensions, the Type property settings for the dimension and its attributes determine specific server-based behaviors and may be required to implement certain behaviors in the cube. For example, the Type property of a dimension can be set to Accounts to indicate to client applications that the standard dimension contains account attributes. For more information about time, account, and currency dimensions, see Create a Date type Dimension, Create a Finance Account of parent-child type Dimension, and Create a Currency type Dimension.
The default setting for the dimension type is Regular, which makes no assumptions about the contents of the dimension. This is the default setting for all dimensions when you initially define a dimension unless you specify Time when defining the dimension using the Dimension Wizard. You should also leave Regular as the dimension type if the Dimension Wizard does not list an appropriate type for Dimension type.
Available Dimension Types
The following table describes the dimension types available in Microsoft SQL Server SQL Server Analysis Services.
Dimension type
Description
Regular
A dimension whose type has not been set to a special dimension type.
Time
A dimension whose attributes represent time periods, such as years, semesters, quarters, months, and days.
Organization
A dimension whose attributes represent organizational information, such as employees or subsidiaries.
Geography
A dimension whose attributes represent geographic information, such as cities or postal codes.
BillOfMaterials
A dimension whose attributes represent inventory or manufacturing information, such as parts lists for products.
Accounts
A dimension whose attributes represent a chart of accounts for financial reporting purposes.
Customers
A dimension whose attributes represent customer or contact information.
Products
A dimension whose attributes represent product information.
Scenario
A dimension whose attributes represent planning or strategic analysis information.
Quantitative
A dimension whose attributes represent quantitative information.
Utility
A dimension whose attributes represent miscellaneous information.
Currency
This type of dimension contains currency data and metadata.
Rates
A dimension whose attributes represent currency rate information.
Channel
A dimension whose attributes represent channel information.
Promotion
A dimension whose attributes represent marketing promotion information.
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.
Demonstrate methods and best practices that align with business and technical requirements for modeling, visualizing, and analyzing data with Microsoft Power BI.
SQL Server Analysis Services 
Azure Analysis Services