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:

Select the Use Existing Dictionary radio button.
Select a repository dictionary in the drop-down list.
If the dictionary that contains parameters is selected, the Determine Parameter Values dialog box opens, where required values should be defined. 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 use local fact dimension, select the Define List of Facts and Their Hierarchy Locally for Cube checkbox.

To add elements or subelements, click the Add Element and Add Subelement buttons.

To rename the selected fact, click the Rename button.

To delete the selected fact, click the Delete button.

To change the order of the selected fact in a list, use the Move Up or Move Down buttons or the Drag&Drop method.

To hide the fact dimension on creating a cube, select the Hide Fact Dimension in Reports checkbox. The factual values will be displayed or edited by the first fact.

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