dtDatesYtd (MDX+)

Returns a set of members from the first day of the year TO the member parameter.

Parameters

Return

set

Description

This functions returns a set of members from the first day of the year TO the member parameter.

dtWfd( [Time].[Calendar].[Day].[6 Jun 2006] ) it will return all days from the start of the year, 1 January 2006, to the 6th June.

If the compactSet parameter is set to true, default, the set is compacted.

See Also

CompactSet Ytd dtNextWeek dtNextMonth dtNextQuarter dtNextYear dtPreviousDay dtPreviousWeek dtPreviousMonth dtPreviousQuarter dtPreviousYear dtPlusDays dtPlusWeeks dtPlusMonths dtPlusQuarters dtPlusYears dtMinusDays dtMinusWeeks dtMinusMonths dtMinusQuarters dtMinusYears dtFirstDayOfWeekOfMonth dtFirstDayOfWeekOfQuarter dtFirstDayOfWeekOfYear dtLastDayOfWeekOfMonth dtLastDayOfWeekOfQuarter dtLastDayOfWeekOfYear dtNthDayOfWeekOfMonth dtNthDayOfWeekOfQuarter dtNthDayOfWeekOfYear dtDatesWeek dtDatesWeekend dtDatesWorkweek dtDatesWtd dtDatesMtd dtDatesQtd dtDatesYtd dtDatesItd dtDatesWfd dtDatesMfd dtDatesQfd dtDatesYfd dtWithDayOfWeek dtWithDayOfMonth dtWithDayOfYear dtWithMonthOfYear dtWithYear dtWithTime

Examples

dtDatesYtd([Calendar].[Day].[4 Jan 2016])

{ 
  [Calendar].[Calendar].[Day].&[2016-01-01], 
  [Calendar].[Calendar].[Day].&[2016-01-02], 
  [Calendar].[Calendar].[Day].&[2016-01-03], 
  [Calendar].[Calendar].[Day].&[2016-01-04]
}

[Calendar].[Day].[1 Jan 2016]:[Calendar].[Day].[4 Jan 2016]

dtDatesYtd([Calendar].[2016] )

{}

{[Calendar].[2016]}

dtDatesYtd([Calendar].defaultmember )

{}

dtDatesYtd(NULL)

{}

Special Examples (errors, null, ...)

dtDatesYtd([Geography].[Geo].[Paris])

Error Code    : OLAP_LEVEL_DATETIME_KEYTYPE_EXPECTED
Error Message : dtDatesYtd() : The level ('[Geography].[Geo].[City]') is expected with a date or date time key type (got :'[STRING]')

Since Version

6.0

XMLA Properties

Find here the value of the XMLA properties when not specified otherwise.