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
- Open a story.
- 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
- Open the story to be repaired.
- Switch to edit mode.
- Select the table widget and click on "Designer"
- In the designer panel, add the problem dimension to the rows
- Edit the hierarchies for the problem dimension by clicking on the three dots
- Remove the problem dimension from the rows again
- Switch back to view mode
- Save the story (as a copy first to validate the solution)
- In the new story, verify that everything is working.
See Also
- 2569847 - Where can you find SAC user assistance (help) to use, configure, and operate it more effectively?
- 2851317 - Where can I find more information on SAP Analytics Cloud (SAC) for Planning features and documentation?
- Have a question? Ask it here and let our amazing SAP community help! Or reply and share your knowledge!
- 2487011 - What information do I need to provide when opening an case for SAP Analytics Cloud?
- SAP Analytics Cloud > Learning > Guided Playlists
- SAP Analytics Cloud > Learning > Guided Playlists > Getting Support
- Need More Help? Contact Support or visit the solution finder today!
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