Hello,
When using a dimension as a page filter, the filter’s values are made up of actual occurrences in given dimension. Now and then it happens that an occurences disappears or changes in real data with the filter still holding old values. Is there a way to refresh filters and their entries?
Hi @Maiko
Thanks for posting your question!
When eazyBI imports data, new dimension members are added automatically, but old or renamed members are not automatically removed - they remain in the dimension even after the underlying data has changed. That is why you may see “old” values in page filter drop-downs.
There are a couple of ways to address this:
1. Delete members without data
For supported dimensions, you can manually remove members that no longer have any associated data. This option is available under the Analyze tab -open the cube, find the dimension, and use the Delete members without data action. This is available for a specific set of dimensions (e.g., Assignee, Status, Priority, Sprint, Label, and single-choice custom fields imported with separate_table settings). It requires a data admin role or higher. See an example here on how to do that - Data from Jira
2. Empty the cube and re-import all data
If the above option does not cover your dimension or does not fully resolve the issue, you can do a full reset:
More information on emptying the cube can be found here - Data from Jira
This will rebuild all dimension members from scratch, removing any stale entries.
Please note that during the full re-import, reports may appear temporarily empty until the import completes, so it is best to do this during off-peak hours.
Let me know if you have any further questions!
Elita from support@eazybi.com
Thanks, have a good weekend.