COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: sravantig on 05 Mar 2012 01:14:30 PM

Title: Aggregate and Rollup Aggregate for Region
Post by: sravantig on 05 Mar 2012 01:14:30 PM
I'm a newbie.

I'm inserting region in series for a combination line chart...

My Region has two members East Region, West Region.

But I want to show the data for the complete region, what should I do?
Title: Re: Aggregate and Rollup Aggregate for Region
Post by: MFGF on 06 Mar 2012 04:36:27 AM
Do you want to show the value for the sum of all regions as well as seeing the two regions East and West? Or just the All Regions summary?

Assuming the latter (and that it's a dimensional package) simply drag in the All Regions member instead of the two region members. If it's the former, try creating a Query Calculation which creates a set of the All Regions member and the East and West members, then use this in your series.

MF.
Title: Re: Aggregate and Rollup Aggregate for Region
Post by: sravantig on 06 Mar 2012 10:17:02 AM
It's the latter

I'm draging all region from a cube... not east and west individually.. but when I run my chart.. it shows like this(in attachment)
Title: Re: Aggregate and Rollup Aggregate for Region
Post by: MFGF on 06 Mar 2012 11:30:51 AM
How are your package insertion options defined? Do you have them set to insert the children of the selected member?
Title: Re: Aggregate and Rollup Aggregate for Region
Post by: sravantig on 06 Mar 2012 02:49:18 PM
Yes... Do I need to change any settings? I'm a newbie... so might confuse you with silly questions... hope I don't...

here is a screenshot