Dimensions

The component Dimensions provides several options for editing dimensions. The shortcut menu contains the following commands (alternatively you can use the corresponding buttons on the toolbar):


	New Dimension...	Choose this command to open the Create New Dimension dialog box.
	Import Dimension...	Use this command to open the Import Dimension dialog box and to import dimensions from other databases or an ASCII file.
	Refresh Dimensions	Use this command to update your dimension list in the Administration Console.

In the right pane of the Administration Console the following commands for editing dimensions are accessible by using the shortcut menu or the toolbar:


	Display Dimension...	Use this command to display the Dimension Browser.
	Edit Hierarchies...	Use this command to open the Edit Hierarchies dialog box. See The Hierarchies Dialog
	Delete Dimension	Deletes a dimension from the database.
	Save Dimension	Saves the dimension in the database.
	Clear Dimension from Memory	Use this command to remove the dimension from memory.
	Import Dimension...	Use this command to open the Import Dimension dialog box and to import dimensions from other databases or an ASCII file.
	Export Dimension...	Use this command to open the Export Dimension dialog box.
	Attribute Tables...	Use this command to open the Attribute Table dialog box.
	Edit Subsets...	Use this command to to display the Edit Subsets dialog box that allows creating, displaying and deleting of subsets.
	Properties	The Properties dialog box provides the following functions: General tab: In the Display options section you can select the Flat view and Inverted hierarchy. In the Access control section you can create a Dimension Access Control cube (DAC) in the Access control section by clicking the New Cube button and/or adjust the access control in the Cube list. Extended tab: In the XMLA settings section you can select the Dimension type from the drop-down list. Click the Edit Extended Properties button to enter additional information on dimensions. The Extended Properties dialog box opens where you can enter and use information in XML format. Note: If you want to delete a setting using this dialog, you must delete only the attribute of an element and not the whole element. Example: To delete the Default Member in the example, delete Name="Sales" only. <Alea:Properties xmlns:Alea="http://www.misag.com"> <Alea:DefaultMember Name="Sales"/> <Alea:ODBOType Code="2"/> </Alea:Properties>

System Dimensions


Dimension	Description	Remark
#__DIM__	A list of the dimensions in the server.
#__GRP__	A list of the repository roles.	The name is derived from "group" (for historical reasons).
#__TAB__	A list of the cubes	Cubes are commonly referred to as tables.