Returns the property as a string. Note that property names are not case sensitive.
In our example, returns the name of the member.
Query
WITH
MEMBER [Measures].[PARIS_NAME] AS [Geography].[Geo].[Paris].Properties('MEMBER_NAME')
SELECT
[Measures].[PARIS_NAME] On 0
FROM
[Sales]
Result
Assertion : MDX Equals
WITH
MEMBER [Measures].[PARIS_NAME] AS "Paris"
SELECT
[Measures].[PARIS_NAME] On 0
FROM
[Sales]
Assertion : MDX Equals
WITH
MEMBER [Measures].[PARIS_NAME] AS [Geography].[Geo].[Paris].getProperty('MEMBER_NAME')
SELECT
[Measures].[PARIS_NAME] On 0
FROM
[Sales]
Returns the 'typed' version of the property.
In our example, the level number as an integer value.
Query
WITH
MEMBER [Measures].[INT_VALUE] AS [Geography].[Geo].[Paris].Properties( "Level_Number", TYPED)
MEMBER [Measures].[STR_VALUE] AS [Geography].[Geo].[Paris].Properties( "Level_Number" )
SELECT
{[Measures].[INT_VALUE],[Measures].[STR_VALUE]} ON 0
FROM
[Sales]
Result
Assertion : MDX Equals
WITH
MEMBER [Measures].[INT_VALUE] AS 3
MEMBER [Measures].[STR_VALUE] AS "3"
SELECT
{ [Measures].[INT_VALUE], [Measures].[STR_VALUE] } ON 0
FROM
[Sales]
Returns an error if the property does not exist.
Query
WITH
MEMBER [Measures].[isError] AS isError( [Geography].[Geo].[Paris].Properties( "MISSING PROPERTY" ) )
SELECT
{ [Measures].[isError] } ON 0
FROM
[Sales]
Result
Assertion : MDX Equals
WITH
MEMBER [Measures].[isError] AS TRUE
SELECT
{ [Measures].[isError] } ON 0
FROM
[Sales]
Returns an empty string if the property is NULL.
Query
WITH
MEMBER [Measures].[IsEmptyString] AS "" = ( [Geography].[Geo].[Paris].Properties( "CUSTOM_ROLLUP" ) )
SELECT
{[Measures].[IsEmptyString]} ON 0
FROM
[Sales]
Result
Assertion : MDX Equals
WITH
MEMBER [Measures].[IsEmptyString] AS TRUE
SELECT
{ [Measures].[IsEmptyString] } ON 0
FROM
[Sales]
Returns NULL if the property is NULL and the 'TYPED' option is used.
Query
WITH
MEMBER [Measures].[isEmpty] AS isEmpty( [Geography].[Geo].[Paris].Properties( "CUSTOM_ROLLUP", TYPED) )
SELECT
{[Measures].[isEmpty]} ON 0
FROM
[Sales]
Result
Assertion : MDX Equals
WITH
MEMBER [Measures].[isEmpty] AS TRUE
SELECT
{ [Measures].[isEmpty] } ON 0
FROM
[Sales]