COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: fml55555 on 23 May 2014 11:22:11 AM

Title: Line chart with two different years
Post by: fml55555 on 23 May 2014 11:22:11 AM
Hi Gurus,

I am trying to create a line chart which shows line charts for a specific measure for the current year and previous year (one line for current, another for previous). The x axis should show months. I am working with a dimensional model which does not have months independent of the year. The best I have is month/year. In this situation is it possible to create the kind of chart that I want in report studio(without making changes to the model in FM).

Thank you!
Title: Re: Line chart with two different years
Post by: Francis aka khayman on 25 May 2014 09:10:33 PM
try this:

http://cognosm.fm3online.com/dimensional/stripping-dimensionality-of-a-member/
Title: Re: Line chart with two different years
Post by: fml55555 on 27 May 2014 11:25:22 AM
Thanks a lot Khyaman. I am trying to implement the same. Will report in a while.