Exporting Dimension subset member list with parent via API
Posted: Wed Apr 22, 2020 7:29 am
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.
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.