Essbase Member Properties for Dimension Builds

When building an Essbase dimension build file, 99% of the time, I will build it using a Parent / Child relationship.  I feel its the easiest to maintain and shared members are added automatically.  Here's a simple example for the Scenario dimension:

Scenario|Actual|+|
Scenario|Budget|~|
Scenario|Forecast|~|
Scenario|Revised Forecast|~|

In case you were wondering what the + and ~ mean or need more properties, here's a good list for you:

Essbase Member Properties for Aggregate Storage Database

% Set consolidation to express as a percentage of current total.
* Set consolidation to multiply by the current total
+ Set consolidation to add to the current total

- Set consolidation to subtract from the current total
/ Set consolidation to divide by the current total
~ Set to no consolidation
A Set to Time Balance Average (applies to accounts dimensions).
E Assign expense reporting tag (applies to accounts dimensions).
F Set to Time Balance First (applies to accounts to dimensions).
L Set to Time Balance Last (applies to accounts dimensions).
M Exclude data values of #MISSING from the time balance
N Set data storage to Never Share
O Set data storage to Label Only (store no data)
C Set member as top of a stored hierarchy (applies to dimension member of generation 2 member)
D Set member as top of a dynamic hierarchy (applies to dimension member of generation 2 member)
H Set member as top of a multiple hierarchies (applies to dimension member of generation 2 member)


Essbase Member Properties for Block Storage Database

% Set consolidation to express as a percentage of current total.
* Set consolidation to multiply by the current total
+ Set consolidation to add to the current total
- Set consolidation to subtract from the current total
/ Set consolidation to divide by the current total
~ Set to no consolidation
^ Set to no aggregation
A Set to Time Balance Average (applies to accounts dimensions).
B Exclude data values of zero or #MISSING in time balance
E Assign expense reporting tag (applies to accounts dimensions).
F Set to Time Balance First (applies to accounts to dimensions).
L Set to Time Balance Last (applies to accounts dimensions).
M Exclude data values of #MISSING from the time balance
N Set data storage to Never Share
O Set data storage to Label Only (store no data)
S Set data storage to Store (non-Dynamic Calc and not label)
T Assign two-pass calculation (applies to accounts dimensions).
V Set data storage to Dynamic Calc and Store (BSO databases only)
X Set data storage to Dynamic Calc (BSO databases only)