Essbase dimension consolidation codes
For the next time I forget them and spend an age looking:
ASO:
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)
K
Reset the time balance property to NONE (applies to accounts dimensions only).
N
Never allow data sharing
O
Tag as label only
P
Reset the time balance skip option to NONE (applies to accounts dimensions only).
BSO:
A
Treat as an time balance average item (applies to accounts dimensions only)
B
Exclude data values of zero or #MISSING in the time balance (applies to accounts dimensions only)
E
Treat as an expense item (applies to accounts dimensions only)
F
Treat as a time balance first item (applies to accounts dimensions only)
G
Reset two-pass calculation to false (applies to accounts dimensions only). Also see property code T in this table.
J
Reset expense item to false (applies to accounts dimensions only). Also see property code E in this table.
K
Reset the time balance property to NONE (applies to accounts dimensions only). Also see property codes A, F, and L in this table.
L
Treat as a time balance last item (applies to accounts dimensions only)
M
Exclude data values of #MISSING from the time balance (applies to accounts dimensions only)
N
Never allow data sharing
O
Tag as label only (store no data)
P
Reset the time balance skip option to NONE (applies to accounts dimensions only). Also see property codes B, M and Z in this table.
S
Set member as stored member (non-Dynamic Calc and not label only)
T
Require a two-pass calculation (applies to accounts dimensions only)
X
Create as Dynamic Calc
Z
Exclude data values of zero from the time balance (applies to accounts dimensions only)