Introduction | Information Center
Defining, editing, and deleting IBM
Alphablox cubes
Use the Cube Administration page to
define a IBM Alphablox cube that is accessible by IBM Alphablox Cube Server.
To define the general
properties of a IBM Alphablox cube:
- Click the Create button. A Cube
Administration window opens.
- In the IBM Alphablox Cube Name text box, type a
unique name for the IBM Alphablox cube. Allowable characters for Alphablox
cube names are A-Z, a-z, 0-9, underscore (_), dash (-), space, percent, at
@, single quote, parenthesis ( or ) and period. However, you cannot use a period as the
final character in an Alphablox cube name.
- Select the Enabled check box to the right of the
IBM Alphablox Cube Name text box if you want the cube to start
automatically whenever the server restarts. If you are working on the cube
definition and do not expect it to run properly or you do not want to give
others access to it yet, you can leave the checkbox unchecked and enable
the cube later.
- Using the Relational Data Source list, select a
relational data source you have previously defined. If IBM Alphablox
relational data sources have not been defined, the list is blank.
- Using the Security
Role list, you can pick a role (predefined in the
application server or in IBM Alphablox) that can restrict users of this
cube to the selected role. To enable the use of the selected security
role, the Enabled
check box must be checked.
- Optionally, if you are using IBM DB2 as a data
source and have DB2 Cube Views cubes available on this data source, the Enable
DB2 Cube Views Settings option will become available. By selecting
this option, you can use the available cube definitions in DB2 Cube Views
to specify your IBM Alphablox cube. To use this option, perform the
following sub-steps:
a.
Using
the Cube Model menu, select a cube model.
b.
Using
the Cube menu, select a cube.
c.
Selecting
either the Use Business Names or Use Object Names radio button to
specify the names to be used to define objects in your IBM Alphablox cube.>.
d.
Click
the Import Cube Definition button to import a cube definition and
pre-populate measures and dimensions in your IBM Alphablox cube. Depending on
the cube definition imported, IBM Alphablox Cube Server attempts to specify a
IBM Alphablox cube that closely matches the one in DB2 Cube Views. Click on the
Show Import Log button to see a log specifying information and debugging
messages related to the import operation.
e.
At
this point, you can edit the imported cube measures and dimensions (as
described below) to customize your cube, or you can optionally check the Import
cube definition (on start, rebuild, and edit) option. Selecting this option
will result in your IBM Alphablox cube loading the latest DB2 Cube Views cube
definition each time your IBM Alphablox cube is started, rebuilt, or opened for
edit.
- Click the Save button to save the IBM Alphablox
cube.
To edit a IBM Alphablox
cube:
- Select a cube name from the IBM Alphablox Cubes
list box.
- Click the Edit button to edit the cube.
- Make your changes.
- Click the Save button.
Warning: Any changes made to a loaded IBM Alphablox cube do
not take effect until the cube is either restarted or rebuilt.
To delete an Alphablox
cube:
- Select a cube name from the IBM Alphablox Cubes
list box.
- Click the Delete button to delete the cube.
The cube information is immediately deleted and cannot be recovered.
Related Topics: