I'm building a cross tab in Cognos 8.4.1 RS against a TM1 datasource. I have the GL account dimension on the rows. On the columns I have the years. The cube has an additional dimension for each piece of the GL string (Department, Property, Function, and Fund). I need the report to give me a new page for each combination of Department, property, Function, and Fund that results in a non-zero account balance.
That is to say, that I have one dimension on the rows and one dimension on the columns. The other 4 dimensions will be page headers and I need a page break for every combination of the page dimensions.
I have used a page set and tried grouping each page dimension but that results in an out of memory error. It works for 2 dimension but not 3. I have also tried using page layers but the report never returns (hour glass).
Any suggestions on a way to tackle this? the cube is sparse. I think the key is to have the report generate mdx that will not return combinations that have zero account balances - but I haven't figured out a way to do that.