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).