Page 1 of 1

Dimension Subset TI Data Source Alias

Posted: Wed Feb 14, 2024 12:38 pm
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

Re: Dimension Subset TI Data Source Alias

Posted: Wed Feb 14, 2024 1:47 pm
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.

Re: Dimension Subset TI Data Source Alias

Posted: Wed Feb 14, 2024 2:54 pm
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

Re: Dimension Subset TI Data Source Alias

Posted: Wed Feb 14, 2024 6:11 pm
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.

Re: Dimension Subset TI Data Source Alias

Posted: Tue Feb 20, 2024 5:42 pm
by MarenC
Hi Lotsaram,

thanks for the confirmation of the feature!

Maren