Business Cube Editor window
This dialog appears when you do either of the following:
- Right-click the Business Cubes node, select Add Business Cube from the shortcut menu, input a name in the displayed dialog and click OK, then in the Add Data dialog, add one resource to use in the business cube and click OK, or add more than one resource and click OK, and then select the columns in the added resources to use in the business cube and click OK in the Query Editor window.
- 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.
- Hierarchy
Prompts you to provide a name for a new hierarchy and then adds a hierarchy into the business cube resource tree. The name should be unique among the hierarchies in a business cube.
Tools
Help
- Business Cube Help
Displays the help document about this feature.
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.
Insert Hierarchy
Prompts you to provide a name for a new hierarchy and then adds a hierarchy into the business cube resource tree. The name should be unique among the hierarchies in a 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.
Join Editor
Opens the Query Editor window to edit 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, 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 business 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:
