WriteProperty
Writes value to dimension property.
Writes or deletes an OLAP specific property only (the attribute value)
Syntax
«Member» WriteProperty(«Member», «Dimension property», «Value»)
This table describes the parameters:
| Parameters | Description |
|---|---|
Member: «Member»
|
Element |
DimensionProperty: «dimensionproperty»
|
OLAP specific dimension property |
Value: «NumericExpression»|«String
Expression»|«DateTime Expression»|«Bool Expression»|«Null»
|
If Value is null, the element's property is deleted. |
| Return value: | «Member», this function returns Member. |
Example 1
SELECT FROM [TOTSALES] WHERE WriteProperty([ProView VGA 12], [PRODUCTS].[Level 3].[ATT1_PRODMAN], "Hello World")For dynamic attributes, the WHERE clause is required to
specify the driver dimension elements. If the WHERE clause is not
specified, the default driver dimension element is used.
Example 2
SELECT WriteProperty([Regions].[USA], [Regions].[Numeric], 123) ON
ROWS, {} ON COLUMNS
FROM [Totsales]
WHERE ([Years].[2016])