Open the Dimension Value Combinations window.

Displays when you select a matrix cell with Limited in the Dimension Combination window, right-click, and then select DrillDown to see the underlying dimension values. In this window, you can determine which dimension values within the Limited dimension combination should be blocked from use. This can be useful when a dimension combination is used and you want to limit which value combinations are allowed when using these two dimensions. For example, you can choose that the Sales Office and Area dimensions can be combined on entries only when the sales office selected as a dimension value is physically located in the area specified as the Area dimension value.

Option Description

Show Column Name

Select to view columns by the descriptive names that you have given dimension values in stead of using their codes.

Dimension Combinations Matrix FastTab

Option Description

Code

This column shows the code for the dimension value on the line.

Name

This column shows the name of the dimension value on the line.

Dimension Values

The dimension values that are displayed in the rows on the left side of the matrix are also represented as dimension value columns.

You can restrict how dimensions values can be combined by clicking in the matrix cell and selecting one of the following options:

Option Description

Open

The dimension value combination is always allowed.

Blocked

The dimension value combination is not possible.

For more information about dimensions, see Dimension.

Tip

See Also