I may be missing something, but there does not appear to be a subset editor functionality for a dimension/hierarchy within Workspace IF the dimension does not belong to a cube.
Is that correct and subsets for these dimensions must be created either through a TI or through the subset editor in Architect?
Creating subsets in Workspace
- PavoGa
- MVP
- Posts: 616
- 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
Creating subsets in Workspace
Ty
Cleveland, TN
Cleveland, TN
-
- MVP
- Posts: 3105
- 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: Creating subsets in Workspace
Or, put the dimension in a temporary cube and afterwards you throw away the cube.
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
- macsir
- MVP
- Posts: 782
- Joined: Wed May 30, 2012 6:50 am
- OLAP Product: TM1
- Version: PAL 2.0.9
- Excel Version: Office 365
- Contact:
Re: Creating subsets in Workspace
Even worse, even if a dimension belongs to a cube, but if you drag the dimension only into the workspace, you still can't open subset editor from there. I guess the purpose of this is to encourage you to utilize hierarchy rather than subset in the future. Am I right?
-
- MVP
- Posts: 3651
- Joined: Fri Mar 13, 2009 11:14 am
- OLAP Product: TableManager1
- Version: PA 2.0.x
- Excel Version: Office 365
- Location: Switzerland
Re: Creating subsets in Workspace
It's not just if the dimension belongs to a cube but also the dimension must have attributes. (Until either 2.0.3 or 2.0.4 the rest API didn't support a MDX member set query only data query so the subset editor was actually driven by queries to the ElementAttributes cube).PavoGa wrote: ↑Thu Sep 06, 2018 4:16 pm I may be missing something, but there does not appear to be a subset editor functionality for a dimension/hierarchy within Workspace IF the dimension does not belong to a cube.
Is that correct and subsets for these dimensions must be created either through a TI or through the subset editor in Architect?
That you can't have a subset editor without a cube is down to the way they built workspace as it is centered around the idea of a canvas with slices of data. It kind of makes sense as in Workspace you can't actually do anything with a subset that isn't used in a view. You can however drag a filter to a separate area and link it to multiple views.
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.
-
- MVP
- Posts: 3651
- Joined: Fri Mar 13, 2009 11:14 am
- OLAP Product: TableManager1
- Version: PA 2.0.x
- Excel Version: Office 365
- Location: Switzerland
Re: Creating subsets in Workspace
I think maybe you are getting confused in the terminology. Basically hierarchies are what dimensions were. And subsets now belong to hierarchies not dimensions. You can see this too if you drill down on a dimension in Workspace you see that each hierarchy has its own levels and its own subsets.macsir wrote: ↑Thu Sep 06, 2018 9:57 pm Even worse, even if a dimension belongs to a cube, but if you drag the dimension only into the workspace, you still can't open subset editor from there. I guess the purpose of this is to encourage you to utilize hierarchy rather than subset in the future. Am I right?
Subsets are still central, they just belong to hierarchies now.
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.
- PavoGa
- MVP
- Posts: 616
- 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: Creating subsets in Workspace
Thanks all.
This was related to a dimension being used as a picklist and I was wanting to control some items through an MDX subset. For example, a picklist that contracts as elements are assigned in a mapping cube.
Thanks again for the responses.
This was related to a dimension being used as a picklist and I was wanting to control some items through an MDX subset. For example, a picklist that contracts as elements are assigned in a mapping cube.
Thanks again for the responses.
Ty
Cleveland, TN
Cleveland, TN
- macsir
- MVP
- Posts: 782
- Joined: Wed May 30, 2012 6:50 am
- OLAP Product: TM1
- Version: PAL 2.0.9
- Excel Version: Office 365
- Contact:
Re: Creating subsets in Workspace
Yes, you are right. Thanks.lotsaram wrote: ↑Fri Sep 07, 2018 8:16 amI think maybe you are getting confused in the terminology. Basically hierarchies are what dimensions were. And subsets now belong to hierarchies not dimensions. You can see this too if you drill down on a dimension in Workspace you see that each hierarchy has its own levels and its own subsets.macsir wrote: ↑Thu Sep 06, 2018 9:57 pm Even worse, even if a dimension belongs to a cube, but if you drag the dimension only into the workspace, you still can't open subset editor from there. I guess the purpose of this is to encourage you to utilize hierarchy rather than subset in the future. Am I right?
Subsets are still central, they just belong to hierarchies now.