Planning Analytics

Planning Analytics

Get AI-infused integrated business planning

 View Only
  • 1.  New TM1Val function

    Posted Fri December 15, 2023 11:20 AM
      |   view attached

    Hi all,

    I am trying to get the new TM1Val function to work in PAfE 92.

    My cube is located on the IBM cloud offering for partners.

    A normal DBRW works fine, a TM1Val to the same cell does not work.

    Please have a look at the picture in attachment.

    I am not sure about the version of TM1 Web in that cloud offering.

    The PA version is 2.0.9.15 or 11.8.1700.1 (19/10/2022).

    Thanks a lot,

    Wim



    ------------------------------
    Wim Gielis
    ------------------------------


  • 2.  RE: New TM1Val function

    Posted Fri December 15, 2023 11:24 AM
      |   view attached

    PAW screenshot



    ------------------------------
    Wim Gielis
    ------------------------------



  • 3.  RE: New TM1Val function

    Posted Fri December 15, 2023 12:28 PM

    Hi Wim

    This feature requires Planning Analytics for Microsoft Excel 2.0.92 and TM1 Web 2.0.92 to work. You will need to wait until the New Year for PASS 92 on Cloud.



    ------------------------------
    JILL MACLAURIN
    ------------------------------



  • 4.  RE: New TM1Val function

    Posted Fri December 15, 2023 12:37 PM
    Edited by Wim Gielis Fri December 15, 2023 12:40 PM

    Hello Jill,

    Thank you !

    So, to summarize, in the IBM cloud offering:

    • both PAW and PASS are updated automatically by IBM following the short cadence ? PAfE also but we need to download it (obviously). PAL follows the long cadence and is only updated through a support ticket by the customer.
    • do IBM have an overview somewhere of what version of PASS is offered in the cloud ? There is the Version.txt trick in the local PASS install but for cloud this will not work. For PAW it's easy to check at least.

    Have a great day,

    Wim



    ------------------------------
    Wim Gielis
    ------------------------------



  • 5.  RE: New TM1Val function
    Best Answer

    Posted Fri December 15, 2023 12:48 PM

    Hi Wim

    • On Cloud, we bundle PASS and PA Server together so the customer needs to request the upgrade for these components. Usually we release an IF on cloud that is the same server version but new PASS version (for example, there is a release coming in January I believe that will be 2.0.9.19 with PASS 92)
    • This technote is pretty good to show releases of all the components:  https://www.ibm.com/support/pages/node/6519826 . It isn't specific to Cloud though
    • The version.txt trick does work on Cloud :-)

    Cheers,
    Jill



    ------------------------------
    JILL MACLAURIN
    ------------------------------



  • 6.  RE: New TM1Val function

    Posted Sat December 16, 2023 10:17 AM

    Hello Jill,

    Thank you.

    Regarding the timeline reference, indeed I had hoped to see one for the Cloud. But this is good enough for now.

    The version.txt trick works, I must have done something wrong on Friday evening ;-)

    Wim



    ------------------------------
    Wim Gielis
    ------------------------------



  • 7.  RE: New TM1Val function

    Posted Wed December 20, 2023 12:07 PM

    Wim-

    You'll have to request IBM update the SW on the BP Servers when available as they aren't updated to the latest version automatically.

    Chris  



    ------------------------------
    Chris Courim
    ------------------------------



  • 8.  RE: New TM1Val function

    Posted Wed December 20, 2023 01:49 PM

    Hello Chris,

    Prior to your message, I already asked Peter D'Haeyer about a potential upgrade.

    He kindly confirmed that the BP04 partner servers in the IBM cloud will be reorganized over the Christmas period.

    Together with that the software will be upgraded to the latest releases.

    So that means new toys in the new year !

    Best regards,

    Wim



    ------------------------------
    Wim Gielis
    ------------------------------