Greetings community, I am tasked to create some reports in a PBCS environment. I am running into an error creating some detail report requirements. I am getting:
"Unable to load the data entry form as the number of data entry cells after suppress missing blocks but before suppression exceeded the threshold.
Criteria: Number of cells before suppression
Error Threshold: 2000000
Warning Threshold: 1000000
Current Value: 19725916177"
The issue is that the members need to be level 0 to fulfill the report requirement but, the intersection (with suppression) calls for a large count of cells. Not sure what else to do. I realize PBCS doesn't allow to increase the thresholds to not crash servers. However, if a client has detailed report requirements what can be an option. My colleague tried to use the reporting cube but, the current version is not working.
Any help would be greatly appreciated. Thanks in advance.
Michael