Objective
After completing this lesson, you will be able to Explain the unique properties for dimension types.
Dimension properties have many uses in SAP Analytics Cloud. In stories, they can be used to sort and filter data or for currency translation calculations. They can also be displayed to provide additional information or clarity to the story.
The following example displays the Stores dimension with its properties.
Each dimension type has unique properties that are system-generated, and depending on the dimension type, you can easily add as many custom properties as you need.
The following properties are system-generated:
These properties are used for currency conversion, data access control, data locking ownership, and to hide unauthorized hierarchy nodes.
The following example displays properties for the Organizational dimension type.
The following example displays properties for the Account dimension type.
The following properties are system-generated:
These properties are used for currency conversion, data access control, data locking ownership, and to hide unauthorized hierarchy nodes.
Note
* There are many aggregation types available in SAP Analytics Cloud: average, last, first, rank, sum, etc. Aggregation behavior can be specified in account dimensions, calculated measures in stories, as well as a measure-based model.Note
Member ID, Description, and Hierarchy appear as a columns in the member sheet, but they are not properties.The Category property is system-generated.
This property is used for data access control and data locking ownership.
There are many system-generated properties related to time such as Day, Week, Month, Day Name, and more.
These properties are used for time hierarchies and data mapping.
There are no system-generated properties, but you can add any that you need, and they can be used for currency conversion, data access control, data locking ownership, and to hide unauthorized hierarchy nodes.
Log in to track your progress & complete quizzes