Print Page - FM - Percentage Problem

Title: FM - Percentage Problem
Post by: shwethagp on 27 Oct 2011 01:55:25 PM

Hi,

I have a problem with Percentage display.

Value target_percent is loaded from SSIS to Cognos.

When I display the values using query studio the percentage is sum up. Can any one help to resolve this?

Thanks,
Shwetha.

Title: Re: FM - Percentage Problem
Post by: blom0344 on 27 Oct 2011 02:01:56 PM

I personally define percentages primarily as attributes, making sure that no aggregate is set in FM. By default Cognos will read a percentage as a measure and setting the regular aggregate to sum. You need to correct this in the model

Title: Re: FM - Percentage Problem
Post by: shwethagp on 27 Oct 2011 02:07:33 PM

Thanks for the response.
Yes you are right the Regular aggregate is "Sum" and Data type is Decimal.

Can you help me to convert the value to attribute.

Title: Re: FM - Percentage Problem
Post by: shwethagp on 27 Oct 2011 02:15:26 PM

I converted the column to attribute. What should be the aggregate value, if I change to automatic should it work?

Title: Re: FM - Percentage Problem
Post by: blom0344 on 28 Oct 2011 03:05:42 AM

A percentage is a non-additive measure. Normally it should not have any aggregate set. In rare cases it makes sense to compute averages over percentages, then you can apply average from within the report.

Title: Re: FM - Percentage Problem
Post by: cognostechie on 28 Oct 2011 11:40:02 AM

Mark the percentage as 'Unsupported', not as an attribute.

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Framework Manager => Topic started by: shwethagp on 27 Oct 2011 01:55:25 PM