Hi Everyone,
We recently upgraded our Planning Analytics Workspace (PPAW) / Planning Analytics for Excel (PAfE) environment from version 2.1.9 to 2.1.19, and since the upgrade we have started facing an issue in one of our PAfE templates.
The issue is that cells using the DBRW function are displaying #VALUE! errors in Excel. The same errors are also visible when the workbook is published and accessed through TM1 Web.
DBRW
#VALUE!
What makes this more confusing is that the exact same template works perfectly fine in another environment where the PAW/PAfE version is still 2.1.9 and has not been upgraded.
Has anyone else faced a similar issue after upgrading to version 2.1.19 (or newer)?If yes, could you please share what caused it and how you resolved it?
Any suggestions or troubleshooting steps would be greatly appreciated.
Thanks in advance!
Yes, we've seen very similar, but with #NUM and #Value errors. Report works just fine in versions prior to 2.1.19+. They just posted a Known Issue today.