SAP Knowledge Base Article - Public

2901324 - Formula based on dimension property calculated in model doesn't work when showing the dimension as hierarchy in story in SAP Analytics Cloud (SAC)

Symptom

  • Formula based on dimension property calculated in model doesn't work when showing the dimension as hierarchy in story in SAP Analytics Cloud (SAC)

Environment

  • SAP Analytics Cloud (Enterprise) 2020.5.2

Reproducing the Issue

  1. Log on to SAC tenant.
  2. Open sample model [BestRunJuice_SampleModel].
  3. Open dimension [Sales Manager] and then add one Custom Property: P1.
  4. Put P1=10000000 for all members of this dimension.
  5. Save the model.
  6. Go to Account and then add the following calculation:
    T1= FLOAT(TONUMBER([d/Sales_Manager__5w3m5d06b5].[p/P1]))
    D1= [Gross_Margin]-[T1].
  7. Save the change and then exist the model.
  8. Create a story with Table on the model to show [Sales Manager] & [Gross_Margin] & [T1] & [D1].
    => [T1] appears as 10 and [D1] appears according to the formula for all members of [Sales Manager] correctly.
  9. Save the story and then go to the model again.
  10. Add a Parent-Child Hierarchy [SalesHier] in dimension [Sales Manager].
  11. Open the story created on step 8 and then select hierarchy [SalesHier] for dimension [Sales Manager].
    => [T1] still appears as 10 correctly, but [D1] will show same value as [Gross_Margin], which means that [T1] works as zero in the formula of [D1].

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 , KBA , LOD-ANA-DES , Model, Story Design & Visualizations , Problem

Product

SAP Analytics Cloud 1.0