Multiple PAX issues - Excel Office 365 compatibility?

Post Reply
Martin Ingram
Posts: 51
Joined: Thu May 15, 2008 9:11 am
OLAP Product: Planning Analytics
Version: IBM SaaS - Digital Pack
Excel Version: Office 365
Location: Reading / London

Multiple PAX issues - Excel Office 365 compatibility?

Post by Martin Ingram » Wed Dec 05, 2018 11:03 am


I haven't posted on these forums in many years and great to see that they're still going ;)

Wondering if anyone can share their experience of working with PAX. We have a number of intermittent issues that I've been struggling to find a permanent resolution for.

We have 3 main issues;

1 - TM1 formulae (eg DBRW) evaluating to #‌NAME? - we've resolved this a couple of times for users by re-installing the add-in, but in one case it needed a full Excel re-install

1 - Cut and Paste behaviour associated with Custom Reports - when columns are inserted within a custom report, any pasted values into those cells are automatically converted to unwanted DBRW formulae

3 - We also have intermittent issues with the IBM Planning Analytics add-in not loading for some users. In some cases this has been resolved by changing a registry setting. In others it may have been resolved by installing a new PAX version. Some people still have to manually put the add-in back in every time they start Excel

All of these issues have been going on for some time - we've seen them across PAX versions 35 through to 38. The only thing we seemingly have in common is that we are running Excel from Office 365

Really interested to hear from others on Office 365 - are you having these issues or have you seen them and managed to get the resolved.

Also, I'm interested in hearing from others on alternative versions of Excel to confirm whether their Excel / PAX environment is stable.



Posts: 61
Joined: Fri Feb 13, 2009 1:41 am
OLAP Product: IBM Planning Analytics Cloud
Version: 2.0.5
Excel Version: 2013 - 2016

Re: Multiple PAX issues - Excel Office 365 compatibility?

Post by jorelb » Mon Dec 10, 2018 10:09 pm

We experience the same issues and below is how we resolve them.
1) 99% of the time, when #NAME comes up with DBR/DBRW formulas, deleting the "Office Connection" located in C:\Users\username\AppData\Local\Cognos solves the problem. Users will just need to set up the connection URL.
If the above method does not work, yes we resort to uninstalling and re-installing the PAX.
2)Have not seen this specific use case.
3) This is a common occurrence and I have an open PMR for this specific issue. However, as usual, it is finger pointing between my Internal IT and IBM.
To make it easier for our users, we deployed a batch file that they execute which make the registry entries.


User avatar
Steve Rowe
Site Admin
Posts: 1828
Joined: Wed May 14, 2008 4:25 pm
OLAP Product: TM1
Version: 10.2.2., PAW
Excel Version: Nearly all of them

Re: Multiple PAX issues - Excel Office 365 compatibility?

Post by Steve Rowe » Tue Dec 11, 2018 1:27 pm

We've seen all of these and a few others.

The #Name one appears to be specific to the Excel add-ins (rather than the Com add in) becoming unchecked. Checking them again has resolved the situation whenever we have seen this issue.

Post Reply