A=1 ( A is account member)

all values for A is 1

A=B (both A and B are account member)

all values for A are equal to B

C=1 ( C is a sparse member )

all account member (bottom member?) values are 1 in all blocks including C

if C is a dense member, same result, but block is not created automatically

C=D ( both C and D are members in same sparse dimension)

all account member values for C are same as that for D

C=A

in all blocks including C, account member values are same as that of A

FIX(@relative(D,0))
C=A->D;

ENDFIX

in all blocks of C->d, d is child of D, all account members values are same as A->D

FIX(@RELATIVE(E,0))

C=E ( both C and E are members in different sparse dimensions)

ENDFIX

which mean account member values in C->e equal to C->E, where E is the parent of e1, e2, e3,etc

ITPub博客

"=" in Essbase calculation