Hello All,
Is it possible to make a text to red colour in tm1 web, although it is working in tm1 perspectives the same thing is not reflected in tm1 web.
And also i made some conditional formatting in a active sheet, it works in perspectives but not in tm1 web.
Could anyone please help me out, whether it will work in tm1 web.
Text display and conditional formatting in tm1 web
-
- MVP
- Posts: 3113
- 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: Text display and conditional formatting in tm1 web
Define 'TM1 Web'.
If you mean a cube view in TM1 Web, no it's not possible there. Just like in the Cube viewer in Architect / Perspectives.
If you mean a websheet (an Excel file with Excel and / or TM1 formulas that is uploaded to TM1 and consumed in TM1 Web): yes that should work.
If you have it working in Excel it should also work in TM1 Web when that file is uploaded (except for functionality that is not supported in TM1 Web, errors of your part, etc.) I suggest to reduce the uploaded sheet and use helper cells to check the different steps in your conditional formatting: does the formula work and return what you think it should return ? Do you apply it to the correct cells ? Etc.
If you mean a cube view in TM1 Web, no it's not possible there. Just like in the Cube viewer in Architect / Perspectives.
If you mean a websheet (an Excel file with Excel and / or TM1 formulas that is uploaded to TM1 and consumed in TM1 Web): yes that should work.
If you have it working in Excel it should also work in TM1 Web when that file is uploaded (except for functionality that is not supported in TM1 Web, errors of your part, etc.) I suggest to reduce the uploaded sheet and use helper cells to check the different steps in your conditional formatting: does the formula work and return what you think it should return ? Do you apply it to the correct cells ? Etc.
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
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
-
- Community Contributor
- Posts: 349
- Joined: Tue Aug 17, 2010 6:31 am
- OLAP Product: Planning Analytics
- Version: 2.0.5
- Excel Version: 2016
Re: Text display and conditional formatting in tm1 web
This has been pretty helpful as well. It will tell you what is and isn't supported in TM1Web by Excel Menu
http://www-01.ibm.com/support/docview.w ... wg27042154
http://www-01.ibm.com/support/docview.w ... wg27042154