In SAP Analytics Cloud, dimensions are data objects that represent categorical data in a dataset; for example, Products or Sales.
The following types of dimension are available:
- The Dimension type is a generic, free-format dimension to which data
can be added or imported as required. This could be based, for example on
products, channels, or sales representatives.
Values related to dimension members appear in different columns.
A model may have any number of Dimensions.
Note that the Description and ID attributes of dimensions must be of data type Text.
- Measure is a dimension that represents transactional data (note that this data is not visible in Modeler).
- Date is a built-in dimension that defines the start and end date of
the model's timeline and the smallest time units that will be used in the
The date dimension specifies the overall timeframe for the model and also the granularity – the smallest time period down to which the data will be analyzed (yearly, quarterly, monthly, or daily values). There is no specific setting for weekly periods, but if the lowest granularity is set to day-level, then data output in Stories is automatically shown grouped in calendar weeks.
You can specify a default time hierarchy to display in stories, and optionally configure the date dimension to organize data by fiscal year instead of calendar year.
You can also have more than one date dimension in a model or story.
- The Organization dimension type is optional in a model but offers an
organizational analysis of the account data, based, for example, on operating
units, geographic entities, or cost centers. A Region column in a dataset often
maps to an Organization dimension.
A model can have only one organization dimension.
- The Account dimension is the main dimension of the model. Unlike
Dimensions, which have their values in different columns, an Account dimension
has all its values in one value column.
Example: you import some key-figure-based data into Modeler as measures. Each column that you mapped as a measure will appear as members in the Account dimension.
Models can have only one account dimension.NoteIn live data models, the Account dimension is named Measures.
- Version is a built-in dimension that defines the data versions
available in the data output: Actual, Budget, Planning, Forecast, Rolling
Versioning is a financial planning concept that represents a way of providing calculations such as actual vs. budget.
In a model that uses a currency conversion table with Rate Versions, you can use the Rate Version column for the Version dimension to set specific conversion rates for each version.
- The Timestamp dimension type is similar to the Date dimension type,
except that it includes hours, minutes, seconds, and milliseconds, and is not
The Timestamp dimension type is useful for data that is recorded very frequently; for example, sensor data.