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:

  1. Click the Create button. A Cube Administration window opens.
  2. 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.
  3. 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.
  4. 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.
  5. 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.
  6. 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.

  1. Click the Save button to save the IBM Alphablox cube.

To edit a IBM Alphablox cube:

  1. Select a cube name from the IBM Alphablox Cubes list box.
  2. Click the Edit button to edit the cube.
  3. Make your changes.
  4. 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:

  1. Select a cube name from the IBM Alphablox Cubes list box.
  2. Click the Delete button to delete the cube.
    The cube information is immediately deleted and cannot be recovered.

 

Related Topics: