In SAC, using the Data Export API, how do I export the dimension hierarchies?

[whl]

Hello everyone.

I have the Data Export working so I can export all the dimension members.   I'm using this endpoint:

/providers/{NamespaceID}/{ProviderID}/{DimensionName}Master | SAP Help Portal

I can get almost everything I need but I cannot see the hierarchies.  How do get those?  Is it from a different endpoint?  I looked through all the endpoints in the documentation it's not really obvious. I could try each in turn but I thought I'd ask before doing that.  

Thanks.

[whl]

From what I can tell, it's not possible.

[whl · Accepted solution]

Looking at the blog

SAP Analytics Cloud Export Data API Sample Scripts - SAP Community

Q2: When retrieving a dimension the column 'parent' (that is used by SAP Analytics Cloud for hierarchical data structures) is not returned, why is this?

A2: The hierarchy is part of an internal hierarchy extension and doesn't form part of the data retrieval and they don't form part of the API. There are no plans to change this.

One of the workaround is that we'll just have to create new dimension attributes and manually copy the hierarchy values into there so it becomes data and can be exported.  It's a bit of a pain.

[VivekD · Accepted solution]

@Matthew_Shaw Just curious as to why you are saying there are no plans to change this. From a master data standpoint, it's just another column. Not having the API support that seems quite odd and is limiting the use of the API quite significantly.

[Matthew_Shaw · Accepted solution]

Dear @VivekD, it will be worth asking your question again, in say 4 to 6 months time. There might be a chance our development team might be looking at this as an idea.