Overview
When filtering a White Cup BI report, some records may remain visible even though you expected them to be excluded. This can happen when the filter is applied at a different level of the report hierarchy than intended. This guide explains how report levels, filtering, and breadcrumbs work together and how to troubleshoot unexpected results.
In this article:
- Understanding Report Levels
- Common Filtering Scenarios
- Applying Filters at the Correct Level
- Understanding Filters Versus Breadcrumbs
- Troubleshooting Unexpected Results
- Filtering and Aggregated Results
- Additional Information
Understanding Report Levels
White Cup BI reports can contain multiple levels of detail. For example:
Sales → Bill-To Customer → Sales Rep
The filter dialog applies conditions to the last level of the current report hierarchy. A filter applied at the Sales Rep level may exclude Sales Rep rows without removing their associated Bill-To Customer records.
Key takeaway: Apply filtering conditions at the level containing the records you want to include or exclude.
Common Filtering Scenarios
Customers remain visible after filtering
Possible cause: The report is drilled down to Sales Rep, so the filter affects Sales Rep rows rather than Bill-To Customer records.
Resolution: Return to Bill-To Customer, apply the filter, then drill back into Sales Rep if needed.
Remove All Filters does not restore all records
Possible cause: A specific Sales Rep was selected in the breadcrumb, not through the filter dialog.
Resolution: Remove that Sales Rep selection from the breadcrumb.
Multiple conditions produce unexpected results
Possible cause: AND/OR filter groups do not match the intended criteria.
Resolution: Review the conditions and their grouping before applying the filters again.
Applying Filters at the Correct Level
Note: To filter Bill-To Customer records, remove the Sales Rep drilldown before applying the filter. You can return to Sales Rep afterward.
- Open the report you want to filter.
- Review the breadcrumb to identify the current report hierarchy.
- Identify the level containing the records you want to include or exclude.
- Remove lower-level drilldowns from the breadcrumb until the intended level is last.
- Open the filter dialog.
- Add or modify the filtering conditions.
- Click Apply to apply the filters.
- Review the results.
- Drill back into lower levels if additional detail is needed.
Example: To exclude customers created before a particular date, apply a condition to the Date Created field while the report is at the Bill-To Customer level.
Understanding Filters Versus Breadcrumbs
Filters
Filters define conditions that determine which records are included or excluded at the applicable report level.
Breadcrumbs
Breadcrumbs represent the report drilldown path and selected dimension values. Selecting Sales Rep 9548 through the breadcrumb restricts the report to that representative. Choosing Remove All Filters does not necessarily remove this selection because it belongs to the breadcrumb. Remove the Sales Rep selection from the breadcrumb to display all representatives again.
Troubleshooting Unexpected Results
- Check the report level. Confirm the filter was applied at the level containing the records you want to exclude.
- Review breadcrumb selections. Check whether a customer, Sales Rep, or another dimension remains selected.
- Review filter groups. Confirm AND/OR conditions are grouped correctly.
- Verify filter criteria. Check the field, operator, and value.
- Reapply the filters. Apply conditions at the intended level and verify the results.
Filtering and Aggregated Results
A Bill-To Customer may remain visible even when filtering excludes Sales Rep rows beneath that customer. This does not necessarily mean filtering failed: the condition may have been applied at a lower hierarchy level. When reviewing aggregated values, consider the displayed report level and the level where the filter was applied.
Additional Information
For a more detailed explanation, see Understanding Filters and Breadcrumbs in White Cup BI.
If results remain unexpected, contact White Cup Support with the report name, filtering conditions, and examples of records that do not display as expected.
Comments
0 comments
Please sign in to leave a comment.