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
TM1 Formula trace
-
- 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
This is not an Enhancement request (refer to the Enhancement Forum Guidelines) and has been moved to the correct forum.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.
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.
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-
- 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
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.
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
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
-
- 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
Thank you Alan and Wim for quick reply
-
- 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
You're welcome. Thank you for providing feedback.anilbasa wrote:Thank you Alan and Wim for quick reply
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
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