Securing an integer using break back

Post Reply
nimol
Posts: 20
Joined: Fri Jun 10, 2011 6:12 am
OLAP Product: TM1
Version: 1022
Excel Version: 2010

Securing an integer using break back

Post by nimol »

How do you secure an integer when you use break back functionality in Cognos TM1? Let's say you use TM1 for demand planning and want to secure that units sold is an integer when you perform break back.
Wim Gielis
MVP
Posts: 3105
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.0.9.18
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: Securing an integer using break back

Post by Wim Gielis »

Hello,

If you mean Break back with the built-in Data spread functionality or shortcut commands or entering a value at a consolidated level, then you can't do that.
The closest you can get is by using a second measure which contains a TM1 rule to round up or round down the unrounded figure.
Also, plug in the difference (if any) at a dummy element somewhere to make the totals match.
Or, use a TI process instead of a TM1 rule if it would be too heavy and/or not so dynamic.

If you use a custom TI process instead of the built-in commands, you could also do your own treatment of the data but it's far from easy to say the least.
Best regards,

Wim Gielis

IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
iansdigby
Community Contributor
Posts: 109
Joined: Thu Feb 26, 2009 8:44 am
OLAP Product: TM1
Version: 9 + 10 + Plan An
Excel Version: All
Location: Isle of Wight, UK

Re: Securing an integer using break back

Post by iansdigby »

If it's only a user perception issue, you could just accept the fact that spreading will produce non-integer data, simply formatting the numbers in the cubes as integers, so that no-one will mind. In a driver-based planning context your greatest possible error would be between -1 and 1 and this wouldn't matter.
"the earth is but one country, and mankind its citizens" - Baha'u'llah
Post Reply