The tool supports the interface of Foresight Foresight Analytics Platform 9 or earlier.
The Cube Dimension Structure page is used to set connection to database containing system repository tables that are intended to store data of automatic cubes. The list of dimensions included into the multidimensional cube structure is also defined on this page.
Select a database in the drop-down list of all repository objects.
IMPORTANT. Correct creation of an express report based on automatic cube requires that a MDM repository is created in the database.
To add cube dimensions:
Click the Add button.
Select the Add Dimension context menu item.
To delete the selected dictionary:
Click the Delete button.
Select the Delete Dimension context menu item.
Remember that dimension order is very important when creating a list of cube dimensions, as it affects displaying data in reports. The order also affects data saving. To reorder dimensions:
Use the Move Up and Move Down buttons.
Use the Move Dimension Up and Move Dimension Down context menu items.
A confirmation of data transformation is required on changing dimension order.
When selecting the Go To Object item in the dimension's context menu, the focus in the object navigator moves to the selected dimension.
See also: