SAP Knowledge Base Article - Public

3004687 - Message "a value is only shown if all child nodes have the same unit or currency" displays in table if a constant is used in an account formula in SAP Analytics Cloud for Planning (SAC)

Symptom

  • Dimensional logic Account formulas do not calculate directly inputted numbers/plain numbers such as "+1" etc. unless account type equals NFIN
  • The formulas were working perfectly fine before QRC 4.2020 Update
  • Table shows message "a value is only shown if all child nodes have the same unit or currency"

Environment

  • SAP Analytics Cloud (Enterprise) 2020.21

Reproducing the Issue

Create an account formula that contains a constant value as part of the formula

Display the account member in a table.

Values may display as expected for Year or Quarter date values but will show as empty for month level granularity

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, Sac, Acquisition, Model, Connect, Story, Tenant, Import, Failed, Using, Working , KBA , LOD-ANA-PL , Planning , Problem

Product

SAP Analytics Cloud 1.0