External data source cube wizard

The wizard is intended for creating the cube structure.

If you select the Manual creation method, clicking Finish creates a cube that does not yet have dimensions, resources, and dimension tables (hereafter these parameters are referred as fields). You can add the fields and the cube description in the external data source cube editor.

If you select the Select from external data source cube list creation method, the cube structure creation will consist of several steps. This requires access to the external data source.

On the next step (click Next >), the connection form is opened. In this form, you can connect to the external data source.

Once you establish the connection, you will see the list of external data source cubes.

In the list, in the Name in the data source column, select the check boxes for the cubes and fields that you want included in the description of the external data source.

If any cubes were previously created for this data source, the check boxes next to them are already selected. To exclude cubes or fields, clear the check boxes next to them.

In the Name in the configuration column, you can specify the external data source cube or field name that will be used for registering it in the configuration.

In the Type column, specify the data type. For fields, you can specify links to external data source cubes.

In the Presentation field column, select the check boxes for the fields that you want included in the cube field list.

In the Comment column, you can enter a comment for the cube or field.

If you select the Remove objects not available in the external data source from the configuration check box, once you complete the wizard, the cubes and fields that are absent from the external source (for example, those that were deleted from the external data source) will be removed from the configuration.

All changes are marked with bold font.

To complete the wizard, click Finish. The cubes and fields will be added (or removed) to or from the external data source description. To edit cube and field descriptions, use the external data source cube editor window.