Planning Analytics

Planning Analytics

Get AI-infused integrated business planning

 View Only

  • 1.  PAX - Office 365 compatability

    Posted Wed December 05, 2018 06:08 AM
    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.

    Thanks!

    Martin

    ------------------------------
    Martin Ingram
    ------------------------------

    #PlanningAnalyticswithWatson


  • 2.  RE: PAX - Office 365 compatability

    Posted Wed December 05, 2018 06:20 AM
    Hi Martin,

    1. Here is link to Microsoft 365 - IBM Is Office 365 supported for IBM Cognos Analysis for Microsoft Excel, IBM Planning Analytics for Microsoft Excel, or TM1 Perspectives? - United States
      Ibm remove preview
      IBM Is Office 365 supported for IBM Cognos Analysis for Microsoft Excel, IBM Planning Analytics for Microsoft Excel, or TM1 Perspectives? - United States
      Does IBM Cognos Analysis for Microsoft Excel, Planning Analytics for Microsoft Excel, or TM1 Perspectives support Microsoft Office 365?
      View this on Ibm >
    2. If you are seeing particular issues then my suggestion is to log a ticket with IBM support to investigate your issues.


    ------------------------------
    paul YOUNG
    ------------------------------

    Original Message


  • 3.  RE: PAX - Office 365 compatability

    Posted Wed December 05, 2018 07:08 AM
    Thank Paul - IBM support shared that with me, but there are a couple of problems with it;

    I can't confirm whether the version of Office 365 we are on is supported;

    "Microsoft Office 365 is supported so long as all of the following are true - 
    The version of Office installed (for example Office 2016) as part of Office 365, is supported by that version of Cognos Analysis for Microsoft Excel or Planning Analytics for Microsoft Excel."

    => There's no way of confirming that the version of Excel I'm using is Office 2016 or anything else.  

    FWIW I'm on Version 1811 (Build 11029.20079 Click to Run) - Microsoft doesn't seem to specify that as being '2016' or anything else - it's just 'Office 365'

    There are also seemingly ambiguous comments in there regarding whether or not 'Click to Run' installations are supported.



    ------------------------------
    Martin Ingram
    ------------------------------

    Original Message


  • 4.  RE: PAX - Office 365 compatability

    Posted Wed December 05, 2018 07:09 AM
    (I've also raised several support tickets on these issues - we seem to temporarily fix something on a user's machine and then it crops up again later)

    ------------------------------
    Martin Ingram
    ------------------------------

    Original Message


  • 5.  RE: PAX - Office 365 compatability

    Posted Wed December 05, 2018 07:15 AM
    Can you email me your ticket#s

    paul.young@ca.ibm.com

    ------------------------------
    paul YOUNG
    ------------------------------

    Original Message


  • 6.  RE: PAX - Office 365 compatability

    Posted Wed December 05, 2018 08:03 AM
    done (thankyou)

    ------------------------------
    Martin Ingram
    ------------------------------

    Original Message


  • 7.  RE: PAX - Office 365 compatability

    Posted Thu December 06, 2018 01:59 AM
    Hey Martin
    I certainly understand your furstration.  A few things that we have noted when using Pax:
    1. The dual add-in nature of Pax seems to make things a bit harder. We built some code to ensure both the com and regular add-ins are loaded and perspectives is not. This solves Alot 
    2. Alot of issues seem to be resolved if your users can run excel as an administrator. Excel loads the add-ins better
    3. We have seen some weird behavior where cells get formatted as text when they shouldn't. 
    4. We also have noted that adding columns or dragging ranges of cells around can result on some very weird results. Like lots of cells being turned into DBRWS but this mostly when working with dynamic reports


    ------------------------------
    Ryan Clapp
    https://www.linkedin.com/in/ryanclapp/
    ------------------------------

    Original Message