Export (0) Print
Expand All

Ytd

SQL Server 2000

Ytd

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

Syntax

Ytd([«Member»])

Remarks

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

Ytd(«Member») is equivalent to PeriodsToDate(Year, «Member»).

Example

The following example returns the set of members from the beginning of the year from the ancestor of Time.CurrentMember through Time.CurrentMember:

Ytd()
 

See Also

PeriodsToDate

Show:
© 2014 Microsoft