Planning Analytics

 View Only
Expand all | Collapse all

IBM Framework for Office and PAfE 2.0.66 installs

  • 1.  IBM Framework for Office and PAfE 2.0.66 installs

    IBM Champion
    Posted Fri August 20, 2021 02:45 AM
    Edited by System Fri January 20, 2023 04:48 PM
    HI,

    Does anyone know what the installation method and sequence should be for new users who will be using templates that leverage the PAX API?

    Essentially, if the user has the IBM_PAfE_x64_2.0.66.9.xll added to their Excel does this somehow add the IBM Framework for Office?
    I cannot see this on my installation as my CognosOfficeShim12.dll is still dated 2021/02/12.

    Is there a separate install for IBM Framework for Office? Only seeing Cognos for Microsoft Office on Fix Central.

    I may have missed it in the documentation somewhere but would appreciate if someone can guide or clarify on the above.

    Thank you.

    Edit: Enabling the IBM Framework for Office gives me 2 PA Menus in Excel - one for 2.0.62 and another for 2.0.66. Previous versions of PAfE were removed before switching to 2.0.66. Without enabling the IBM Framework for Office, all macro code with API calls fail.

    ------------------------------
    George Tonkin
    ------------------------------
    #PlanningAnalyticswithWatson


  • 2.  RE: IBM Framework for Office and PAfE 2.0.66 installs

    Posted Fri August 20, 2021 03:53 PM
    Hi George,

    Assuming there's no Cognos Analytics in the mix, from my experience with PAFEv65+, there is only a single XLL file to manage.

    Sequence:
    1. Users should uninstall the "Classic" IBM PAFE add-in using the Uninstaller that's on their Start Menu.
    2. Then, the user should add the single XLL to Excel Add-Ins and enable it.
    3. Upon enabling the Excel Add-in two additional COM Add-ins automatically appear: IBM Planning Analytics for Excel Addin + IBM Planning Analytics for Excel Addin (Custom Task Pane Helper). No further action is required.
    IBM Framework for Office is part of the "Classic" IBM PAFE that should be uninstalled in step 1.

    This is how we're using it on my end.

    Thanks!

    ------------------------------
    Adam
    ------------------------------



  • 3.  RE: IBM Framework for Office and PAfE 2.0.66 installs

    IBM Champion
    Posted Fri August 20, 2021 04:08 PM
    Hi Adam,

    Thanks for the feedback.

    I agree that 2.0.65 onwards should be standalone but not seeing the automation components needed for my templates with macros to run.

    The API code is referencing the older framework and I have not seen anything on a new framework or changes required for API code when upgrading to 2.0.65 or higher.

    I am definitely missing something, just not sure what.

    ------------------------------
    George Tonkin
    ------------------------------



  • 4.  RE: IBM Framework for Office and PAfE 2.0.66 installs

    Posted Fri August 20, 2021 04:23 PM

    George,

    The PAFE API has not changed. We cut over from 2.0.57 to 2.0.66 and all VBA functionality remains working.

    When you say "referencing the older framework", are you seeing a VBA error w/ 
    Set m_oCOAutomation = Application.COMAddIns("CognosOffice12.Connect").Object.AutomationServer

    We have only seen this issue in one case, and only in testing, never in production. If you have BOTH classic PAFE and XLL-based PAFE enabled simultaneously, the XLL-based PAFE is blocked from creating a COM Addin named "CognosOffice12.Connect" and will instead name the COM Addin "CognosOffice12.ConnectPAfEAddin". 

    Workaround would be:
    Set m_oCOAutomation = Application.COMAddIns("CognosOffice12.ConnectPAfEAddin").Object.AutomationServer

    HOWEVER, you should not need the workaround. Instead you should make sure the classic PAFE is fully uninstalled.

    Let me know if this is what you're seeing or it's something else.



    ------------------------------
    Adam
    ------------------------------



  • 5.  RE: IBM Framework for Office and PAfE 2.0.66 installs

    IBM Champion
    Posted Sat August 21, 2021 02:51 AM
    HI Adam,

    Thanks for all the assistance - much appreciated.

    There was nothing remaining in my Add or Remove Programs but tracked down the Uninstall for the IBM for MS Office framework and removed it.

    After doing that, all is working as expected now.

    ------------------------------
    George Tonkin
    ------------------------------



  • 6.  RE: IBM Framework for Office and PAfE 2.0.66 installs

    Posted Mon August 23, 2021 03:55 AM
    ​Guys

    A follow up question on this.

    We deploy our PAfE versions via a software package which comes down the pipe to the users' laptop

    Our steps have been to launch the Uninstall on the user laptop, and then, as a "belt and braces" remove the following folders, before forcing a restart of the laptop itself :

    • C:\Program Files (x86)\ibm
    • C:\Program Files\ibm
    • C:\Users\<USER.ACCOUNT>\AppData\Roaming\Applix
    • C:\Users\<USER.ACCOUNT>\AppData\Local\Cognos
    The installation of the new version then takes place and the connection strings are added back in.

    We are on v64, and we are aware that from v65 onwards there is no longer an issetup.exe but we have the xlls.

    How are these added to the user machine ? Is there an install to follow or do we need to push these out and change our package to lift the xll in the Excel add-ins, after we have placed it somewhere appropriate ?

    Cheers
    Ajay

    ------------------------------
    AJAY CHANDHOK
    ------------------------------



  • 7.  RE: IBM Framework for Office and PAfE 2.0.66 installs

    IBM Champion
    Posted Mon August 23, 2021 04:04 AM
    HI Ajay,

    After ensuring that ALL components of the old versions have been removed, essentially you need to decide where you will locate the XLL going forward and what you are going to name it. Once you have done this and added it in then updates should simply be overwriting the old with the new.

    This article may help too

    ------------------------------
    George Tonkin
    ------------------------------



  • 8.  RE: IBM Framework for Office and PAfE 2.0.66 installs

    Posted Mon August 23, 2021 11:16 AM
    Thanks for the info George

    ------------------------------
    AJAY CHANDHOK
    ------------------------------



  • 9.  RE: IBM Framework for Office and PAfE 2.0.66 installs

    Posted Tue August 24, 2021 10:36 AM
    Ajay - there's also a good tip at the link below.
    https://www.ibm.com/docs/en/planning-analytics/2.0.0?topic=dupamesxaiv2l-installing-planning-analytics-microsoft-excel-add-in-file-as-add-in

    It recommends removing the version number from the xll file before installing. That way the file can easily be swapped out with the new version for future upgrades.





  • 10.  RE: IBM Framework for Office and PAfE 2.0.66 installs

    Posted Tue August 24, 2021 01:00 PM
    This is a very useful link !!

    Thanks very much​ Kirk

    ------------------------------
    AJAY CHANDHOK
    ------------------------------



  • 11.  RE: IBM Framework for Office and PAfE 2.0.66 installs

    IBM Champion
    Posted Tue August 24, 2021 07:55 PM

    George, check out this post. It's updated with all the steps needed to deploy 2.0.66+, including making it repeatable for future versions and adding it to the Start menu. 

    https://exploringtm1.com/how-to-upgrade-install-planning-analytics-for-excel-pax/



    ------------------------------
    John Vaughan
    www.ExploringTM1.com
    john.vaughan@exploringtm1.com
    ------------------------------