Page 1 of 1

Exporting Dimension subset member list with parent via API

Posted: Wed Apr 22, 2020 7:29 am
by jimmyn
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.

Re: Exporting Dimension subset member list with parent via API

Posted: Wed Apr 22, 2020 12:33 pm
by tomok
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.

Re: Exporting Dimension subset member list with parent via API

Posted: Thu Apr 23, 2020 7:44 am
by jimmyn
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.