Alternative Cube: Calculated cube

If required, on the Alternative Cube page one can set a cube, to which calculated data will be saved.

By default, the data calculated in a calculated cube is not saved to any destination. To save the data, specify an alternative cube.

In the drop-down list select the cube, to which calculated data will be saved.

To quickly select an object, enter object's name/identifier/key in the search box depending on display settings. Search is executed automatically while the searched text is entered into the search string. The list will display the objects, which names/identifiers/keys contain the entered text.

To set up displaying of repository objects, click the Show Object button and select display option in the drop-down menu:

Name. Objects are displayed with their names. Default option.
Identifier. Objects are displayed with their identifiers.
Key. Objects are displayed with their keys.

Several options can be selected. Identifier and key will be specified in brackets.

To reset selection for the selected objects, click the Clear button.

When selecting a cube, select one of the checkboxes that control data saving.

NOTE. Alternative cube structure must be fully identical to calculated cube structure: the order of dimensions and their keys must match, that is, the same dimensions must be used. One also needs to create a fact dimension as a separate dictionary and to add it to the cubes on the appropriate pages: for a calculated cube - use the Cubes Structure page and for alternative cubes - use the Facts page. Otherwise data saving may cause errors.

If the checkbox is selected, one can edit data in the calculated cube and save it to the alternative cube. If the checkbox is deselected, calculated cube data cannot be edited.

If the checkbox is selected, all data will be saved to the cube specified in the box above.

If the checkbox is selected, data foe calculation will be taken from source cubes. All other data is taken from the alternative source. Thus, cells with formulas display values while cells without formulas are empty (if the checkbox is deselected) or display data from alternative source (if the checkbox is selected).