Page 1 of 1

Query on SwapAliasWithPrincipalName

Posted: Tue Apr 17, 2018 3:35 pm
by sreesuku
Hi Team,

I have a query on SwapAliasWithPrincipalName.

Does this function swaps the names for all elements in the dimensions with the specified alias names ?
I have created a dimension subset with selected list of elements only and used this as source in the swap TI.

I have put the function in SwapAliasWithPrincipalName(DimName,AiasName,Flag) data tab.

But I have observed that elements names are getting swapped for all elements even though I chose the subset as source

Am I missing anything here ?

Re: Query on SwapAliasWithPrincipalName

Posted: Tue Apr 17, 2018 4:47 pm
by Wim Gielis
Use this function in the Prolog tab, not the Data tab.
It’s done for the entire dimension.
For elements outside the subset, use the same element name in the alias.

Re: Query on SwapAliasWithPrincipalName

Posted: Wed Apr 18, 2018 12:13 pm
by PavoGa
If you want to swap aliases based on subsets of elements, create an alias for swapping purposes only. Create your subset, update the alias only for your subset members, the swap the alias. The elements with unpopulated aliases will retain their original name as you probably know.

I think you can use SwapAliasWithPrincipalName in the epilog, but if not, setup a process with the necessary parameters and call it from the epilog.