Tm1 Web Dynamic Report Formatting Inconsistencies

[Ben@ActionKPI]

Hi All,

I have run into an issue with Dynamic report formatting becoming inconsistent over Tm1Web.

The issue is that the format equations i have created in column "A" do not seem to stay aligned with the correct rows once elements on the rows are expanded(over Tm1 web). This is leading to many problems on reports. IBM Support has so far been unable to resolve the issue.

I should note too that i have multiple dynamic reports stitched together that create the tm1web report.

You can see in the attached file "Collapsed" There is a blank white line i have formatted to be all white with white text. Once rows above that are expanded (view "expanded" attachement) that same formatting driven by column "A" doesnt follow the row its tied too and sticks in place in turn blanking out what should be showing in "Direct Costs".

Any Ideas?

[tomok]

Your screen shot is pretty much worthless since you don't show column A which is the key to your problem. I would look at the formulas in column A for the rows you think aren't formatted correctly and figure out why they are not returning the correct value. Keep in mind the value returned by the formula in column A is nothing more than a lookup value to be able to see what row in the formatting range the formatting should be based on. If you are pointing to the wrong format row then see what your formula is doing, i.e., why it has the wrong lookup value.

Also, if you have "stitched together" multiple active form areas into one report, as you say, please be aware that these multiple active form areas need to be stacked on top of each other AND you need to leave at least one blank row between the end of one active form data range and the next in order for it to work properly. You can always reduce the height to hide the blank row but it needs to be there. Don't know if that's your issue or not.

[Ben@ActionKPI]

Hi Tom,

The formula in Column A is built of nested if statements such as IF((Right(B13,1)="%","%",IF(B13="|","Blank")) as an example. The formula is built of look ups with the cell immediately to it right determining the value.

The formatting works fine in Excel and acts as it should. However over the web it begins to break down when multiple rows are expanded. The screen shots below show the look up values that would be in column "A". The stay true to what they should be but the formatting does not. Would the formatting range need to be expanded down to account for the rows expanding or does that formula automatically adjust as you expand the rows? One of the screen shots show expanded rows in tm1web the other is from excel. You can see that over the web it appears to make the text and back ground white of the direct costs row.

A second issue that's happening is that if multiple rows are expanded, further down the income statement the formatting becomes inconsistent too, for example section totals like "R&D total" which should be a blue color, change to a grey like a cell which does not represent a total. Making the report difficult to read as the "sectioning" identified by colors is lost.

[Ben@ActionKPI]

As mentioned above, here are two screen shots of what transpires further down the report as more rows are expanded.
One screen shot shows the proper formatting of what a total should look like (leaf should be white background). The other screen shot shows how the formatting is lost and all rows become grey, loosing the visual stop to each section and organization of the report.