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