Feature Overview
In the recent SAC QRC3 update, tables were updated to support advanced filters with Unbooked Mode. Advanced filtering allows users to filter multiple dimensions by defining a set of logical conditions. Users can enable or disable these filters in view mode.
Fig 1 – Unbooked Mode can be enabled at the bottom of the Advanced filtering dialogue box in the Settings area
Unbooked Mode refers to the handling of unbooked data. Unbooked data includes cells or members that do not have any associated member values. In Unbooked Mode, all unbooked data is included in calculations/visualizations. Previously, Unbooked Mode would cause tables to display all possible members, even without data, which often caused the table to become cluttered.
The QRC3 update allows for the use of advanced filters for tables and charts in combination with the Unbooked Mode on the filtered dimension. This update will keep the asymmetric view in the table when advanced filtering and Unbooked Mode are used.
