Tm1 Web Dynamic Report Formatting Inconsistencies

Post Reply
Ben@ActionKPI
Posts: 4
Joined: Wed Feb 01, 2017 7:36 pm
OLAP Product: TM1
Version: 10.2
Excel Version: 16

Tm1 Web Dynamic Report Formatting Inconsistencies

Post by Ben@ActionKPI » Wed Jan 08, 2020 8:32 pm

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?
Attachments
Expanded.PNG
Expanded.PNG (22.31 KiB) Viewed 80 times
Collapsed.PNG
Collapsed.PNG (14.11 KiB) Viewed 80 times

tomok
MVP
Posts: 2661
Joined: Tue Feb 16, 2010 2:39 pm
OLAP Product: TM1, Palo
Version: Beginning of time thru 10.2
Excel Version: 2003-2007-2010-2013
Location: Atlanta, GA
Contact:

Re: Tm1 Web Dynamic Report Formatting Inconsistencies

Post by tomok » Wed Jan 08, 2020 8:59 pm

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.
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/

Ben@ActionKPI
Posts: 4
Joined: Wed Feb 01, 2017 7:36 pm
OLAP Product: TM1
Version: 10.2
Excel Version: 16

Re: Tm1 Web Dynamic Report Formatting Inconsistencies

Post by Ben@ActionKPI » Thu Jan 09, 2020 4:04 pm

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.
Attachments
expanded Tm1web.PNG
expanded Tm1web.PNG (62.47 KiB) Viewed 54 times
expanded 2.PNG
expanded 2.PNG (17.15 KiB) Viewed 54 times

Ben@ActionKPI
Posts: 4
Joined: Wed Feb 01, 2017 7:36 pm
OLAP Product: TM1
Version: 10.2
Excel Version: 16

Re: Tm1 Web Dynamic Report Formatting Inconsistencies

Post by Ben@ActionKPI » Thu Jan 09, 2020 4:13 pm

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.
Attachments
section total lost format.PNG
section total lost format.PNG (64.18 KiB) Viewed 51 times
section total.PNG
section total.PNG (56.66 KiB) Viewed 51 times

Post Reply