Export (0) Print
Expand All

Wtd

SQL Server 2000

Wtd

  Topic last updated -- July 2003

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

Syntax

Wtd([«Member»])

Remarks

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

Wtd(«Member») is equivalent to PeriodsToDate(Week, «Member»).

Example

The following example returns the days from the beginning of the week to the current day:

Wtd(Day)
 

See Also

PeriodsToDate

Show:
© 2014 Microsoft