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.
TM1 to PA Upgrade - Web Report Not Showing Last Line
-
macsir
- Community Contributor
- Posts: 695
- Joined: Wed May 30, 2012 6:50 am
- OLAP Product: TM1
- Version: PAL 2.0.8
- Excel Version: Office 365
- Contact:
Re: TM1 to PA Upgrade - Web Report Not Showing Last Line
Is it for every report? Maybe show some snapshots.
-
declanr
- MVP
- Posts: 1663
- Joined: Mon Dec 05, 2011 11:51 am
- OLAP Product: Cognos TM1
- Version: PA2.0 and most of the old ones
- Excel Version: All of em
- Location: Manchester, United Kingdom
- Contact:
Re: TM1 to PA Upgrade - Web Report Not Showing Last Line
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.
Declan Rodger
-
Wim Gielis
- MVP
- Posts: 2456
- Joined: Mon Dec 29, 2008 6:26 pm
- OLAP Product: TM1
- Version: PAL 2.0.8
- Excel Version: Office 365 - latest
- Location: Brussels, Belgium
- Contact:
Re: TM1 to PA Upgrade - Web Report Not Showing Last Line
Also, refer to: http://www.wimgielis.com/tm1_activeform ... bia_EN.htm
Best regards,
Wim Gielis
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 112 TM1 articles and a lot of custom code
Newest blog article: Selecting elements in the Subset Editor quickly
Wim Gielis
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 112 TM1 articles and a lot of custom code
Newest blog article: Selecting elements in the Subset Editor quickly
-
rfielden
- Posts: 122
- Joined: Wed Aug 06, 2008 2:50 pm
- OLAP Product: TM1
- Version: 9.5.2
- Excel Version: 2007
- Location: Tega Cay, SC
Re: TM1 to PA Upgrade - Web Report Not Showing Last Line
Only active form reports having the issue.
Must of inserted the lines incorrectly as that did not work.
Must of inserted the lines incorrectly as that did not work.
-
rfielden
- Posts: 122
- Joined: Wed Aug 06, 2008 2:50 pm
- OLAP Product: TM1
- Version: 9.5.2
- Excel Version: 2007
- Location: Tega Cay, SC
Re: TM1 to PA Upgrade - Web Report Not Showing Last Line
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.
-
declanr
- MVP
- Posts: 1663
- Joined: Mon Dec 05, 2011 11:51 am
- OLAP Product: Cognos TM1
- Version: PA2.0 and most of the old ones
- Excel Version: All of em
- Location: Manchester, United Kingdom
- Contact:
Re: TM1 to PA Upgrade - Web Report Not Showing Last Line
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.
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.
Declan Rodger
-
rfielden
- Posts: 122
- Joined: Wed Aug 06, 2008 2:50 pm
- OLAP Product: TM1
- Version: 9.5.2
- Excel Version: 2007
- Location: Tega Cay, SC
Re: TM1 to PA Upgrade - Web Report Not Showing Last Line
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).
I will review latest post. The current AF report though does have 11 different sections (views).