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


table of contents

Mtd

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 the Month level in the Time dimension.

Syntax

Mtd([«Member»])

Remarks

The Mtd function is a shortcut function to the PeriodsToDate function that defines that function's «Level» argument to be Month. If no member is specified, the default is Time.CurrentMember.

Mtd(«Member») is equivalent to PeriodsToDate(Month, «Member»).

Example

The following example returns a set of members that represent the first five days of September, 1997:

MTD([05-Sep-1997])