Describing Properties

Objectives
After completing this lesson, you will be able to:

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 examples displays 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.

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.

Scenario: Dimension Types and Properties

Log in to track your progress & complete quizzes