COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: ExpertPlanner on 04 Dec 2010 03:02:56 PM

Title: OLAP page breaks
Post by: ExpertPlanner on 04 Dec 2010 03:02:56 PM
 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.