Page criteria in Reports

From TARGIT 2021 Summer

Page Criteria means that you can apply criteria to a certain page in a report.

Open a report and right click a certain page in the panel on the right hand side (make sure that you are in designer mode):


Note the Add page criteria option - that's the one you are looking for.

Also note that there is an Ignore dimensions option on page level, which means that you can choose to ignore criteria from a certain dimension on his particular page.

When you add criteria on page level you can create a report that includes data from a lot of different areas - sort of like multiple reports in one report.

This covers what you need to know in 98% of use cases - however, what if you we're applying criteria to the same attribute using the same operator (e.g. =)?

You could have a:

  • global criteria saying Salesperson = Alvaro Bennet
  • page criteria saying Salesperson = Luitpold Whyman

Then you would need to know which criteria "wins" - that's also called cardinality.


Cardinality of criteria

In the cardinality of criteria in TARGIT - the strength of Page Criteria fits in between global criteria and local criteria.

That means that if you have a global criteria saying Product Group = Jeans AND Shirts and T-shirts, you can have a page criteria overriding this - maybe saying Product Group = Jeans - and even on that page you can have an object with a local criteria saying Product Group = T-shirts.

So Page Criteria overrides Global and Local criteria overrides Page criteria.

This is based on the assumption that you are filtering on the same dimension hierarchy and using the same operator (=).

Note: If you add Page Iteration to a page or pages that have page criteria, it will override the Page Criteria. (probably not a scenario that will make sense in real world scenarios).





Was this article helpful?
0 out of 0 found this helpful



Please sign in to leave a comment.