Essbase ASO Valid Consolidation Properties for Members
A quick cheat sheet of valid consolidation properties for Essbase ASO applications.
| Code | Description |
|---|---|
| % | Express as a percentage of the current total in a consolidation (applies only to members of a dynamic hierarchy) |
| * | Multiply by the current total in a consolidation (applies only to members of a dynamic hierarchy) |
| + | Add to the current total in a consolidation (applies only to members of a dynamic hierarchy) |
| - | Subtract from the current total in a consolidation (applies only to members of a dynamic hierarchy) |
| / | Divide by the current total in a consolidation (applies only to members of a dynamic hierarchy) |
| ~ | Exclude from the consolidation (applies only to members of a dynamic hierarchy or members beneath Label Only members in a stored hierarchy) |
| O | Tag as label only |
| N | Never allow data sharing |
| C | Set member as top of a stored hierarchy (applies to dimension member or generation 2 member) |
| D | Set member as top of a dynamic hierarchy (applies to dimension member or generation 2 member) |
| H | Set dimension member as multiple hierarchies enabled (applies to dimension member only) |