The following chapters describe how to calculate the number of optional filter combinations. The first chapter described the previous Single choice logic and the second described the Multiple Choice logic.

When this option is selected the result is being pre-generated for each single Filter selection and not for any combined filter selections. But like in the previous version (8.0) all combinations between a single filter selection and other optional items like Hierarchical Filter, Time interval, Time period and Moving average can be pre-generated.


Example: A report contains the following optional filter and other optional items:


  • Age group: No selection, 15-24, 25-34, 35-44, 45-55, 56-65 (5 options)
  • Gender: No selection, Male, Female (2 options)
  • Floating time period: Last 4 weeks, last 12 weeks (2 options)
  • Interval: Month, Full period (2 options)

Based on the optional filters above the number of combinations to be pre-generated is calculated as the following:


  • N of Gender combinations= 2 Genders X 2 Intervals X 2 Time periods = 8
  • N of Age group combinations = 5 Age groups X 2 Intervals X 2 Time periods = 20
  • Total Number of combinations: 20+8=28 combinations

As shown above no combined Filter combinations are being pre-generated, each Filter is only combined with the other optional items (Floating Time period and Interval).

The second option should be used for pre-generation combined filter selections.


Example: A report contains the following optional filter and other optional items:

  • Age group: No selection, 15-24, 25-34, 35-44, 45-55, 56-65 (6 options)
  • Gender: No selection, Male, Female (3 options)
  • Floating time period: Last 4 weeks, last 12 weeks (2 options)
  • Interval: Month, Full period (2 options)


Based on the optional filters above the number of combinations that needs to be pre-generated is calculated as the following:


  • N of combinations= 6 Age groups x 3 Genders X 2 Intervals X 2 Time periods = 72

As shown above combined Filter combinations are being pre-generated, each Filter is combined with the other Filters and other optional items (Floating Time period and Interval).