If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Rollup is rounding values

Started by qvixote, 04 Jul 2016 01:24:27 PM

Previous topic - Next topic

qvixote

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?

qvixote

I solved it by setting Input scale, Output scale and Precision properties.