"=" in Essbase calculation

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博客 ” ，链接：http://blog.itpub.net/8583032/viewspace-715193/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/8583032/viewspace-715193/