Hi, I was wondering and failing to find answer online: Can you assign alias to subset?
I dont mean using aliases of the elements in subset, but giving the subset itself an alias.
I am asking because the application we are developing is gaining on size and complexity. I would love to use some sort of prefix in naming the subsets so that I and other colleagues working on the project could differentiate which subset belongs to which part of the project. Problem with that is that for the user the subset names would probably be too technical and confusing.
Thanks for the reply
Assigning alias to subsets?
-
- MVP
- Posts: 3113
- 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: Assigning alias to subsets?
Do you want 1 subset with 2 different names ?
Or using prefixes and make distinctions between anyone's subsets ? (hence more than 1 subset)
Or using prefixes and make distinctions between anyone's subsets ? (hence more than 1 subset)
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
-
- MVP
- Posts: 3652
- Joined: Fri Mar 13, 2009 11:14 am
- OLAP Product: TableManager1
- Version: PA 2.0.x
- Excel Version: Office 365
- Location: Switzerland
Re: Assigning alias to subsets?
I'm wondering how the system size and complexity impacts on subsets?vasek1192 wrote: ↑Tue Apr 05, 2022 8:54 am Hi, I was wondering and failing to find answer online: Can you assign alias to subset?
I dont mean using aliases of the elements in subset, but giving the subset itself an alias.
I am asking because the application we are developing is gaining on size and complexity. I would love to use some sort of prefix in naming the subsets so that I and other colleagues working on the project could differentiate which subset belongs to which part of the project. Problem with that is that for the user the subset names would probably be too technical and confusing.
- You can't refer to subsets in rules
- You most certainly shouldn't refer to subsets in TI processes
Subsets should really only be for assisting end users to navigate data and create views. So while naming can certainly always help organize things I'm still struggling to see why you woudl have such an overwhelming number of subsets that you need to implement a strict naming.
I'm not sure if aliases work for subsets but depending on the GUI used by users you can certainly create a }SubsetAttributes_Dimension cube using the TI function SubsetAttrInsert. So by creating a "Caption" attribute then you can control the display name for users even if the caption isn't an alias. (This would also let you have different display captions depending on the user's language locale).
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.
-
- Posts: 47
- Joined: Sun Jan 24, 2021 5:55 pm
- OLAP Product: IBM Planning analytics
- Version: 2.0.9.3
- Excel Version: 2019
Re: Assigning alias to subsets?
Yes I intended to have subset with two names (aliases).
It is not so much for organizational purposes as for user friendliness. We use prefixes in our subsets to indicate for what purpose the subset exists and for which cube, so there are subsets named: OO_AC_Sales_All_Leaves, OO_AC_Sales_Lev2_SORTED_ABC and so on. But the users use subsets in PAW to filter the cubes but usually dont know what leaves are, dont need to see the prefixes and arent native english speakers (some of our developers are). So there is a struggle between what is most convenient from developers point of view and what is most user friendly.
It is not so much for organizational purposes as for user friendliness. We use prefixes in our subsets to indicate for what purpose the subset exists and for which cube, so there are subsets named: OO_AC_Sales_All_Leaves, OO_AC_Sales_Lev2_SORTED_ABC and so on. But the users use subsets in PAW to filter the cubes but usually dont know what leaves are, dont need to see the prefixes and arent native english speakers (some of our developers are). So there is a struggle between what is most convenient from developers point of view and what is most user friendly.
- gtonkin
- MVP
- Posts: 1198
- Joined: Thu May 06, 2010 3:03 pm
- OLAP Product: TM1
- Version: Latest and greatest
- Excel Version: Office 365 64-bit
- Location: JHB, South Africa
- Contact:
Re: Assigning alias to subsets?
May be better to name the subsets etc. with a friendly, easy to understand name for users who use PAW and PAfE.
Use aliases, which are possibly not supported elsewhere, for the developers to tag with their convention.
Also remember that you typically cannot rename TM1 objects and assigning numbering often leads to a constraint e.g. you need something between 01 and 02. At least with an alias, developers could update these to align without the need for recreation of subsets/other objects.
Use aliases, which are possibly not supported elsewhere, for the developers to tag with their convention.
Also remember that you typically cannot rename TM1 objects and assigning numbering often leads to a constraint e.g. you need something between 01 and 02. At least with an alias, developers could update these to align without the need for recreation of subsets/other objects.
- PavoGa
- MVP
- Posts: 617
- 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: Assigning alias to subsets?
Create a subset with the naming convention you want. Then create a second subset named as desired with the following MDX:vasek1192 wrote: ↑Thu Apr 07, 2022 11:31 am Yes I intended to have subset with two names (aliases).
It is not so much for organizational purposes as for user friendliness. We use prefixes in our subsets to indicate for what purpose the subset exists and for which cube, so there are subsets named: OO_AC_Sales_All_Leaves, OO_AC_Sales_Lev2_SORTED_ABC and so on. But the users use subsets in PAW to filter the cubes but usually dont know what leaves are, dont need to see the prefixes and arent native english speakers (some of our developers are). So there is a struggle between what is most convenient from developers point of view and what is most user friendly.
Code: Select all
TM1SubsetToSet( [DimensionName], "FirstSubsetName")
Ty
Cleveland, TN
Cleveland, TN
- gtonkin
- MVP
- Posts: 1198
- Joined: Thu May 06, 2010 3:03 pm
- OLAP Product: TM1
- Version: Latest and greatest
- Excel Version: Office 365 64-bit
- Location: JHB, South Africa
- Contact:
Re: Assigning alias to subsets?
The issue will be that the list of subsets down in the data tree and in the set editor will show the principal/technical name. Users would want to see the friendly name when working in views/sets.
At least that is how I understood the OP’s issue.
At least that is how I understood the OP’s issue.
- PavoGa
- MVP
- Posts: 617
- 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: Assigning alias to subsets?
Yes, two subsets would not be optimal for sure. We have cube aliases and unfortunately the cubes are sorted by their technical name but display their "user-friendly" captions. Not a fan and have not figured out to get them to display in any other order, although admittedly have not spent any time on it.
Ty
Cleveland, TN
Cleveland, TN
-
- Posts: 47
- Joined: Sun Jan 24, 2021 5:55 pm
- OLAP Product: IBM Planning analytics
- Version: 2.0.9.3
- Excel Version: 2019
Re: Assigning alias to subsets?
Thanks for your replies