fbpx

dtDatesWtd (MDX+)

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

Parameters

Name Type Cardinality Default value
  member-expression  one   
compactSet  boolean  zero-one  false 

Return

set

Description

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

dtWfd( [Time].[Calendar].[Day].[6 Jun 2006] ) as the 6th is a Tuesday it will return Monday and Tuesday members

If the compactSet parameter is set to true the set is compacted (most probably without any effect as the natural parent of a day it's the month)

See Also

CompactSet dtAsOf dtAsOfToday dtNextDay 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

Special Examples (errors, null, ...)

Since Version

6.0

XMLA Properties

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