Dissecting a Formula in a Rule

Dissecting a Formula in a Rule

Setting up the RC line requires the use of MDX. In Planful, MDX is referred to as Rules. When a reference cube line is already defined and you click Mappings > Reference Cube, the MDX or rule for the line is shown on the Rule page as shown below.

The Formula Description displays the code/name/label of the selected dimension member (selected in the Dimension area).

The Formula displays the syntax along with the member key.

The beginning of the formula above is dissected below with a description of each section. Note that all tuples begin and end with parenthesis.

[Account].&[174]

Indicates that an account member is part of the formula. The member key is 174. That account is displayed under Dimension and represents the 4000-Revenue account.

[CalculatedDim].&[1]

Represents the Calculated dimension. The member key is 1, which is the Default member.

[Company].&[2257]

Represents the US Operations Company dimension member, which has a member key of 2257.