{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?
Tm1 Restapi: get components for the given Parent
-
- Community Contributor
- Posts: 180
- Joined: Sat May 05, 2018 11:48 am
- OLAP Product: tm1
- Version: 10.3.10100.8
- Excel Version: 14
-
- Community Contributor
- Posts: 180
- 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
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!
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!