SAP Knowledge Base Article - Public

3754465 - unable to use text attribute from a dimension in a calculated dimension with live datasphere analytic model - SAP analytics cloud

Symptom

  • Unable to use a text attribute from a dimension coming from a live Datasphere analytic model in a calculated dimension.
  • In the calculation editor, the expected text attribute appears in the dimension’s Properties panel but does not appear in the attribute suggestion list after typing .[ in the formula.

Environment

  • SAP Analytics Cloud
  • SAP Datasphere

Reproducing the Issue

  1. In a story (edit mode), add a table based on a live Datasphere analytic model.
  2. Add a dimension that has multiple attributes, including a text attribute (visible in the dimension Properties panel).
  3. Create a Calculated Dimension.
  4. In the calculation editor, start the formula with the dimension reference, for example: [d/"ModelName":DimensionID].
  5. Type .[ to list available attributes; observe that the expected text attribute is not listed, while others may be listed.

Cause

This text attribute is not directly defined under the dimension in Datasphere view. Instead, the dimension was mapped to another object which the text attribute is associated with.

Resolution

  • The above scenario is not supported in SAP Analytics Cloud when creating the calculated dimension.
  • Some possible workaround can be:
    • Consider to directly associate the text values to be the properties of the dimension in Datasphere views. Therefore this property should be directly used in SAP Analytics Cloud as well.
    • In Datasphere, create other calculated dimension to directly to read the text values. Then this calculated dimension will become as the dimension in SAP Analytics Cloud, which can be used in the Calculation Dimension formula.

Keywords

calculated dimension, text attribute, description property, p/Description, invalid dimension property, formula could not be computed, live datasphere, analytic model, attribute not listed, dimension properties, calculation editor, story, sac, attribute suggestion list, dimension text , KBA , LOD-ANA-DES , Story Design & Visualizations , Problem

Product

SAP Analytics Cloud 1.0