Data Connections

In the Data Connections view, you specify how values are transferred from a detail cube to a central cube and how values are transferred within a cube.

To set the parameters of data connections, click Data Connections in the System node of the tree.

In the Cube drop-down list you select for which cube the settings are displayed. Select Source View to display data connections where the selected cube is used as source and Target View for data connections where it is used as target.

If you select the source view, the column Target Cube is displayed. In the target view, the column Source Cube is displayed. You edit the contents of the table in the Transfer Editor that opens when you click the New or Edit button or double-click one of the cells.

In the Transfer Editor you select the source and the target cubes of the data connection on the Source and Target tab. The dimensions of the selected cube are displayed. Dimensions that are not contained in both cubes are highlighted in red. Right-click a dimension in the source cube to select all elements of the dimension (only dimensions marked with an asterisk '*'), or a single element, or a subset of the dimension. Use the shortcut menu command Subsets > Create Subset to create a subset for the selected dimension in the Subset Wizard without switching to the tree view. Right-click a dimension in the target cube to select the same elements as in the source cube or to select a single element.

Rules may also be defined for data connections. On the Properties tab, select Infor EPM OLAP Server Rule or Event Agent Rule (Push Rule). If you create an Event Agent Rule, you can lock the target area in order to prevent inconsistencies in the database, if wrong entries are made in the target element.

If you select the Execute further calculations automatically check box, you can create a chain of multiple Event Agent Rules. If the target area of an Event Agent Rule is identical with the source area of another Event Agent Rule, the second Event Agent Rule is triggered by the first one. If you clear the Execute further calculations automatically check box, only the first Event Agent Rule is executed.

If you select the Allow loop in target area check box, you can specify an aggregated element as target area of an Event Agent Rule. The source value is then written to all child elements.

Select the check box Calculate online to specify that the values are calculated online immediately after each input. Clear the check box Calculate online to calculate the values off-line as batch process. Select the check box Clear target area before calculation to specify that the target area is deleted before the calculation.

On the Rule tab, you create the calculation rule. The default rule is: Target.Value = Source.Value. To edit the rule, click Formula Wizard. In the Formula Wizard you select the data cube from which the data will be retrieved. A Source.Value expression is created with the selected elements. Click the Check Syntax button after you have created the rule to check it. When you click Save the syntax is also checked.