WriteProperty
Writes or deletes an OLAP specific property (that is, an attribute value).
Syntax
«Member1» WriteProperty(«Member2», «Dimension Property», «Numeric Expression» | «String Expression» | «DateTime Expression» | «Bool Expression» | Null)This table describes the parameters:
| Parameters | Description |
|---|---|
«Member1» |
This function returns the target dimension element. |
«Member2»
|
Dimension element to which the attribute value is written. |
«Dimension Property»
|
The attribute to which the value is written. |
«Numeric Expression» | «String Expression» | «DateTime
Expression» | «Bool Expression» | Null |
If Null, the attribute value is deleted. |
Example with a dimension attribute
SELECT FROM [DCS_Planning] WHERE WriteProperty([AS600/175], [PRODUCT].[Size].[ATT1_AProduct], "Dimension attribute text")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 with a dynamic attribute
SELECT
WriteProperty([AS600/175], [PRODUCT].[Regional Product Manager], "J. Miller") ON COLUMNS,
{} ON ROWS
FROM [ANALYSIS]
WHERE ([2005], [Africa])