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].GetProperty('MEMBER_NAME')
SELECT
[Measures].[PARIS_NAME] On 0
FROM
[Sales]
Result
Assertion : MDX Equals
WITH
MEMBER [Measures].[PARIS_NAME] AS [Geography].[Geo].[Paris].Properties('MEMBER_NAME')
SELECT
[Measures].[PARIS_NAME] On 0
FROM
[Sales]
Returns null as the property does not exist.
Query
WITH
MEMBER [Measures].[PARIS_NAME] AS [Geography].[Geo].[Paris].GetProperty('MISSING')
SELECT
[Measures].[PARIS_NAME] On 0
FROM
[Sales]
Result
Assertion : MDX Equals
WITH
MEMBER [Measures].[PARIS_NAME] AS NULL
SELECT
[Measures].[PARIS_NAME] On 0
FROM
[Sales]
Returns the property defined by the key (string).
In our case, we set the property to retrieve it just afterwards
Query
WITH
MEMBER [Measures].[Fx Prop] AS [Measures].[Amount].setProperty("fx",true).getProperty("fx",TYPED)
SELECT
[Measures].[Fx Prop] ON 0
FROM
[Sales]
Result
Assertion : MDX Equals
WITH
MEMBER [Measures].[Fx Prop] AS true
SELECT
[Measures].[Fx Prop] ON 0
FROM
[Sales]
Returns the property defined by the key (string).
In our case, we set the property to retrieve it just afterwards
Query
WITH
MEMBER [Measures].[Fx Prop] AS [Measures].[Amount].setProperty("fx",3.14).getProperty("fx",TYPED)
SELECT
[Measures].[Fx Prop] ON 0
FROM
[Sales]
Result
Assertion : MDX Equals
WITH
MEMBER [Measures].[Fx Prop] AS 3.14
SELECT
[Measures].[Fx Prop] ON 0
FROM
[Sales]
Returns the property defined by the key (string).
In our case, we set the property to retrieve it just afterwards
Query
WITH
MEMBER [Measures].[Fx Prop] AS [Measures].[Amount].setProperty("fx","Got it !").getProperty("fx")
SELECT
[Measures].[Fx Prop] ON 0
FROM
[Sales]
Result
Assertion : MDX Equals
WITH
MEMBER [Measures].[Fx Prop] AS "Got it !"
SELECT
[Measures].[Fx Prop] ON 0
FROM
[Sales]
Returns null if the property defined by the key is not found.
Query
WITH
MEMBER [Measures].[Fx Prop] AS [Measures].[Amount].setProperty("fx","Got it !").getProperty("missing")
SELECT
[Measures].[Fx Prop] ON 0
FROM
[Sales]
Result
Assertion : MDX Equals
WITH
MEMBER [Measures].[Fx Prop] AS NULL
SELECT
[Measures].[Fx Prop] ON 0
FROM
[Sales]