TM1 Web- Cell Background Color Change

Post Reply
My24
Posts: 18
Joined: Tue Dec 12, 2017 2:57 pm
OLAP Product: TM1
Version: PA 2.0
Excel Version: Excel 2016

TM1 Web- Cell Background Color Change

Post by My24 »

Hello,

I am currently a user of PA 2.0.
We created a data entry view in TM1 Web for our customers, but in that view cell background colors are dark grey for uneditable cells, and open grey and white for editable cells. So, that is not good for the customer to distingush which are editable or not.

Then,I want to change background colors of editable cells but I do not know how to do.
I greatly appreciate people to solve this problem.

Regards.
BariAbdul
Regular Participant
Posts: 424
Joined: Sat Mar 10, 2012 1:03 pm
OLAP Product: IBM TM1, Planning Analytics, P
Version: PAW 2.0.8
Excel Version: 2019

Re: TM1 Web- Cell Background Color Change

Post by BariAbdul »

If it is a active form or slice TM1 supports conditional formatting for a criteria :
https://www.ibm.com/support/knowledgece ... 0064D.html

But other than that, the default behavior is not editable/rules driven cells are grayed out.Thanks
"You Never Fail Until You Stop Trying......"
My24
Posts: 18
Joined: Tue Dec 12, 2017 2:57 pm
OLAP Product: TM1
Version: PA 2.0
Excel Version: Excel 2016

Re: TM1 Web- Cell Background Color Change

Post by My24 »

BariAbdul wrote: Sun Dec 17, 2017 1:41 pm If it is a active form or slice TM1 supports conditional formatting for a criteria :
https://www.ibm.com/support/knowledgece ... 0064D.html

But other than that, the default behavior is not editable/rules driven cells are grayed out.Thanks
No, from active form of a report, we created data entry view. I just want to change color of some of these cells.
The view image is below.

Image
David Usherwood
Site Admin
Posts: 1453
Joined: Wed May 28, 2008 9:09 am

Re: TM1 Web- Cell Background Color Change

Post by David Usherwood »

That looks like a grid, not an active form. If you use an active form, you can put conditional formatting rules in the format area at the top and they will apply to the current output.
User avatar
PowerDim
Posts: 13
Joined: Thu Aug 07, 2014 12:44 pm
OLAP Product: TM1
Version: PAL 2x
Excel Version: Excel 2019
Location: Earth

Re: TM1 Web- Cell Background Color Change

Post by PowerDim »

My24 wrote: Mon Dec 18, 2017 7:30 am
BariAbdul wrote: Sun Dec 17, 2017 1:41 pm If it is a active form or slice TM1 supports conditional formatting for a criteria :
https://www.ibm.com/support/knowledgece ... 0064D.html

But other than that, the default behavior is not editable/rules driven cells are grayed out.Thanks
No, from active form of a report, we created data entry view. I just want to change color of some of these cells.
The view image is below.

Image

Hi, My24!

Maybe you have a solution for this problem?
Our users get confused and say, that they are uncomfortable seeing this zebra :)

--
Best regards,
Dmitry
Best regards,
Dmitry
Drg
Regular Participant
Posts: 159
Joined: Fri Aug 12, 2016 10:02 am
OLAP Product: tm1
Version: 10.2.0 - 10.3.0
Excel Version: 2010

Re: TM1 Web- Cell Background Color Change

Post by Drg »

if we talk abaut tm1 web you can change color directly in
C:\Program Files\ibm\cognos\tm1_64\webapps\tm1web\scripts\tm1web\themes\flat\flat.css
if you use this theme checked in browser in develop mode (f12)
Post Reply