Planning Analytics

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

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:
Sent: Fri January 06, 2023 07:12 AM
From: Asgeir Thorgeirsson
Subject: TI Process, use the Subset Member ID as default

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

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:
Sent: Fri January 06, 2023 07:12 AM
From: Asgeir Thorgeirsson
Subject: TI Process, use the Subset Member ID as default

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

Or you could add a line with Dimnm( Dimix( … ))
If you want to use hierarchies it will be ElementName( ElementIndex( … ))

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

Original Message:
Sent: Fri January 06, 2023 12:06 PM
From: George Tonkin
Subject: TI Process, use the Subset Member ID as default

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:
Sent: Fri January 06, 2023 07:12 AM
From: Asgeir Thorgeirsson
Subject: TI Process, use the Subset Member ID as default

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