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 button or select the Add Dimension context menu item.
To delete an added dictionary, select it in the list and click the button or 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 change the dimension order, use the and buttons or select the Move Dimension Up or Move Dimension Down context menu items. A confirmation of data transformation is required on changing dimension order.
On 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: