TM1 Web- Cell Background Color Change

Post Reply
My24
Posts: 15
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 » Sun Dec 17, 2017 10:07 am

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: 420
Joined: Sat Mar 10, 2012 1:03 pm
OLAP Product: TM1,Cognos
Version: 9.5.2
Excel Version: 2007

Re: TM1 Web- Cell Background Color Change

Post by BariAbdul » 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
"You Never Fail Until You Stop Trying......"

My24
Posts: 15
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 » 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

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

Re: TM1 Web- Cell Background Color Change

Post by David Usherwood » Mon Dec 18, 2017 12:44 pm

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: 6
Joined: Thu Aug 07, 2014 12:44 pm
OLAP Product: IBM Planning Analytics
Version: TM1 10.2, PA 2.0
Excel Version: Excel 2013
Location: Moscow, Russia

Re: TM1 Web- Cell Background Color Change

Post by PowerDim » Wed Feb 27, 2019 9:44 am

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

Drg
Posts: 117
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 » Tue Mar 05, 2019 7:28 am

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