Print Page - Decimal values not showing up in Cognos 11

Title: Decimal values not showing up in Cognos 11
Post by: pradeepbi25 on 14 Mar 2017 05:42:35 AM

Hi

Recently we have upgraded to Cognos 11 from Cognos 10.2.2. There is an report which shows metric values in 2 decimals (eg. 10.26).
After upgrading to Cognos 11 this report is showing values with 0 decimals (eg. 10.00).

Same report displaying decimals in Cognos 10.2.2
When we use SQL as source instead of Framework manager package report is displaying decimals.

So we came to an conclusion that after upgrading to Cognos 11 there is something went wrong with the framework manager settings.

Can anyone help with the solution.

Thanks in advance

Pradeep

Title: Re: Decimal values not showing up in Cognos 11
Post by: MFGF on 24 Mar 2017 11:59:35 AM

Quote from: pradeepbi25 on 14 Mar 2017 05:42:35 AM
Hi

Recently we have upgraded to Cognos 11 from Cognos 10.2.2. There is an report which shows metric values in 2 decimals (eg. 10.26).
After upgrading to Cognos 11 this report is showing values with 0 decimals (eg. 10.00).

Same report displaying decimals in Cognos 10.2.2
When we use SQL as source instead of Framework manager package report is displaying decimals.

So we came to an conclusion that after upgrading to Cognos 11 there is something went wrong with the framework manager settings.

Can anyone help with the solution.

Thanks in advance

Pradeep

Is there a default data format defined for the item in FM? If so, how is it defined? If not, you can define one with 2 decimal places...

MF.

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: pradeepbi25 on 14 Mar 2017 05:42:35 AM