Dimensions in the Analytic Model
Dimensions contain attributes that can be used to analyze and categorize measures defined in other entities.
-
Geography - Region, Country, State, City
-
Product - Range, Category, Product
-
Customer
-
Organization - Company, Department, Organization Unit
-
Time - Year, Quarter, Month, Day
The source of your analytic model can contain associations to dimensions, texts, and hierarchies. Dimensions contain attributes that can be used to analyze and categorize measures defined in other entities. In the analytic model, attributes are used as dimensions.
When you create your analytic model you can take over the associated dimensions from the source. Thus, you can easily build a multidimensional model in a star schema with the fact source in the center and the dimensions as direct associations.
-
Associations to dimensions (associations to a table or a view with semantic usage Dimension)
-
Associations to a text table (associations to a table or a view with semantic usage Text). They are automatically used by the analytic model if a dimension has a text association.
-
Association from a dimension to a hierarchy table. They are automatically used by the analytic model if a dimension has a hierarchy association.
You can also add dimensions of dimensions.
The graphic shows the star schema of the analytic model: the fact source is in the center and the dimensions are surrounding it. The dimension Product ID also has a dimension: Product Category.

