This page is used to specify the destination cube and, if required, to fix dimensions:
The Source Cubes tree list shows all source cubes added on the previous page together with their dimensions. The child elements of dimensions show links to tables fields and child elements of the Factors dimensions display cube factors.
The Destination Cube box is used to select the cube, to which the calculation must be written. When the destination cube (consumer) is selected, the following conditions must be satisfied:
Data sources and the consumer must have the same DBMS type.
If the sources and consumers are stored on the same server but in different schemas, the Use Login Credentials checkbox must be selected for their database.
If conditions are not satisfied, a message that it is impossible to use this cube as a destination is displayed.
When destination cube is selected, its dimensions are displayed in the tree list.
Date shift (the Shift function) can be set on creating a formula for calendar destination dimensions and dimensions linked to the Date table field. To do this, select the Enable Shift by Date (SHIFT) checkbox in the context menu of the selected dimension.
To set names used for displaying dictionary elements in multidimensional calculation formula editor, select the Name in Dimension context menu item and in the pop-up menu select the attribute, which value will be used to create element names.
To set names that are used to show dictionary elements in expressions of expression editor select the Name for Formulas context menu item, open the drop-down menu, and select the attribute, which value will be used to form names. To hide element names in expressions, select the Hide in Formulas item. To restore names, use the Show in Formulas item. The Name for Formulas item is displayed only for source dimensions.
To get selected dimension focused in the object navigator dialog box, select the Go to Object context menu item.
To disable summation by elements in source cubes, select the Disable Summation checkbox in the context menu. The checkbox is deselected by default (values can be summed).
NOTE. If a source cube has no free recursive dimensions, the checkbox is selected and dimmed. If this cube gets a free recursive dimension, the checkbox becomes deselected after refreshing the cube structure.
Click the Refresh Structure button to refresh the source cubes structure. The operation is required to update the Disable Summation checkbox state if fixed dimensions are changed.
Using the context menu, set up how cubes and dimensions are to be displayed:
Show Names. Only names are displayed in the tree.
Show Identifiers. Only identifiers are displayed in the tree.
Show Names and Identifiers. Only names and identifiers are displayed in the tree.
To go to the next page of the wizard, click the Next button.
This page is used to fix dimensions, which elements are not used in calculation formulas. Fixing enables the user to match dictionary elements.
NOTE. Fixed dimensions in the destination cube must be linked to dimensions in a source.
To fix dimensions:
Double-click the dimension. This operation is applied to source cube dimensions only.
Select the checkbox next to the Fix Dimension context menu item.
NOTE. The Factors dimensions cannot be fixed.
A dialog box opens for source cube dimensions. Select the required dictionary of the destination cube to establish a correspondence:
Dimension elements are mapped by index. The Destination Dimension list shows only the dimensions, which are not linked to other dimensions of the a source cube, for which dimension this dialog box is displayed.
There are several options to fix dictionaries:
Source cube dictionary and destination cube dictionary, which is compared to it, are fixed. Elements of the dictionary are not to be selected when creating calculation formulas and the calculation is performed for all destination dimension points.
A source cube dictionary is fixed, but a destination cube dictionary matched to it is not fixed. When creating a destination cube dictionary elements can be used, calculation is performed only for destination dimension points, for which a calculation formula is determined.
On selecting a fixed destination cube dimension, the destination cubes dimensions linked to them are to be highlighted, so that the dimension bindings are to be displayed.
To unfix dimension:
Double-click the dimension. This operation is applied to source cube dimensions only.
Deselect the checkbox next to the Fix Dimension context menu item.
See also: