Planning Analytics

 View Only

  • 1.  DIMNM(DIMIX()) Nesting to get a principal name in PAfE

    Posted Mon June 13, 2022 04:31 AM
    Reply
    I was creating a sheet the other day and used the old method of DIMNM(DIMIX()) to get the principal name of an element.

    I noticed that DIMNM now has a 3rd parameter for an alias which is great.

    However, it would be great to have a function to return the Principal name in PAfE
    Using DBRA on an intrinsic property like "MEMBER_NAME" returns balnk.

    Is there a fucntion that I just have not found or a better way than DIMNM(DIMIX())?

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

    #PlanningAnalyticswithWatson


  • 2.  RE: DIMNM(DIMIX()) Nesting to get a principal name in PAfE

    Posted Thu June 16, 2022 11:50 AM
    Reply
    SUBNM does that if you put the Alias to be "Member ID".

    I presume that you already knew that though, so that doesn't answer the question?

    ------------------------------
    Keith Would
    ------------------------------

    Original Message


  • 3.  RE: DIMNM(DIMIX()) Nesting to get a principal name in PAfE

    Posted Thu June 16, 2022 01:34 PM
    Reply
    Hi Keith,

    Thanks for that suggestion, however, SUBNM has always returned the principle name where the alias is invalid i.e. ZZZ or ABC as the alias works just as well as Member ID.
    The risk is obviously when someone tweaks the code and this no longer works, untold mayhem. It also only works in PAfE/Perspectives.

    Would be good to have a common function in rules and PAfE. Something simple but obviously hierarchy aware too.

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

    Original Message