Change decimal format for Simple Element?

Post Reply
cpmcoehyd
Posts: 2
Joined: Mon Jan 24, 2011 8:26 am
OLAP Product: Cognos TM1
Version: 9.5
Excel Version: 2007

Change decimal format for Simple Element?

Post by cpmcoehyd »

Hi,
On tracing a rule for a particular cell value, it shows that there are 4 decimals for a simple element.
Is it possible, in any way, to change these number of decimals ( to make them three or remove them completely)?
Coz, while calculating, it takes all the decimal values into consideration, even though it doesn't display them.
Can someone help me regarding this??

Thanks
User avatar
Alan Kirk
Site Admin
Posts: 6606
Joined: Sun May 11, 2008 2:30 am
OLAP Product: TM1
Version: PA2.0.9.18 Classic NO PAW!
Excel Version: 2013 and Office 365
Location: Sydney, Australia
Contact:

Re: Change decimal format for Simple Element?

Post by Alan Kirk »

cpmcoehyd wrote:Hi,
On tracing a rule for a particular cell value, it shows that there are 4 decimals for a simple element.
Is it possible, in any way, to change these number of decimals ( to make them three or remove them completely)?
Coz, while calculating, it takes all the decimal values into consideration, even though it doesn't display them.
Can someone help me regarding this??
Welcome to the Forum.

While questions (and new members) are welcomed, when it's something fundamental like this your best starting point (after the Request For Assistance Guidelines) is the Advanced Search feature which you'll find a link to at the top right of the screen.

The question of decimal places has been discussed in at least two recent threads which you may find useful:
http://forums.olapforums.com/viewtopic. ... 63&p=16961
http://forums.olapforums.com/viewtopic. ... 38&p=17781
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
cpmcoehyd
Posts: 2
Joined: Mon Jan 24, 2011 8:26 am
OLAP Product: Cognos TM1
Version: 9.5
Excel Version: 2007

Re: Change decimal format for Simple Element?

Post by cpmcoehyd »

Alan Kirk wrote:
cpmcoehyd wrote:Hi,
On tracing a rule for a particular cell value, it shows that there are 4 decimals for a simple element.
Is it possible, in any way, to change these number of decimals ( to make them three or remove them completely)?
Coz, while calculating, it takes all the decimal values into consideration, even though it doesn't display them.
Can someone help me regarding this??
Welcome to the Forum.

While questions (and new members) are welcomed, when it's something fundamental like this your best starting point (after the Request For Assistance Guidelines) is the Advanced Search feature which you'll find a link to at the top right of the screen.

The question of decimal places has been discussed in at least two recent threads which you may find useful:
http://forums.olapforums.com/viewtopic. ... 63&p=16961
http://forums.olapforums.com/viewtopic. ... 38&p=17781

Thanks Alan,
But I've already gone through the two threads not finding any suitable answer. So.. !!

Thanks by the way!!
tomok
MVP
Posts: 2832
Joined: Tue Feb 16, 2010 2:39 pm
OLAP Product: TM1, Palo
Version: Beginning of time thru 10.2
Excel Version: 2003-2007-2010-2013
Location: Atlanta, GA
Contact:

Re: Change decimal format for Simple Element?

Post by tomok »

Strangely enough, TM1 does ship with reference manuals. In the IBM Cognos TM1 Reference Guide you can find information about two functions, ROUND and ROUNDP.
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/
David Usherwood
Site Admin
Posts: 1454
Joined: Wed May 28, 2008 9:09 am

Re: Change decimal format for Simple Element?

Post by David Usherwood »

I believe I've understood what you're after, which is to vary the number of decimals in the rules tracer; and the answer is no (or, to be really cautious, I'm not aware of how).
Post Reply