Using Private Dimensions

To show or hide data source name in table, use the Structure and Parameters dialog box.

Click the Structure and Parameters button on the Data ribbon tab. Use the dialog box tab to select or deselect checkboxes next to the data sources, which names must be shown or hidden. As a result, data source names are shown or hidden in the table.

For details see the Setting Up Data Source Structure article.

To move selected private dimension to fixed dimensions:

1. Click the Settings button.

2. In the button drop-down menu select In the Fixed Privates.

The dimension will be fixed. The Fixed Private Dimensions tab used to work with the dimension is displayed. Work with this tab is the same as with the Private Dimensions tab.

NOTE. If aggregation option is not selected, after the dimension is fixed, only one dimension element selection is available.

To work with fixed private dimensions, go to the Fixed Private Dimensions tab.

To move selected fixed private dimension to private dimensions:

1. Click the Settings button.

2. In the button drop-down menu select In Privates.

The dimension will be unfixed. To work with free private dimensions, use the Private Dimensions tab.

Composite dimension is a dimension consisting of the elements selected in private dimensions.

To create a composite dimension on the Private Dimension or Fixed Private Dimension side panel tab, select the As a Composite Dictionary checkbox.

The Private Dimensions tab appearance before transformation:

Private dimensions as one composite dimension:

A composite dimension is a tree consisting of selected elements of private dimensions. Selection changing, searching and sorting are available for composite dimension.

To delete a composite dimension, deselect the As a Composite Dictionary checkbox.

The list of private dimensions is displayed on the Private Dimensions or Fixed Private Dimensions side panel tab.

A private dimension can be created on the basis of shared dimension.

NOTE. This option is available if data sources contain a number of shared dimensions.

To create a private dimension on the basis of the shared dimension:

1. Click the ( By Columns, By Rows, or Fixed) at the left of the dimension name.

2. In the button's drop-down menu select the To Private Dimensions item.

The selected dimension is converted into a private one and moved to the Private Dimensions tab.

A private dimension can be moved to shared. To do this:

1. Click the Settings button.

2. In the button's drop-down menu select To Shared Dimensions item.

The selected dimension will be converted to shared and moved to a single tab.

When a private dimension is moved to shared, it is kept in the same position ( By Columns, By Rows, or Fixed), in which private dimensions are located.

Generalization is excluding a shared dimension from private dimensions.

NOTE. This option is available if a shared dimension was converted into a private one.

To generalize dimensions:

1. Click the button ( By Columns, By Rows, or Fixed) at the left of the Private Dimensions tab name.

2. In the button's drop-down menu select To Shared Dimensions item.

The dialog box with a list of the dimensions, which can be converted to shared ones, opens. For example:

Select the checkbox next to the dimension that should be moved and click the OK button.

To set layout order of private dimensions:

• Drag the selected private dimension to the required position using Drag&Drop mechanism.

• Use items of the Settings menu of the private dimension: Up, Down or Swap Places With.