Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: Nithesh UC on 28 Mar 2013 01:02:33 AM

Title: Splitting the column into different columns
Post by: Nithesh UC on 28 Mar 2013 01:02:33 AM
Hi All,

I have a challenging scenario which is mentioned in the document attached.

Any kind of help is much appreciated.

Thanks,
uC
Title: Re: Splitting the column into different columns
Post by: cognostechie on 28 Mar 2013 01:17:22 AM
This is possible using MDX but the source has to be a Cube or DMR.

You can also do this by using a Crosstab instead of a List if your source is relational package. Use a Crosstab, put the time in rows, All and Trucks in Columns and nest the data item representing ODs under All and Trucks. You can also try the other way around. Put OD in the column and nest All and Trucks under the OD.
Text only | Text with Images