dtWithMonthOfYear (MDX+)

Returns the member defined by the parameter month of the member date

Query

dtWithMonthOfYear([Calendar].[Day].[23 Jun 2016],2)

Result

{ 
  [Calendar].[Calendar].[Day].&[2016-02-23]
}

Assertion : MDX Equals

[Calendar].[Day].[23 Feb 2016]

Assertion : MDX Equals

[Calendar].[Day].[23 Jun 2016].dtWithMonthOfYear(2)

Returns the member defined by the parameter month of the member date

Query

dtWithMonthOfYear([Calendar].[Month].[2016 Jan],12)

Result

{ 
  [Calendar].[Calendar].[Month].&[2016-12-01]
}

Assertion : MDX Equals

[Calendar].[Month].[2016 Dec]

Returns NULL if the first parameter is NULL or an empty entity.

Query

dtWithMonthOfYear(NULL,2)

Result

NULL

Returns an error if the day of the month is out of bounds

Query

dtWithMonthOfYear([Calendar].[Day].[23 Feb 2016],13)

Result

Error Code    : OLAP_FUNCTION_ARGUMENT_ERROR
Error Message : dtWithMonthOfYear() : argument (1) error: 'The parameter should in the range [1,12], got : 13'

Returns an error if applied to a hierarchy level that is bigger than a month level

Query

dtWithMonthOfYear([Calendar].[Year].[2016],1)

Result

Error Code    : OLAP_LEVEL_DATETIME_EXPECTED_LEVEL_TYPE
Error Message : dtWithMonthOfYear() : The level ('[Calendar].[Calendar].[Year]') is expected to be of type 'MONTH' (got :'[DATE]')

Returns an error if applied to a hierarchy that is not a data time one.

Query

dtWithMonthOfYear([Geography].[Geo].[Paris],1)

Result

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