Dimension Subset TI Data Source Alias

Post Reply
MarenC
Regular Participant
Posts: 350
Joined: Sat Jun 08, 2019 9:55 am
OLAP Product: Planning Analytics
Version: Planning Analytics 2.0
Excel Version: Excel 2016

Dimension Subset TI Data Source Alias

Post by MarenC »

Hi,

When I use a Dimension Subset as a data source in a TI process the preview does not show the alias name even though the subset has the alias set.

And when reading the data it doesn't show the alias either.

Is it a limitation that aliases do not show when the data source is Dimension Subset?

Maren
Wim Gielis
MVP
Posts: 3120
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.0.9.18
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: Dimension Subset TI Data Source Alias

Post by Wim Gielis »

Yes. You would retrieve the values in the Metadata and/or Data tab of the process. Or use the element attributes cube as the data source.
Best regards,

Wim Gielis

IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
MarenC
Regular Participant
Posts: 350
Joined: Sat Jun 08, 2019 9:55 am
OLAP Product: Planning Analytics
Version: Planning Analytics 2.0
Excel Version: Excel 2016

Re: Dimension Subset TI Data Source Alias

Post by MarenC »

Hi Wim,

thanks for the confirmation,

Yes I had come to the conclusion that using the element attributes cube as the source or looping over the elements to get the alias were the alternatives.

Maren
lotsaram
MVP
Posts: 3654
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TableManager1
Version: PA 2.0.x
Excel Version: Office 365
Location: Switzerland

Re: Dimension Subset TI Data Source Alias

Post by lotsaram »

MarenC wrote: Wed Feb 14, 2024 12:38 pm Is it a limitation that aliases do not show when the data source is Dimension Subset?
Not a limitation, a feature! ;)

It doesn't matter what alias is assigned to subsets used in datasources (views and subsets). From a data source variable perspective TI will always read the principal name.

As suggested already you can always use the principal name to return whichever attribute value you choose on the metadata or data tabs.
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.
MarenC
Regular Participant
Posts: 350
Joined: Sat Jun 08, 2019 9:55 am
OLAP Product: Planning Analytics
Version: Planning Analytics 2.0
Excel Version: Excel 2016

Re: Dimension Subset TI Data Source Alias

Post by MarenC »

Hi Lotsaram,

thanks for the confirmation of the feature!

Maren
Post Reply