Print Page - Multi-line, Multi-Measure Crosstabs

Title: Multi-line, Multi-Measure Crosstabs
Post by: RickGardner on 18 Apr 2009 06:41:15 PM

I am trying to build a sales and profit report as follows:

Years across the top (DMR hierarchy with drill-down)
Product Group as the Row Hierarchy (again, drillable)
Each row to contain three measures, organized verically (three sub-rows): Sales, Cost, Profit

Is this a possibility with Cognos 8.3 or 8.4? Another option I am looking at is to create a special reporting file that has different records for each of the lines, but this is more complicated that I prefer to get!

Thanks

Title: Re: Multi-line, Multi-Measure Crosstabs
Post by: njz on 27 Jul 2009 12:15:53 PM

I'm trying to do the same thing without any luck ... did you figure out a solution?

COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS ReportNet => Report Studio => Topic started by: RickGardner on 18 Apr 2009 06:41:15 PM