Cubes

The Cubes component enables the administration and modification of cubes. The shortcut menu contains three commands (alternatively you can use the corresponding buttons on the toolbar):

	New Cube...	Opens the New Cube on Server 'Name' dialog.
	Import Cube...	Use this command to open the Import Cube dialog box and to import cubes from other databases or an ASCII file.
	Refresh Cubes	Choose this command to update your cube list.

The right pane of the Administration Console displays all cubes contained in the current database. The shortcut menu of a cube and the toolbar present the following commands and buttons:

	Edit Cube Description...	Opens the Edit Cube dialog where you can edit the cube description.
	Delete Cube	Removes a cube from the list.
	Save Cube	Saves a cube in the database. Only loaded cubes can be saved.
	Clear Cube from Memory	Removes a cube from the local memory.
	Import Cube...	Opens the Import Cube dialog.
	Export Cube...	Opens the Export Cube dialog.
	Import Cube Rules...	Opens the Import Cube Rules dialog.
	Export Cube Rules...	Opens the Export Cube Rules dialog.
	Edit Cube Rules...	Click this command to open the Cube Rules dialog box.
	Edit Data Areas...	Opens the Edit Data Areas dialog.
	Properties	Opens the Properties dialog that presents the following information and options: The General tab displays information on the cube and the most recent user. Click the Edit Extended Properties button to enter additional information on the cube. The Extended Properties dialog allows you to enter and use information in XML format (see Extended Properties). The Dimensions tab displays a list of the cube dimensions and provides a list to select the Measure dimension. If no Measure dimension is selected from the dropdown list, the Implicitly defined measure dimension is displayed beneath. The Data Areas tab shows the available data areas. The Access Permissions tab provides the possibility to control the access permissions via the TABACC cube and to create and activate a cube for multidimensional access control. The assignment of data access permissions to a multidimensional cube (Multi-DAC, MDAC) is to be performed in Infor BI Office Plus. For more details on the Multi-DAC refer to the online help of Infor BI Office Plus. The Security tab allows you to enable the Transaction log to recover the initial state of the cube in the case of unwanted changes.

There is also a cube that controls access to cubes. It is called #_TABACC, for table access control.