PEL member functions

  • Article

The following links provide detailed reference information about the PerformancePoint Expression Language (PEL) functions that return a member or member set.

Note

PEL cannot be used to reference user-created member views in non-time dimensions. To write a business rule that references a member view in a non-time dimension, use a native Multidimensional Expressions (MDX) implementation.

Reference

  • Ancestor (PEL)
    Returns the ancestor of a specified member at the destination distance or level.
  • ClosingPeriod (PEL)
    Returns the last sibling among the descendants of a member at a specified level.
  • Cousin (PEL)
    Returns the member that has the same relative position under uncle-member as member has under ancestor-member.
  • CurrentMember (PEL)
    Returns the current member along a specified dimension or hierarchy during iteration.
  • DataMember (PEL)
    Returns the system-generated data member that is associated with a nonleaf member of a dimension.
  • FirstSibling (PEL)
    Returns the first child of its parent. The first child of a parent is its own first sibling.
  • Lag (PEL)
    Returns the member that is index number of members before member along the same level.
  • LastSibling (PEL)
    Returns the last child of its parent. The last child of a parent is its own last sibling.
  • Lead (PEL)
    Returns the member that is index number of members after member along the same level.
  • OpeningPeriod (PEL)
    Returns the first sibling among the descendants of a specified level, optionally at a specified member.
  • ParallelPeriod (PEL)
    Returns a member from a prior period in the same relative position as a specified member.
  • Parent (PEL)
    Returns the parent of a member, if it has one.
  • PrevMember (PEL)
    Returns the previous member along the level implied by the member.

See Also

Other Resources

Multidimensional Expressions (MDX) Reference on MSDN