Consolidate Formula Assistant

The assistant is used to create a new Consolidate Formula.

Assistant Window

1. Workspace

First, a workspace must be selected. If the assistant is called in the workspace manager, this step will be skipped. Since the workspace has already been selected in the workspace manager.

2. Table

Each consolidation refers to a database table.

3. Dimension

A formula is bound to a dimension.

4. Formula

Formula of the dimension, that should be used.

5. Fields

Value fields that should be used for the consolidation.

6. Filter

Filter that are to be connected with the consolidation. The filters of the workspace are displayed.

7. Properties

Finally, the properties are specified. The name must be unique within the workspace and must not contain a space or a special characters. Valid characters are: A..Z, a..z, 0..9 and _.

Category, info and color are additional fields, which are used in the workspace manager to help the user.

After Finish

After finish the Consolidate Formula is visible in then workspace.