COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Transformer => Topic started by: qvixote on 04 Jul 2016 01:24:27 PM

Title: Rollup is rounding values
Post by: qvixote on 04 Jul 2016 01:24:27 PM
Hello!

I have a Power Cube with 4 dimentions, and 4 measures. Three of the 4 measures must not sum or count on rollup, because I need they mantain the repeated value. In other cubes I've used maximum or avegare to achieve this and it's ok. The problem come in this case because those measures are float, with 2 decimals, and the cube is rounding the values, so when a value es 0,2, it shows 0; when 3,6, it shows 4.

I've tried with maximum and average, in regular rollup and duplicates rollup. I'v tried changing format, but it's still rounding values. In my others cubes I never have this problem because I always have integer measures.

Any idea?
Title: Re: Rollup is rounding values
Post by: qvixote on 07 Jul 2016 07:23:42 AM
I solved it by setting Input scale, Output scale and Precision properties.