dtGetWeekOfYear (MDX+)

Returns the week of the year of the member parameter

Parameters

Return

numeric-value

Description

This functions returns the week of the year (ISO8601).

In the standard ISO8601 week algorithm, the first week of the year is that in which at least 4 days are in the year.
As a result of this definition, day 1 of the first week may be in the previous year's week.

See Also

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

dtGetWeekOfYear( [Calendar].[Day].[15 Jan 2016])

2

dtGetWeekOfYear( [Calendar].[Day].[22 Jun 2016])

25

Special Examples (errors, null, ...)

dtGetWeekOfYear( NULL)

NULL

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

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

Since Version

6.2

XMLA Properties

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