Planning Analytics

 View Only
  • 1.  TM1Set Function

    Posted Wed October 18, 2023 12:10 PM
      |   view attached

    Hi All,

    Has anyone successfully used the new TM1Set function in #PlanningAnalyticswithWatson? Are there any specific requirements to make this function work within a #PlanningAnalyticsforMicrosoftExcelreport.I keep encountering a #Value!error.

    According to IBM's documentation, to utilize the TM1SET function, one must be using at least Planning Analytics for Microsoft Excel 2.0.81 and IBM Planning Analytics Workspace 2.0.80. I'm currently working with PA, PAFE, and PAW 2.0.88.

    For the Host argument, I've input the URL for the PAW server, and for the TM1 Server argument, I've provided the appropriate TM1 server name.

    I've also set the tracked area named range as the documentation suggests.

    Any guidance or tips would be greatly appreciated.


    Jackie Twigge

  • 2.  RE: TM1Set Function

    IBM Champion
    Posted Wed October 18, 2023 03:07 PM

    Have you tried pointing PAfE to PASS? That was the missing link for me.

    Have a look here for another discussion...

    George Tonkin
    Business Partner
    MCI Consultants

  • 3.  RE: TM1Set Function

    Posted Thu October 19, 2023 11:52 AM

    Hi George,

    Based on your feedback, we tested the TM1SET function in another environment with PASS, still pointing to the PAW URL, and the function worked as expected.

    PASS is not installed in the environment where I am getting the error and I suspect that might be what is causing the issue.

    I will see if we can get PASS installed in that environment and see if it resolves the issue there as well.

    Thank you for your help!

    Jackie Twigge

  • 4.  RE: TM1Set Function

    Posted Thu October 19, 2023 11:56 AM

    Hi John,

    We have the scope of the named range as Worksheet.

    I think PASS was our issue as George suggested.

    Thanks for your help.

    Jackie Twigge

  • 5.  RE: TM1Set Function

    Posted Wed October 18, 2023 08:36 PM

    Make sure the named range is worksheet scope.

    If you use 2.0.90 you can use Universal Reports (But you may need to set up the evaluation service - As I posted elsewhere I had to even though we do not have a distributed environment), there is a new option to convert from the viewer to a Universal Report. This sets up the named ranges etc and is an option start working with it. I will note that the created named range did not cover all TM1Set functions (Not sure if a bug or a reason for it) but you can modify the range definition using standard name manager editing. 

    John O'Leary