Tm1 Rest api: get number of levels in Dimension

[kavitha2002]

Hi Everyone,

How to get to know the number of levels in Dimension and filter the dimension elements using Level using Tm1 REST api?

Is there any option to do??

[Wim Gielis]

For instance:

Code: Select all

{{protocol}}://{{serverName}}:{{httpPortNumber}}/api/v1/Dimensions('TEST_DIM')/Hierarchies?$select=Name&$expand=Levels/$count

[kavitha2002]

Super Wim Gielis.. Thanks for your immediate response.

Is there a way to filter the Dimension elements based on the level. For example,

{TM1FILTERBYLEVEL( {TM1SUBSETALL( [DimName] )}, 1)} in mdx do we have similar in RESTapi?

[kavitha2002]

I have found the solution to filter the dimension elements by level, hope the below Tm1 REST api query may help someone.

Code: Select all

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