SetProperty (MDX+)
Sets the property for a measure
Parameters
| |
measure |
one |
|
| |
string |
one |
|
| |
numeric-expression |
one |
|
Return
member
Description
Sets the property for a measure defined by the second parameter using the third parameter:
[Measure].[Amount].setProperty("fx",true) // set the 'fx' property to true for the [Amount] measure
The setProperty function returns the measure member so it can be chained.
This function is mainly used in a script definition using the 'ic3run expr' statement:
ic3run expr [Measures].[Amount].setProperty("fx",true);
note that the 'ic3run expr' statement must finish by a semi-colon character (;).
See Also
GetProperty
Examples
Defines the property defined by the key and value.
Query
WITH
MEMBER [Measures].[Fx Prop] AS [Measures].[Amount].setProperty("fx",true).getProperty("fx")
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]
Defines the property defined by the key and value.
Query
WITH
MEMBER [Measures].[Fx Prop] AS [Measures].[Amount].setProperty("fx",1.5).getProperty("fx")
SELECT
[Measures].[Fx Prop] ON 0
FROM
[Sales]
Result
Assertion : MDX Equals
WITH
MEMBER [Measures].[Fx Prop] AS 1.5
SELECT
[Measures].[Fx Prop] ON 0
FROM
[Sales]
Defines the property defined by the key and value.
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]
Since Version
6.8.3
XMLA Properties
Find here the value of the XMLA properties when not specified otherwise.