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 ?
Query on SwapAliasWithPrincipalName
-
- MVP
- Posts: 3128
- 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: Query on SwapAliasWithPrincipalName
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.
It’s done for the entire dimension.
For elements outside the subset, use the same element name in the alias.
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
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
- PavoGa
- MVP
- Posts: 618
- Joined: Thu Apr 18, 2013 6:59 pm
- OLAP Product: TM1
- Version: 10.2.2 FP7, PA2.0.9.1
- Excel Version: 2013 PAW
- Location: Charleston, Tennessee
Re: Query on SwapAliasWithPrincipalName
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.
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.
Ty
Cleveland, TN
Cleveland, TN