Business Cube Editor window

This window appears when you right-click the Business Cubes node, select Add Business Cube from the shortcut menu, input a name in the displayed dialog and click OK, or right-click a business cube and click Edit Business Cube on its shortcut menu in the Catalog Browser. It helps you to create or edit a business cube. See the window.

The following are details about options in the window:

File

• Save
  Saves the business cube and applies all the changes made in this window.
• Save As
  Saves the business cube as another name and applies all the changes made in this window.
• Close
  Exits this window.

Insert

• Category
  Opens the Category Property dialog to insert a new folder into the business cube.
• Dimension
  Opens the Add Cube Element dialog to insert a dimension object to the business cube.
• Measure
  Opens the Add Cube Element dialog to insert a measure object to the business cube.
• Detail
  Opens the Add Cube Element dialog to insert a detail information object to the business cube.

Tools

• Filter
  Opens the Filter dialog to set a built-in filter for the business cube.
• Hierarchy Management
  Opens the Hierarchy Editor dialog to edit hierarchies for the business cube.
• Join Editor
  Opens the Business Cube - Join Editor window to edit joins for the business cube.
• Security Configuration
  Opens the Security Configuration dialog to configure security for the business cube.
• Predefined Filter
  Opens the Predefined Filter dialog to add some predefined filters for the business cube.

Help

Displays this help document.

Toolbar

• Save
  Saves the business cube and apply all the changes made in this window.
• Delete
  Deletes the specified table, view, formula or summary from the business cube.
• Insert Category
  Inserts a folder into the business cube.
• Insert Dimension
  Inserts a dimension object to the business cube.
• Insert Measure
  Inserts a measure object to the business cube.
• Insert Detail
  Inserts a detail information object to the business cube.
• Filter
  Specifies a built-in filter for the business cube. The built-in filter is transparent to the end users running reports based on the business cube. Each business cube can only have one built-in filter.
• Hierarchy Management
  Specifies hierarchies for the business cube.
• Join Editor
  Specifies joins for the business cube.
• Predefined Filter
  Adds some predefined filters for the business cube. Ad hoc end users can choose to apply those filters when designing/modifying reports based on the business cube.
• Move Up
  Moves the selected object one step up.
• Move Down
  Moves the selected object one step down.

Resource Objects

Lists all the resources that can be inserted into the business cube.

Business Cube

You can add or edit the resources of a business cube in this panel. The resources are arranged in a tree structure. Under the root category, both categories and cube elements can be added. Categories are used as virtual folders to hold sub categories and cube elements. Cube elements can only be added into categories.

For how to add elements into a business cube, see Adding elements.

To edit an element, first select it in the panel, then right-click and select Edit from the shortcut menu. In the displayed dialog, modify the setting as required.

To change the display name of an element, use the Rename option on its shortcut menu.

To adjust the order of an element, select the element, then click or on the toolbar, or make use of the Move Up and Move Down options on the shortcut menu.

To delete an element, first select it, then either drag it to the left panel, or click on the toolbar, or use the Delete option on the shortcut menu. The root category cannot be removed.

Related topics:

• Editing a business/report cube