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)

 
0
Kudos
 
0
Kudos