« Detail of Member Lists   |   Importing and Exporting Members »

Dimension Borrowing

Designer Administrator
This manual is in pilot operation.

There may be cases where multiple dimensions with exactly the same content are needed. For example, in consolidated accounting, it’s necessary to understand transaction volume data between group companies, separated by each company and the corresponding partner company. In fusion_place, in such cases, it’s necessary to have separate dimensions for "Company Dimension" and "Partner Company Dimension".

However, the content of these two dimensions should be the same. Therefore, it is desirable that when the content of the Company Dimension is modified, the modification is automatically reflected in the Partner Company Dimension.

The mechanism for this is "Dimension Borrowing".

When a designer creates a new Partner Company Dimension, by specifying the Company Dimension as the "Dimension to borrow from", the content of the Company Dimension will be directly reflected in the content of the Partner Company Dimension.

⚠ Please note that "Dimension Borrowing" is only applicable to General Dimensions both as the source and the destination of borrowing.

Dimension Borrowing and Member Lists

When borrowing a dimension, attention must be paid to how Member Criteria Expressions are written in Member Lists.

Consider the case where the “Company/ENTITY” dimension is borrowed to create the “Partner Company/PARTNER”. Suppose there is a following expression in the Member List definition of the Company Dimension:

  Dimensions!ENTITY!@CUR

This specifies the "current member" related to the Company Dimension. Evaluating this Member List definition in the Company Dimension would indicate each target member by this expression.

However, when evaluating this Member List definition in the Partner Company Dimension, since the "current member" for the Company Dimension would be empty, the intended result is not achieved. To avoid such a problem, the above expression should be changed to:

  Dimensions!@CUR!@CUR

By writing it this way, “Dimensions!@CUR” refers to the Company Dimension when the Member List definition is evaluated in the Company Dimension, and it refers to the Partner Company Dimension when evaluated in the Partner Company Dimension, thus avoiding the problem described above.

This applies not only when using the @CUR function but also generally when specifying the current dimension in a Member Criteria Expression.