Negligible value in consolidation

Post Reply
kenship
Regular Participant
Posts: 194
Joined: Thu May 30, 2013 1:41 pm
OLAP Product: Cognos
Version: Planning Analytics 2.0.7
Excel Version: 2010

Negligible value in consolidation

Post by kenship »

Hi, I have a simple report cube which:

1. Has no rule
2. Values (rounded to 2 decimal places by TI) are put in by a TI process from another cube.

Issue: Some consolidated cells show a negligible value (e.g. 0.000000000000013) when the children cells are added to a perfect $0.00 and therefore should be suppressed.

Is there any solution to this? Can I use a rule to round a consolidated cell without using too much resource?

Thanks.

Kenneth
BariAbdul
Regular Participant
Posts: 424
Joined: Sat Mar 10, 2012 1:03 pm
OLAP Product: IBM TM1, Planning Analytics, P
Version: PAW 2.0.8
Excel Version: 2019

Re: Negligible value in consolidation

Post by BariAbdul »

Have you tried formatting the numbers:
https://goo.gl/PT54d8 Thanks
"You Never Fail Until You Stop Trying......"
Duncan P
MVP
Posts: 600
Joined: Wed Aug 17, 2011 1:19 pm
OLAP Product: TM1
Version: 9.5.2 10.1 10.2
Excel Version: 2003 2007
Location: York, UK

Re: Negligible value in consolidation

Post by Duncan P »

If you are interested in why it happens then have a read of this.

The effect is magnified in consolidated numbers and the level of error increases the more leaf numbers are involved.
Post Reply