COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: anwar_pat on 04 Jul 2007 04:52:09 AM

Title: Combination chart with 2 measures
Post by: anwar_pat on 04 Jul 2007 04:52:09 AM
Hi All,
  i have following data to create report
1.13 month rolling data item - for history suppose  from May06 to May07
2.Forward Bgt month data - advance 6 month - suppose from jun07 to Dec07
3.I have region like Asia,Emea,India etc
4.I have measure like total sale,total budget

Now i want to create a chart (combination) in such a way.In one line show both Measure data for Asia region with difference Solid and Dash line for Rolling month and Forwrd month..i mean once Rolling month finish it shud contine same line with dash line for Asia...so there wil be only 3 lines for 3 region.To make difference the line wil be solid and dash for Rolling and Forwrd..

Is anyone have any idea or any thought how we can achieve ?

thanks n advance
Title: Re: Combination chart with 2 measures
Post by: MDXpressor on 13 Jul 2007 11:57:00 PM
You need to end up with a single Measure data item, then create an additional data item to describe the measure (Total Sale, Total Budget, ...).  What you could do  is union a bunch of queries together, each one must have an identifier to describe the measure it is fetching.  Then you could use the Identifier as a series.