If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Combination chart with 2 measures

Started by anwar_pat, 04 Jul 2007 04:52:09 AM

Previous topic - Next topic

anwar_pat

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

MDXpressor

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.
No, a proof is a proof. What kind of a proof? It's a proof. A proof is a proof, and when you have a good proof, it's because it's proven.

-Jean Chretien