Planning Analytics

 View Only

  • 1.  TI Process, use the Subset Member ID as default

    Posted Fri January 06, 2023 07:13 AM
    Hi all

    Here is an old problem that has bothered me for the longest time. 
    Perhaps there is an simple solution that I have missed. 

    In a TI process I always want to use the Member ID by default for any dimension or subset.
    The Member ID is the unique key

    TI processes use the alias that anyone can set for the subset so this is therefore very fragile for any subset that is not temporary. 

    I know that I can either get the ID by using DimensionElementPrincipalName( DimName, ElName ) when processing
    or use the SubsetAliasSet to use some predefined alias in the prolog of the TI process but I do not know how to set it as the "Member ID". 

    How can I set the Member ID as default e.g. in the prolog of the TI process?

    cheers, Asgeir




    ------------------------------
    Asgeir Thorgeirsson
    ------------------------------

    #PlanningAnalyticswithWatson


  • 2.  RE: TI Process, use the Subset Member ID as default

    Posted Fri January 06, 2023 10:55 AM
    Hi Asgeir

    You have SubsetAliasSet and SubsetAliasGet, but there is no something like SubsetAliasUnset. IBM why?, it would make sense to use an empty subset name to unset the alias: SubsetAliasSet( dim, subset, "")

    My workaround is to create a system alias TM1key for each dimension without populating it, so it will default to the element principal names.
    My approach is also to create system subsets (like }LEAVES and }ALL) and always use the TM1key alias. Those subsets are hidden from users and I can rely on the TM1key alias returning the principal names.

    ------------------------------
    Vlad Didenko
    Founder at Succeedium
    TeamOne Google Sheets add-on for IBM Planning Analytics / TM1
    https://succeedium.com/teamone/
    ------------------------------

    Original Message


  • 3.  RE: TI Process, use the Subset Member ID as default

    Posted Fri January 06, 2023 12:06 PM
    HI Asgeir,

    Are you using a subset as the data source or looping through the set using SubsetGetElementName, or something else?
    What version are you currently testing on?

    Running a quick test on my side on PAL 2.0.9.15 always seems to return the principal name.

    What you could try is using an intrinsic name: SubsetAliasSet( dim, subset, 'MEMBER_NAME');

    ------------------------------
    George Tonkin
    Business Partner
    MCI Consultants
    Johannesburg
    ------------------------------

    Original Message


  • 4.  RE: TI Process, use the Subset Member ID as default

    Posted Sat January 07, 2023 07:59 AM
    Or you could add a line with Dimnm( Dimix( … ))
    If you want to use hierarchies it will be ElementName( ElementIndex( … ))

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

    Original Message