PeriodsToDate (MDX)

Returns the set of members starting from the first sibling of the specified member and ending with the specified member itself.


Name Type Cardinality Default value
  level-expression  zero-one   
  member-expression  zero-one   




This function returns a set starting at the first sibling, at specified level, and ending at the member itself.

The both parameters are optional:
1) If the member expression is missing, then the level-hierarchy.CurrentMember will be used.
2) If level-expression is missing, the parent level of the [Time].CurrentMember in the default time dimension of the cube will be used.

It is equivalent to { OpeningPeriod( member.level, Ancestor(member,level) ) : member }; note the range operator.

See Also

OpeningPeriod Ancestor


XMLA Properties

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