The KPI is invalid due to invalid filter (season). Not able to delete the filter. What to do?

The KPI is invalid due to invalid filter (season). Not able to delete the filter. What to do?

The "Season" is initially created as a hierarchy in "Product" dimension and the same is added in the filter pane for the KPI. Later the 'Season' hierarchy is deleted and it is created as a separate Dimension in the data model. Now, when you try to delete the "Season" filter from this KPI, it will not get deleted from KPI because while deleting we are checking for that particular deleted hierarchy in the 'Product' dimension in data model and since the specific hierarchy is not present in the data model, it does not allow to delete the filter.

    • Related Articles

    • Why am I not able to find the saved filter?

      This is due to the saved filter Name Length is greater then the field length defined in the User related table in the Metadata( admin DB) Refer the table -ADMIN_USER_FILTERS on increasing the data type length we will be able to save filters

    • How to delete a 'Default Filter'?

      Perform the following steps to delete the filters from the 'Dimension Browser' under 'Defaults' tab in 'My Filter' section: a) Select 'My Defaults' located on the top of the Menu Bar. b) Select the required filter and click 'Delete Named Filter' ...

    • Getting Invalid KPI definition error while trying to access KPI.

      This issue can be due to large browser cache. Clear the browser cache and the issue should be fixed. If the problem persists, re-publish the KPI. If you require further help, please contact the support team.

    • 'Sales Discount' KPI shows an exception as, 'Invalid KPI'. Why?

      The KPI's definition must have got altered. There will be an issue with the metadata related to the KPI like Measures/Dimensions. You can alternatively check for the KPI validity from Administrator --> KPI Management and verify ...

    • I am not able to see the attributes within the filter hierarchy. why?

      This issue can occur if the attributes are not saved. After selecting a filter hierarchy, select the required levels/attributes of the selected hierarchy. Then click on 'Save' present at the bottom of the page. Now you can view the levels/attributes ...