Hierarchy (PEL)

  • Article

This function determines the hierarchy that contains a specified member or level.

// Member expression syntax
Member_Expression.@Hierarchy 

// Level expression syntax 
Level_Expression.@Hierarchy

Parameters

  • Member_Expression
    A valid PerformancePoint Expression Language (PEL) expression that returns a member.
  • Level_Expression
    A valid PEL expression that returns a level.

Return Value

Depending on the syntax form of the function, this function returns the hierarchy that contains the specified member or level.

Remarks

The PEL compiler can generate SQL code for this function when the function is a part of an absolute reference. The compiler cannot generate SQL code when the function is a part of a relative reference.

Because Hierarchy is a PEL keyword, when you use this function you must precede the word Hierarchy with the at symbol (@), as in @Hierarchy.

See Also

Reference

SQL generation for PEL functions

Other Resources

PEL reference