SAP Knowledge Base Article - Public

2784901 - Unbooked cell with flat presentation: If a dimension that has hierarchies is shown in flat presentation, cell changes are allowed only for booked cells warning in SAP Analytics Cloud

Symptom

The following warning occurs when you try to enter data in an unbooked cell using a dimension with a hierarchy set with "Flat presentation" in SAP Analytics Cloud (SAC):

  • Unbooked cell with flat presentation:
    If a dimension that has hierarchies is shown in flat presentation, cell changes are allowed only for booked cells.

Environment

  • SAP Analytics Cloud 2019.7

Cause

Limitation.

Resolution

Starting with version 2019.07, data entry on unbooked cells in a flat presentation hierarchy is not supported.
Please choose a hierarchy and not flat presentation to enable data entry on unbooked cells.

Workaround:

  • As a fast way to mimic the flat presentation, create an additional hierarchy on the relevant dimension(s) where you do not specify any parent-child (PCH) relationships, and switch to that hierarchy in the table widgets of the story.

See Also

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

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 , 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