TM1 Forum

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.

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.

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