SAP Knowledge Base Article - Public

2814315 - Cannot enter data when using INVERSEIF function in SAP Analytics Cloud (SAC) & SAP Digital Boardroom -

Symptom

The following behavior occurs in SAP Analytics Cloud (SAC):

  • Data entry is not possible with INVERSEIF function.

Environment

  • SAP Analytics Cloud 

Reproducing the Issue

  1. Open story where you have accounts with InverseIF function
  2. Try to input any values 
  3. Make sure you can't input anything.

Cause

This is the behavior by design: SAC only allows data entries on formulas with inverse formulas if all operands of the formula are booked.

Resolution

  • You can check the reasons why a specific cell is not input-enabled. To do so, press the three dots on the bar right to the table, press Show/hide and check 'Reason for unplannable data'.
  • If this feature is turned on, clicking on a cell for formula X and version Y reveals the reason why it is not input-enabled: Currently, SAC only allows data entries on formulas with inverse formulas if all operands of the formula are booked.

See Also

Keywords

SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, EPM-ODS, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics , KBA , LOD-ANA , SAP Analytics Cloud (SAC) , LOD-ANA-BI , Business Intelligence Functionality, Analytic Models , LOD-ANA-BR , SAC Boardroom , LOD-ANA-PL , Planning , LOD-ANA-PR , SAC Predicitive , Problem

Product

SAP Analytics Cloud 1.0