Exporting Dimension subset member list with parent via API

Post Reply
jimmyn
Posts: 9
Joined: Mon Mar 30, 2020 10:06 am
OLAP Product: Not sure
Version: 2.0.49
Excel Version: 1

Exporting Dimension subset member list with parent via API

Post 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.
tomok
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

Post 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.
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/
jimmyn
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

Post 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.
Post Reply