fbpx

PeriodsToDate (MDX)

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

Parameters

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

Return

set

Description

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

Examples

XMLA Properties

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