SAP Knowledge Base Article - Public

3378080 - Cannot delete filter of dimension which has been deleted in the model in SAP Analytics Cloud (SAC) Story

Symptom

  • Cannot remove filter of a dimension in story, there is no response and the filter is still there after clicking x button to delete it
  • "Filter unavailable. This filter is no longer usable because the data source. dimension or selected hierarchy no longer exists, the dimension has a missing required hierarchy, or the dimension type has changed." error shows for the filter
  • Check the model, could see that the dimension filtered has been deleted in the model

Environment

  • SAP Analytics Cloud 2023.8.8

Reproducing the Issue

  1. Open the story
  2. Go to edit mode
  3. Select the table, go to Builder panel, check there is a filter shows error "Filter unavailable. This filter is no longer usable because the data source. dimension or selected hierarchy no longer exists, the dimension has a missing required hierarchy, or the dimension type has changed."
  4. Try to delete it, nothing occurs after clicking delete button.

Cause

The issue is a product defect.

Resolution

The issue has been fixed in 2023.16.

Keywords

Your feedback is important to help us improve our knowledge base. , KBA , LOD-ANA-TAB , Table , Problem

Product

SAP Analytics Cloud 1.0