Negligible value in consolidation

Post Reply
kenship
Posts: 58
Joined: Thu May 30, 2013 1:41 pm
OLAP Product: Cognos
Version: TM1 10.2
Excel Version: 2010

Negligible value in consolidation

Post by kenship » Wed Oct 18, 2017 2:43 pm

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: 404
Joined: Sat Mar 10, 2012 1:03 pm
OLAP Product: TM1,Cognos
Version: 9.5.2
Excel Version: 2007

Re: Negligible value in consolidation

Post by BariAbdul » Thu Oct 19, 2017 8:36 am

Have you tried formatting the numbers:
https://goo.gl/PT54d8 Thanks
"You Never Fail Until You Stop Trying......"

Duncan P
MVP
Posts: 584
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 » Wed Nov 15, 2017 5:36 pm

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