Link Formula Details

Specifies the linked model name.

A model is available to be a linked model if:

• The currency conversion setting (enabled or disabled) for the linked model is the same as for the current model.
• The Date dimension in the linked model has the same granularity as the Date dimension in the current model, or both models have no date dimension at all.
• Fiscal Year is either disabled in both dimensions, or enabled with the same month shift.

Specifies the linked model account member.

A member can be linked if:

• It doesn't contain a formula.
• It is part of the same account type group as the member that contains the Link formula. INC and LEQ use automatic sign switching, and are one account group, while EXP, AST, and NFIN are the other group.
• It has the same aggregation type as the member that contains the Link formula.

The point of view is a list of filters, concatenated by the "and" operator, containing selected dimensions and their members. The point of view is used to further restrict data in the linked account member.

Each POV filter contains a dimension name followed by a string list. A string list is either a single string, or a comma-separated list of strings in parentheses.

For this parameter, the all keyword is available to select all members in the dimension.

Dimensions appear in the suggestion list, divided into three groups:

• Missing Dimensions

  These dimensions exist only in the linked model. You can select none, one, many, or all members of each dimension, multiple dimensions, or even all missing dimensions.

• Matching Dimensions

  These dimensions exist in both the linked model and current model. You have the same selection options as you have with missing dimensions.

• Additional Dimensions

  These dimensions exist only in the current model. If there are any additional dimensions, it is mandatory to specify them in a point of view, and you must select exactly one member of each of the additional dimensions.