Page 1 of 1

Tm1 Restapi: get components for the given Parent

Posted: Tue Aug 21, 2018 8:36 am
by kavitha2002
{DRILLDOWNLEVEL( {[DimName].[Element]})} -- this gives the immediate components for the given Parent

How can I use the same in TM1 Rest Api - as MDX query. Is it possible?

Re: Tm1 Restapi: get components for the given Parent

Posted: Fri Aug 31, 2018 3:15 pm
by kavitha2002
I found the solution

http://host:8001/api/v1/Dimensions('DimName ')/Hierarchies('DimName')?$expand=Elements($select=Name,Attributes,Type;$expand=Components($select=Name,Type);$expand=Parents($select=Name,Type);$filter=Name eq 'elementName')

This is what i expected.. this will return only the components for the given element.

Hope this may help someone!