LastLevel (MDX+)

Returns the last level of a hierarchy

Parameters

Name	Type	Cardinality	Default value
	hierarchy-expression	one

Return

level

Description

Returns the last level of the hierarchy.

It is a shortcut for : 'Hierarchy'.levels( count('Hierarchy'.levels()) -1 )

Examples

LastLevel(hierarchy)

Returns the last level of the hierarchy.

In our example, [Geo].[City] as it's the last level of [Geo] hierarchy

Query

LastLevel([Geography].[Geo])

Result

{ 
  [Geography].[Geo].[City].[Quebec], 
  [Geography].[Geo].[City].[Toronto], 
  [Geography].[Geo].[City].[Mexico], 
  [Geography].[Geo].[City].[Los Angeles], 
  [Geography].[Geo].[City].[New York], 
  [Geography].[Geo].[City].[San Francisco], 
  [Geography].[Geo].[City].[Caracas], 
  [Geography].[Geo].[City].[Paris], 
  [Geography].[Geo].[City].[Barcelona], 
  [Geography].[Geo].[City].[Madrid], 
  [Geography].[Geo].[City].[Valencia], 
  [Geography].[Geo].[City].[Geneva], 
  [Geography].[Geo].[City].[Lausanne], 
  [Geography].[Geo].[City].[Zurich]
}

Assertion : MDX Equals

[Geography].[Geo].[City]

Assertion : MDX Equals

[Geography].[Geo].levels( count([Geography].[Geo].levels()) -1 )

Assertion : Cell Equals

[Geography].[Geo].lastLevel()

Special Examples (errors, null, ...)

LastLevel(NULL)

XMLA Properties

Find here the value of the XMLA properties when not specified otherwise.