Text display and conditional formatting in tm1 web

Post Reply
spartan
Posts: 47
Joined: Thu Jun 21, 2018 8:33 am
OLAP Product: IBM cognos
Version: 10.2.2
Excel Version: 2013

Text display and conditional formatting in tm1 web

Post by spartan »

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.
Wim Gielis
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

Post by Wim Gielis »

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.
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
PlanningDev
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

Post by PlanningDev »

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
Post Reply