Tm1 Restapi: get components for the given Parent

Post Reply
kavitha2002
Posts: 94
Joined: Sat May 05, 2018 11:48 am
OLAP Product: tm1
Version: 10.3.10100.8
Excel Version: 14

Tm1 Restapi: get components for the given Parent

Post by kavitha2002 » Tue Aug 21, 2018 8:36 am

{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?

kavitha2002
Posts: 94
Joined: Sat May 05, 2018 11:48 am
OLAP Product: tm1
Version: 10.3.10100.8
Excel Version: 14

Re: Tm1 Restapi: get components for the given Parent

Post by kavitha2002 » Fri Aug 31, 2018 3:15 pm

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!

Post Reply