SAP Knowledge Base Article - Public

3061215 - Thresholds filtered by hierarchy attributes does not work in SAP Analytics Cloud (SAC)

Symptom

  • Thresholds filtered by hierarchy attributes does not work in SAP Analytics Cloud (SAC).
  • Trying to define a threshold on a single measure, where the threshold should show different color coding based on the Hierarchy property value.
  • Error in browser console log: [Application Error]:Cannot read property 'getX' of null - TypeError: Cannot read property 'getX' of null

Environment

  • SAP Analytics Cloud (Enterprise) 2021.07.07
  • SAP Data Warehouse Cloud Live Connections

Reproducing the Issue

  1. Create SAC story.
  2. Insert a table and define Rows: [Dimension name], Columns: [Measure name]
  3. Define story thresholds: Using Thresholds in Tables
    • Model: "Model name"
    • Measure: [Measure name]
    • Compare to: Number Range
    • Ranges: OK -> Min=0, Warning -> Max=0
    • Add filter: [Hierarchy attribute] filtered on the value "value name".
  4. Apply.
  5. Note:
    • In the table right click the measure [Measure name] - Thresholds - Story Defined row will be greyed out, not able to select the created story thresholds.
    • Also thresholds are not visible in the table.
    • However, if you check the defined thresholds for your measure, the defined story threshold will be listed as existing: Edit - Designer - Builder - Columns -  [Measure name] - Thresholds - View All Thresholds.

Cause

This issue is currently under investigation by development.

Resolution

This issue is currently under investigation by development.

See Also

Your feedback is important to help us improve our knowledge base.

Keywords

SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics,Error, Issue, System, Data, User, Unable, Access, Connection, Sac, Connector, Live, Acquisition, Up, Set, setup, Model, BW, Connect, Story, Tenant, Import, Failed, Using, Working, SAML, SSO, sapanalyticscloud, sap analytical cloud, sap analytical cloud, SAC, sap analyst cloud, connected, failure, stopped
, KBA , LOD-ANA-DES-COR , SAC Core story functionality - widgets, geo, design, etc , Problem

Product

SAP Analytics Cloud 1.0