TM1 Forum

Hi all,

I'm struggling with an active form where I have a number of stacked dimensions making up the row header and where I want to see the element names on every row, also when the element is repeating on consecutive rows. Default behavior in active forms is that these repeating row headers are not shown (font same color as background). I haven't found a setting/parameter that you can use to switch this behavior on/off.
What I tried is to use conditional formatting - this is working in Excel, but not in TM1Web - see pictures below (forget about the red boxes on the product dimension - these are no repeating elements as the element selections on the left side dimensions are different).
Does someone know how to get this working in TM1Web?

Michel

Michel Zijlema wrote:Does someone know how to get this working in TM1Web?

Which version of TM1 Web? In 9.4 and 9.5 the conditional formatting didn't get carried down below the 1st row of the active form.
A work-around that always works is just to hide the TM1RptRow columns and insert additional columns whose values simply equal those hidden row headers and format these however you want.

I agree it would be good to have an argument in the TM1RptRow formula to display or hide the repetitive values, the default functionality isn't always what you want.

lotsaram wrote:

Michel Zijlema wrote:Does someone know how to get this working in TM1Web?

Which version of TM1 Web? In 9.4 and 9.5 the conditional formatting didn't get carried down below the 1st row of the active form.
A work-around that always works is just to hide the TM1RptRow columns and insert additional columns whose values simply equal those hidden row headers and format these however you want.

Thanks for that Lotsa - that work-around is working for me. I'm on TM1 10.1.1 BTW.

lotsaram wrote:I agree it would be good to have an argument in the TM1RptRow formula to display or hide the repetitive values, the default functionality isn't always what you want.I agree it would be good to have an argument in the TM1RptRow formula to display or hide the repetitive values, the default functionality isn't always what you want.

This was exactly the place where I was expecting a parameter for this...

Michel

Resurrecting this thread from the dead...
I noticed this technote from IBM, which states that conditional formatting should be working in both Excel and TM1 Web from 10.2.2 FP1 onwards:

To see the hidden text in Excel you can change the color of the font by using a conditional format on the outer rows to override the default setting. This formatting on merged headers was previously not allowed in TM1 Web.

Michel

You could also try adding conditional formatting to the TM1RptRow formula related cells in the format range with a CF formula of: =TRUE
Set the font to black/automatic or whatever you need. Assuming no bugs in the version, this has worked for me.