COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: f-pasquier on 22 Jan 2015 08:30:25 AM

Title: Measure repeater with multidimensional data
Post by: f-pasquier on 22 Jan 2015 08:30:25 AM
Hi guys,

I use a multidimensional data  source (tm1) and I need to build a report made by a set of charts, the charts showing common dimensions, and each showing a different measure (of the same cube). So my idea was to create a Query with a set of measures, attach this query to a repeater and include a chart in this repeater with the appropriate Master Detail Relationships. But I don't know how to create a set of measures. this seems not supported by Report Studio.

I did that many times with "real" dimensions (not measures) and it worked well.

Would somebody know how to do that?
Title: Re: Measure repeater with multidimensional data
Post by: MFGF on 22 Jan 2015 08:40:48 AM
Quote from: f-pasquier on 22 Jan 2015 08:30:25 AM
Hi guys,

I use a multidimensional data  source (tm1) and I need to build a report made by a set of charts, the charts showing common dimensions, and each showing a different measure (of the same cube). So my idea was to create a Query with a set of measures, attach this query to a repeater and include a chart in this repeater with the appropriate Master Detail Relationships. But I don't know how to create a set of measures. this seems not supported by Report Studio.

I did that many times with "real" dimensions (not measures) and it worked well.

Would somebody know how to do that?

Hi,

Measures can't be assembled into sets - this concept is only applicable to members. Is it feasible simply to build multiple charts on the page?

Cheers!

MF.
Title: Re: Measure repeater with multidimensional data
Post by: f-pasquier on 22 Jan 2015 08:42:54 AM
In principle, I can create multiple charts "manually" but I don't know how to ensure they all show the same axis range (Use Same Range for All Instances)