SAP Knowledge Base Article - Public

3102162 - Pasting Failed Due to a Technical Error in SAP Analytics Cloud for Planning (SAC)

Symptom

The following error message occurs in SAP Analytics Cloud for Planning (SAC) when you try to paste a value in a planning enabled cell of a planning story:

  • Pasting failed due to a technical error 

In F12 -> Console tab, the detailed error is as below:

  • Firefly returned with errors Caught exception : exception 42460: The hierarchy doesn't exist  : The hierarchy doesn't exist  : hierarchyName=xx, fieldName=<dimension name>, dimensions=[<dimension name>, <dimension name>.ID]  -  sap.fpa.ui.pa.utility.FireflyUtils

Environment

  • SAP Analytics Cloud (Enterprise)  2021.14.15

Reproducing the Issue

  1. Open a story.
  2. Paste a value to a cell.

Cause

The table in the story is saved with an (outdated?) hierarchy on one dimension. For example, the model was changed after the story had been created so there is a mismatch between the valid hierarchies and the currently set hierarchy which leads to this error.

Resolution

  1. Open the story to be repaired.
  2. Switch to edit mode.
  3. Select the table widget and click on "Designer"
  4. In the designer panel, add the problem dimension to the rows
  5. Edit the hierarchies for the problem dimension by clicking on the three dots
  6. Remove the problem dimension from the rows again
  7. Switch back to view mode
  8. Save the story (as a copy first to validate the solution)
  9. In the new story, verify that everything is working.

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-FLY , Firefly used for HANA , LOD-ANA-PL-DE , Data Entry and Mass Data Entry , Problem

Product

SAP Analytics Cloud 1.0