FM - Percentage Problem

[shwethagp]

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.

[blom0344]

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

[shwethagp]

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.

[shwethagp]

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

[blom0344]

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.

[cognostechie]

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