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

Store dimension members with property values
Note

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

Dimension properties have many uses in SAP Analytics Cloud.

Here are a few examples:

  • Sort and filter: in a story, filter companies based on their currency property
  • Reporting: display the material type property for materials in a story
  • Currency translation: translate average vs. end-of-month rates via the account dimension rate type property

The Account dimension type includes several unique properties:

Note
There are many aggregation types available in SAP Analytics Cloud: average, last, first, rank, sum. Aggregation behavior can be specified in account dimensions, calculated measures in stories as well as the New Model.

Unique properties for dimension types

Unique properties by dimension type

Many properties are provided, and you can easily add as many custom properties as you need.

Member IDs for an organization and account dimension

The provided properties are unique for each dimension type:

  • Organization dimension type:
    • On by default: currency and person responsible
    • Available: data access control, data locking ownership, hide unauthorized hierarchy nodes
  • Account dimension type:
    • On by default: account type, formula, currency related, aggregation related
    • Available: data access control, data locking ownership, hide unauthorized hierarchy node
  • Date dimension type:
    • On by default: many date related such as day and week
  • Version dimension type:
    • On by default: category
    • Available: data access control, data locking ownership
  • Generic dimension type:
    • On by default: none
    • Available: currency, person responsible, data access control, data locking ownership, hide unauthorized hierarchy nodes

Reporting

Reporting with dimension properties

How can dimension properties be used in reporting?

  • You can use dimension properties to display properties in tables to supplement the dimension member, for example, display currency for each store.
  • You can use dimension properties to navigate on properties, for example, using the currency property of the entity in the row axis of a report.

You can add a dimension property into a table for display purposes using the following steps:

  • Hover on entity in the row axis
  • Go to ...More → Properties → Select Currency
Dimension properties can be displayed in data tables in a stories and you can also navigate on a property by placing it in the row axis of a table.

Sort and filter

Filter with dimension properties

In order to filter on a dimension property in a story, add an input control. In the input control, select the dimension that you want to filter and then select the property you want to filter on.

Use an input control to filter on a dimension property in a story

Sort on dimension properties

Using the example below, you can sort on a dimension property using the following steps:

  • Add the property to the row axis (Choose +Add Dimension → Expand the stores dimension → Select the person responsible property)
  • Right click on person responsible to sort it ascending or descending
Sorting with dimension properties in a story

Save progress to your learning plan by logging in or creating an account

Login or Register