Describing Properties

Objectives

After completing this lesson, you will be able to:

  • Explain the unique properties for dimension types

Dimension Properties

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.

Screen shot of the Stores dimension with its properties

Unique Properties for Dimension Types

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.

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.

The following example displays properties for the Organizational dimension type.

SAP Analytics Cloud dimension table for Cost_Center as an example of an organizational dimension type.

Account Dimension Type

The following example displays properties for the Account dimension type.

SAP Analytics Cloud dimension table for SAP_FI_S4HC_GLACCOUNT as an example of an 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 a measure-based model.
Note
Member ID, Description, and Hierarchy appear as a columns in the member sheet, but they are not 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.

Log in to track your progress & complete quizzes