Report Cube Editor window

This window appears when you right-click the Report Cube node and then select Add Report Cube from the shortcut menu, or right-click a report cube and click Edit Report Cube on its shortcut menu in the Catalog Browser. It helps you to edit a report cube. See the window.

The following are details about options in the window:

File

• Save
  Saves the report cube 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 report cube.
• Dimension
  Opens the Add Cube Element dialog to insert a dimension object to the report cube.
• Measure
  Opens the Add Cube Element dialog to insert a measure object to the report cube.
• Detail
  Opens the Add Cube Element dialog to insert a detail information object to the report cube.
• Hierarchy
  Prompts you to provide a name for a new hierarchy and then adds a hierarchy into the report cube resource tree. The name should be unique among the hierarchies in a report cube.

Tools

• Security Configuration
  Opens the Edit Report Cube Security dialog to configure security for all the report cubes in the data source.
• Predefined Filter
  Opens the Predefined Filter dialog to add predefined filters for the report cube.

Help

• Report Cube Help
  Displays this help document.

Toolbar

• Save
  Saves the report cube and apply all the changes made in this window.
• Delete
  Deletes the specified table, view, formula or summary from the report cube.
• Insert Category
  Inserts a new folder into the report cube.
• Insert Dimension
  Inserts a dimension object to the report cube.
• Insert Measure
  Inserts a measure object to the report cube.
• Insert Detail
  Inserts a detail information object to the report cube.
• Insert Hierarchy
  Prompts you to provide a name for a new hierarchy and then adds a hierarchy into the report cube resource tree. The name should be unique among the hierarchies in a report cube.
• Predefined Filter
  Adds some predefined filters for the report cube. Ad hoc end users can choose to apply those filters when designing/modifying reports based on the report 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 report cube.

Report Cube

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

For how to add and edit elements in a report cube, see Adding/Editing elements.

For how to add hierarchies, see Defining hierarchies.

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

To adjust the order of an element or a hierarchy, select it and click or on the toolbar. For an element, you can also make use of the Move Up and Move Down options on the shortcut menu.

To delete an element or a hierarchy, first select it, then click on the toolbar or use the Delete option on the shortcut menu. For an element, you can also drag it to the left panel to remove it. The root category cannot be removed.

Related topics:

• Editing a business/report cube