The Facts Page: Standard Cube

Facts describe the data, which is seen by the user on building a cube. For example, it may be a set of some factual and standard values by any indicators, or it may be the values obtained in calculation by set formulas.

Cube dimensions determine coordinate axes in the cube, while facts represent various values at each point of the obtained coordinate system. These are the values that are seen and edited by the user.

Fact dimension can be created manually or can be based on the existing repository dictionary.

To use the existing dictionary as a cube fact dimension:

In the web application:

Go to the Select Dictionary tab.
Select the dictionary in the drop-down list with available fact sources.

In the desktop application:

Select the Use Existing Dictionary radio button.
Select the repository dictionary in the drop-down list. If a parametric dictionary is selected, the Determine Parameter Values dialog box opens, in which set parameter values. When values are determined, the selected dictionary is opened and its elements are used as cube facts. To change values of dictionary parameters, click the Parameter Values button.

A warning message is displayed if the list of cube facts is previously locally specified.

To create a local fact dimension:

Use local fact dimension:

Select the Determine Facts Locally tab in the web application.
Select the Define List of Facts and Their Hierarchy Locally for Cube radio button in the desktop application.

Add elements using the Add Element/ Add Element buttons in the web application or the Add Element/Add Subelement buttons in the desktop application.

To rename the selected fact:

In the web application:

Select the Rename item in the drop-down menu of the Actions button.
Double-click the fact

In the desktop application click the Rename button.

To delete the selected fact:

In the web application select the Delete item in the drop-down menu of the Actions button.
In the desktop application click the Delete button.

To delete all facts:

In the web application click the Delete All button
In the desktop application select the fact and select the Delete All Elements item in the drop-down menu of the Delete button.

To move the selected fact one position up:

In the web application click the Up button
In the desktop application click the Up button.

To move the selected fact one position down:

In the web application click the Down button
In the desktop application click the Down button.

To hide fact dimensions during cube creation, select the Hide Fact Dimension in Reports checkbox. The actual values will be displayed or edited by the first fact.

NOTE. The setting is relevant if the fact dimension contains only one element.