periodsToDate

Returns a set of sibling members from the same level as "member", as constrained by "level". It locates the ancestor of "member" at "level" and returns that ancestor's descendants at the same level as "member" (up to and including "member"). Typically used with a time dimension. This function appears in the Rolling and Moving Averages interactive sample report.

Syntax

periodsToDate ( level , member )

Example

periodsToDate ( [great_outdoors_company].[Years].[Years].[Year] ,
 [2004/Mar] )

Result

Returns values for [2004/Jan], [2004/Feb], [2004/Mar]