Planning Analytics

Planning Analytics

Get AI-infused integrated business planning

 View Only

  • 1.  Using SubNM's in PAfE to reference Private sets seems unsupported

    Posted Thu April 21, 2022 05:37 AM

    Where a user has a Private set named the same as the Public set, there seems to be no way to get the formula to reference the Private set.

    Any results returned from the SubNM always relate to the Public set.
    In Perspectives, SubNM appears to return values from the Private set first and is the expected behaviour in PAfE

    TM1SubsetToSet by default looks for a Private set first then Public, unless you specified which to use in the MDX.

    Is there any way to specify Private/Public or are SubNMs limited to Public sets only?



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

    #PlanningAnalyticswithWatson


  • 2.  RE: Using SubNM's in PAfE to reference Private sets seems unsupported

    Posted Mon April 25, 2022 04:14 PM

    you're correct of course that a private object should take precedence for a subnm, I suggest initiating a support case.

    in the meantime, can you list the software version mix in use and the connection mode in PA for Excel?



    ------------------------------
    Ted Phillips
    ------------------------------

    Original Message


  • 3.  RE: Using SubNM's in PAfE to reference Private sets seems unsupported

    Posted Mon April 25, 2022 11:55 PM
    Hi Ted,

    I am using Microsoft® Excel® for Microsoft 365 MSO (Version 2203 Build 16.0.15028.20218) 64-bit and PAfE 2.0.73

    I will try log a support case on this through the client where it was raised.

     



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

    Original Message