TM1 Forum

We recently upgraded our TM1 instance to PA. Our P&L report when using Web is not displaying the last line of the report (which is income). The report works fine when using perspectives. Open issue with IBM for a week with no movement forward. Any assistance/insight would be appreciated.
Note: The report is an Active Form.

Is it for every report? Maybe show some snapshots.

Insert a few extra rows under the active form area and add a border to the cells a few rows down then reupload the sheet and it will be fine.

Also, refer to: http://www.wimgielis.com/tm1_activeform ... bia_EN.htm

Only active form reports having the issue.

Must of inserted the lines incorrectly as that did not work.

When I unhide the rows and columns, I am seeing a 0 AF format code in Column A for the CTO line in perspectives yet the web is showing an 'N' for the same line.

rfielden wrote: ↑Thu Dec 05, 2019 6:27 pm Only active form reports having the issue.

Must of inserted the lines incorrectly as that did not work.

Delete all rows apart from the first in the active form (the one that actually contains the tm1rptrow formula.
A few rows below that type a word into a cell, something visible. Update the file onto the server (with the af rows still deleted.)
You should now have the extra space so that the websheet stops at your typed word - assuming that works play about with changing the word to something less noticeable.

rfielden wrote: ↑Thu Dec 05, 2019 6:35 pm When I unhide the rows and columns, I am seeing a 0 AF format code in Column A for the CTO line in perspectives yet the web is showing an 'N' for the same line.

This sounds like a bigger issue; I guess you have changed the default formula from column a to something custom - can you provide the formula that you are using? The web and perspectives can perform calculations in different orders - meaning that a dependent cell may not yet be calculated in the web in time.

IBM was able to recreate the issue in latest version. Defect PH20190 has been logged.

I will review latest post. The current AF report though does have 11 different sections (views).