SAP Knowledge Base Article - Public

2954217 - Cannot delete a dimension with no fact data in SAP Analytics Cloud for Planning (SAC)

Symptom

You display this member in the story and confirm there is no data. However, you still cannot delate a dimension member. The following error is received:

  • messageId: "CAN_NOT_DELETE_USING_MEMBER"
    Member(s) <member id> cannot be deleted because there is transactional data in model(s) <model id> corresponding to the member(s)

Environment

  • SAP Analytics Cloud (Enterprise) 2020.8.22

Reproducing the Issue

[Enter your Reproducing the Issue here...]

Cause

The data exists for some private versions.

Resolution

There is a functionality in SAC which allows you to delete all private versions of all users.

Please follow the steps below as the model owner:

  1. Open the model and click on the "Model Preferences" button (wrench icon).
  2. Go to "Planning & Time Range"
  3. Click on the "Delete private versions" button. This should give you a confirmation dialog telling how many private versions there are.
  4. After confirming, try to delete the dimension member again.

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, delete facts , KBA , LOD-ANA-PL-PRO , Planning Process, Input Task , Problem

Product

SAP Analytics Cloud 1.0