COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: pdaprem on 20 Sep 2011 07:02:22 AM

Title: Issue With Crosstab Report Using Data From Two Different Dimesions As Rows
Post by: pdaprem on 20 Sep 2011 07:02:22 AM
I'm trying to define a Crosstab Report using rows from two different Dimensions (Have tried both Regular and Hierarchical) and a Column for a thrid Dimenison. I have need for ne reprt with a single measure and others with multiple measures. I can define a Crosstab with rows from one Dimension and a column from another and the report porduces the correct results. Once I introduce the rows from a second Dimension to create a Crosstab with columns form two different Dimensions I get rows displayed which have Null values for the Measure(s).  What do I need to do in order to create a Crosstab Report with data in rows from two different Dimensions??
Title: Re: Issue With Crosstab Report Using Data From Two Different Dimesions As Rows
Post by: MrTy on 28 Sep 2011 01:06:29 PM
Can you elaborate your problem a little more with an example?
Title: Re: Issue With Crosstab Report Using Data From Two Different Dimesions As Rows
Post by: pdaprem on 28 Sep 2011 05:45:34 PM
Issue has been resolved.
Title: Re: Issue With Crosstab Report Using Data From Two Different Dimesions As Rows
Post by: raztos on 16 Feb 2012 08:38:33 AM
Hi,
Can you share please your idea ? I have the same issue.

Thank you