I have created a PDF book that loops over a large group of entities and has a page based on a cube view for each entity. Around 10%-15% of the pages are blank.
Is there an easy way to have the book skip pages for entities with no data?
Currently this would require a rule to be able to check if a report is going to have any intersections inside of it and if it did not return a value for an intersection that you define, you could skip it.
There is an enhancement request in place for this functionality with development.
Once the rule is imported you would call it in the book like this:
If BRString(GetCellValue, GetCellValue, accountMember = YourAccountName, entityMember = YourEntityName) = “TRUE”
The highlighted section is where you define the name value pairs. These could be parameters, sub vars, loop variables or hardcoded values.
I have attached a rule example for you. You would need to rename it to .xml and then import it into your application.