Syntax support by provider
This table displays the writeback syntax support by provider:
Syntax | Description | MS AS 2005/2008 | MS AS 2012 | Infor PM OLAP ODBO (see Note) | Infor OLAP XMLA |
---|---|---|---|---|---|
#W | Weighted allocation | Yes | Yes | Yes | Yes |
#E | Equal allocation | Yes | Yes | Yes | Yes |
&W | Weighted. Increasing or decreasing by an absolute value | Yes | Yes | Yes | Yes |
&E | Equal increase or decrease by an absolute value | Yes | Yes | Yes | No |
&W...% | Increasing or decreasing by a percentage | Yes | Yes | Yes | Yes |
#B | Overwrite value of all base elements | Yes | Yes | Yes | Yes |
&B | Add value to all base elements | Yes | Yes | No | No |
#D | Overwrite data elements | Yes | No | No | |
&D | Add data elements | Yes | No | No | |
#COPY | Copy values from elsewhere | No | No | Yes | Yes |
© | Add copy values from elsewhere | No | No | No | Yes |
#COPYFULL | As #COPY but also copies values calculated by rules | No | No | Yes | Yes |
©FULL | As © but also copies values calculated by rules | No | No | No | Yes |
#LIKE | Splash a new value with the same weighting as a value elsewhere | No | No | Yes | Yes |
&LIKE | Add a value and splash it with the same weighting as elsewhere | No | No | No | Yes |
#LIKEFULL | As #COPYFULL but with the addition of a Value parameter | No | No | Yes | Yes |
&LIKEFULL | As ©FULL but with the addition of a Value parameter | No | No | No | Yes |
...?... | Reallocation | Yes | Yes | Yes |
Note: Version 10.3.x does not
contain an ODBO provider. But ODBO connections from 10.3.x to OLAP 10.1.x are supported.