Hi All,
I am trying to export a particular Dimensions' subset members with hierarchy (Parent) via API Call.
I can call it nicely with below:
https://xxx. planning-analytics.ibmcloud.com/tm1/api/tm1/api/v1/Dimensions('gbl.Entities')/Hierarchies('gbl.Entities')/Members?$select=Name,Ordinal,Weight&$expand=Parent($select=Name),Level($select=Number),Element($select=Name,Type,Attributes)"
However, I need to pull a specific Dimension "Subset" and therefore I use below API call:
https://xxx. planning-analytics.ibmcloud.com/tm1/api/tm1/api/v1/Dimensions('gbl.Entities')/Hierarchies('gbl.Entities')/Subsets('Subset1')/Elements"
Unfortunately, this does not return the information about the "Parent
I tried to replace the suffix of "Elements" in above query with "/Members" but it comes up with
"message": "'Members' resource can not be resolved on type 'Subset'."
Can anyone help me with API call method that returns Dimensions's subset with its members & parents?
Thank you in advance.
Exporting Dimension subset member list with parent via API
-
- MVP
- Posts: 2836
- Joined: Tue Feb 16, 2010 2:39 pm
- OLAP Product: TM1, Palo
- Version: Beginning of time thru 10.2
- Excel Version: 2003-2007-2010-2013
- Location: Atlanta, GA
- Contact:
Re: Exporting Dimension subset member list with parent via API
I have zero experience with the new REST API but I think maybe you don't understand what a subset is. A subset is merely a collection of dimension elements. It is not a hierarchy. There is no concept of child or parent in a subset. That only exists in a dimension hierarchy.
-
- Posts: 9
- Joined: Mon Mar 30, 2020 10:06 am
- OLAP Product: Not sure
- Version: 2.0.49
- Excel Version: 1
Re: Exporting Dimension subset member list with parent via API
Thanks Tomok.
I confirmed that the "Parent" information is simply not available in the dimension subset API (it would have been easier if it were for us).
I confirmed that the "subset" that I want to export is actually part of the main dimension views.
And I can link between the result from Dimension subset with full Dimension result via "@odata.etag" ID field.
Thanks for the clarification.
I confirmed that the "Parent" information is simply not available in the dimension subset API (it would have been easier if it were for us).
I confirmed that the "subset" that I want to export is actually part of the main dimension views.
And I can link between the result from Dimension subset with full Dimension result via "@odata.etag" ID field.
Thanks for the clarification.