Formulas Table

Select a formulas table located in the current repository in the drop-down list, or create a new formulas table.

To create a formulas table, click the Create button. In the dialog box that opens determine formulas table properties: name and identifier. Clicking the OK button automatically creates a table with predefined structure. The table will be saved in the directory with the current multidimensional calculation.

To edit the formulas table, click the Edit button. A table creation or editing wizard opens afterwards.

To check if the selected table satisfied the required conditions, click the Check button.

After the check is finished, an appropriate message appears.

To recreate the specified table, click the Recreate button.

Note that the table cannot always be recreated, because this command enables only to add new fields but it does not remove the unused ones. In most cases it is recommended to create a new formulas table or edit the existing one using an appropriate wizard, which is displayed by clicking the Edit button.

If cube factors values must be calculated for different calculation periods using different formulas, select the Formulas Depend on Time checkbox before creating a formulas table.