Describing 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 example displays properties for the Organization and Account dimension types.

Note

Member ID, Description, and Hierarchy appear as a columns in the member sheet, but they are not properties.

Organization Dimension Type

The following properties are system-generated:

Currency
Person Responsible

These properties are used for currency conversion, data access control, data locking ownership, and to hide unauthorized hierarchy nodes.

Account Dimension Type

The following properties are system-generated:

Formula - used to calculate values such as Gross Margin %
Account Type - used to allow sign reversal from positive to negative
Calculated On
Aggregation Type*
Exception Aggregation*
Scale
Decimal Places
Units and Currencies
Hide

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 the new model.

Explore the Account Dimension Properties

Version Dimension Type

The Category property is system-generated.

This property is used for data access control and data locking ownership.

Date Dimension Type

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.

Generic Dimension Type

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.