TM1 Formula trace

Post Reply
anilbasa
Posts: 2
Joined: Sat Dec 13, 2014 8:59 am
OLAP Product: Cognos TM1
Version: 10.2.2
Excel Version: 2013

TM1 Formula trace

Post by anilbasa »

Hi Team

I would like post question on TM1 Tracing, Users were asking for formula tracing from the Budget View, i understand that TM1 has the functionality to trace the formula but users may not understand the Tm1 specific formulas, please advice if there is any other better method like Excel where formula is self explanatory.

Thanks
Anil
Alan Kirk
Site Admin
Posts: 6667
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: TM1 Formula trace

Post by Alan Kirk »

anilbasa wrote:
I would like post question on TM1 Tracing, Users were asking for formula tracing from the Budget View, i understand that TM1 has the functionality to trace the formula but users may not understand the Tm1 specific formulas, please advice if there is any other better method like Excel where formula is self explanatory.
This is not an Enhancement request (refer to the Enhancement Forum Guidelines) and has been moved to the correct forum.

There is no built in functionality for doing a formula trace in TM1. One of the most common ways of obtaining that functionality is by using the TM1 Tools add-in, which will be found here.
"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.
Wim Gielis
MVP
Posts: 3240
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.1.5
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: TM1 Formula trace

Post by Wim Gielis »

Train the users. In the end, that's the best you can do.
Or hire (professional) TM1 training if the competence is not in-house.
Best regards,

Wim Gielis

IBM Champion 2024-2025
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
anilbasa
Posts: 2
Joined: Sat Dec 13, 2014 8:59 am
OLAP Product: Cognos TM1
Version: 10.2.2
Excel Version: 2013

Re: TM1 Formula trace

Post by anilbasa »

Thank you Alan and Wim for quick reply
Wim Gielis
MVP
Posts: 3240
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.1.5
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: TM1 Formula trace

Post by Wim Gielis »

anilbasa wrote:Thank you Alan and Wim for quick reply
You're welcome. Thank you for providing feedback.
Best regards,

Wim Gielis

IBM Champion 2024-2025
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
Post Reply