I am in the process to upgrade from TM1 10.2.2 to Planning Analytics 2.0.9 and i've found some troubles with Planning Analytics For Excel when i try to open a workbook that contains an active form:
When refreshing the active form in PAX the TM1RPTROW formula only returns the first element and then merge all the rows generated below making all DBRW’s return a #!VALUE! error as they are not finding any value for the dimension in the cell reference that it’s supposed to contain the dimension element generated from TM1RPTROW. In addition, the generated rows appear grouped.
Behaviors:
• The rows generated by the TM1RPTROW formula get grouped.
• The rows generated by the TM1RPTROW formula get merged.
• After ungroup the rows using the ungroup option in Excel ribbon data tab and click on “Rebuild sheet” option in Excel ribbon IBM Planning
Analytics tab, the rows are grouped again.
• When deleting the generated rows while PAX session is active/connected to TM1Server Microsoft Excel crashes and it’s automatically rebooted.
• Sometimes in a random way the active form is generated correctly for an instance when opened by the first time but returns to the error state
when finish to load.
- ActiveForm in PAX
- ActiveForm in PAX.PNG (242.4 KiB) Viewed 1680 times
Product version:
• IBM Planning Analytics 2.0.9
• IBM Planning Analytics For Excel 2.0.55
• Microsoft Excel Standard Version 2016 64 bits
• OS Windows 7 service pack 1 64bits
In the pictures attached you can see a screenshot of the active form in perspective and what happen when it's opened by PAX with some notes.
I really appreciate any help!
Best regards,
Jose José