SAP Knowledge Base Article - Public

2596418 - Calculated account does not aggregate in SAP Analytics Cloud (SAC)

Symptom

Create a calculated account cKPI based on the values of another account KPI.

Whenever there is an KPI value of larger than 0, the cKPI should be calculated as 1.

The formula works fine when drilling down on dimensions, but the system is not able to aggregate it.

It returns the error message: "System could not calculate a value for unknown reasons".

Environment

  • SAP Analytics Cloud 2018.1.9

Cause

This might be a limitation as per this help page:

https://help.sap.com/doc/00f68c2e08b941f081002fd3691d86a7/release/en-US/1090aeba778e4da190969c9aa0c49006.html

The formula applies only to the member level where you added the formula; it doesn't apply to parent members.

These features are not supported at this time:

>> Flat date hierarchies

 

Also, If you use the formula in a chart, the dimensions that you used in the formula must be added to the chart.

Resolution

In order to get data for account members with IF formulas that use dimensions, without including those dimensions in drill, it is necessary to define an exception aggregation on the account member using a superset of the dimensions used in the IF formulas.

See Also

Keywords

EPM, SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Hana Cloud for Planning, EPM-ODS, Cloud for Analytics, C4P, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, HCP, C4A, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJ, BOBJcloud, BOCloud., BICloud, BO Cloud, connecting, conecting, conectando, conexão, modelo, SBOC, SAC, SAP BusinessObjects Cloud, Business Objects, SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics , KBA , reporting of calculated account not poss , not possible , LOD-ANA , SAP Analytics Cloud , LOD-ANA-BI , SAP Analytics Cloud - Business Intelligence (BOC) , LOD-ANA-BR , SAP Analytics Cloud - Digital Boardroom , LOD-ANA-PL , SAP Analytics Cloud – Planning (BOC) , LOD-ANA-PR , SAP Analytics Cloud – Predictive (BOC) , Problem

Product

SAP Analytics Cloud 1.0