Active Forms Stacked Dimensions Formatting

[jacktuckerman]

Hello everyone,

I was wondering if anyone had any experience or knowledge of the following:

If one creates an active form of say, 5 stacked dimensions of row, at leaf level with no consolidations an active form, by default, will create the effect of the following:



By default, for the first 4 stacked dims TM1 will format (somehow) the text as the same colour as the background until a new element is found (i.e. GGG in Dim 1), i.e. appearing blank (i have marked and example by selecting a cell).

This is not defined in the format area, and in this example as there is no consolidations every row is a N level format area.

I was wondering if anyone one knows how/where TM1 is defining that cell font colours should match their background in the leading dimension rows until a new element value appears?

Thanks

Jack

This is clearly not defined in the format area, if you click in the cell

[dan.kelleher]

The formatting is usually driven from the cells in the same column of the format area of the active form
Have you checked the bottom-most cell in the format area, as this is for n level data? You can determine the format area by selecting the named range created in Excel.

What happens when you rebuild the active form?

[jacktuckerman]

Hey Dan,

Thanks for the response.

All the rows in this example are N level, as you can see from the values in column A.

Because the active form has stacked dimensions, when TM1 builds the active form formats the cell in column B after the first row differently to the first. If one selects the cell (as in the example), Excel knows that the value is "1-GL" it's just been formatted to be "hidden" until the next leaf element appears in the active form (i.e. in the example "GGG").

According to the format area definition in column A, there is no difference between these cells, so I was just wondering if anyone knew how TM1 active forms created this "additional" level of formatting.

Rebuilding the sheet does not change this, it's how it appears when it's first built anyway.

Jack

[TomBr]

Hi,

I had a similar issue and worked around it by using conditional formatting in the Format Area.

E.g. If the formatting on the N level was on row 7 in the format area, put in formula based conditional formatting in cell B7
=B7=B6
and set the font to Black or Automatic
This will ensure that all column B is visible.

Tom

[jacktuckerman]

Cheers Tom!

Awesome that is, solves me all sorts of UI problems - thanks ever so much!

* - This fix doesn't seem to work in TM1web, but that doesn't surprise me - was that your experience as well Tom?

Jack

[lotsaram]

Yes this is a common workaround when you want to show repetitive member names on rows. AFAIK it does not work in TM1 Web (most issues with conditional formatting in active forms that existed in 9.4 were resolved in 9.5 but there are still a few out there.)

[jacktuckerman]

Thanks a lot guys, yeah I'm having the TM1web problem, just have to live with it like all the other outstanding TM1web formatting issues.

It was out of curiousity to be honest, I do a lot of work with UIs in TM1 and was just wondering if anyone knew how TM1 was telling cells that, according to the way the format area works, are the same level yet is formatting them differently until the element value of a dimension changes.

Anyway, thanks both of you for your help.

Jack

[TM1KS]

Hi Everyone,
I'm trying to implement the repetition of the member names too.
However, I did not get how to implement the formula.

Could anyone please help?

Do I need to write =B6 in the Cell B7? I don't think that works.

[lotsaram]

Hi Everyone,
I'm trying to implement the repetition of the member names too.
However, I did not get how to implement the formula.

Could anyone please help?

Do I need to write =B6 in the Cell B7? I don't think that works.

Go back and re-read the post from TomBr properly. The formula is in the conditional format NOT in the cell!