Create offline cube files (.cub) with OlapCube. Download Now!


table of contents

PeriodsToDate

Returns a set of sibling members from the same level as a given member, starting with the first sibling and ending with the given member, as constrained by a specified level in the Time dimension.

Syntax

PeriodsToDate([«Level»[, «Member»]])

Remarks

Within the scope of «Level», this function returns the set of periods on the level of «Member», starting with the first period and ending with «Member». If no level or member is specified, the «Member» value is Time.CurrentMember and «Level» is the parent level of Time.CurrentMember. If a level is specified, «Member» is dimension.CurrentMember, where dimension is the dimension of «Level».

Example

The following table lists the different ways you can use PeriodsToDate.

Expression Returns
PeriodsToDate(Quarter, 
[05-Sep-1997])
The set of members that represent the days from the beginning of the third quarter of 1997.
PeriodsToDate(Year, March) 
The set {January, February, March}.
PeriodsToDate(Year)
The set of members from the beginning of the year that is the ancestor of Time.CurrentMember, through Time.CurrentMember.
PeriodsToDate()
The set of members from the beginning of the level containing the period of Time.CurrentMember to Time.CurrentMember. All the returned members are at the same level as Time.CurrentMember.

PeriodsToDate(level, member) is the same as TopCount(Descendants(Ancestor(member, level), member.Level), 1):member