[Version: 2021 - Summer]
[Build: 21222]
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).
Comments
Hi Niels.
It appears that applying "page criterias" on a page does not effect the preview of the page in the desktop client - the page criteria will only be applied when printing the report to PDF - is this correct?
/Thomas
Hi Thomas,
That is correct. The preview can only show the basic structure.
You will always need to print it to PDF to see effects such as page criteria, page iterations, some dynamic content etc.
BR / Ole
Thanks Ole :-) I will have to inform the users to keep this in mind.
/Thomas
Please sign in to leave a comment.