Deploying Cube Views database schema on the Windows® platform

The Cube Views™ metadata is stored in the Schema Generator output folder. This output folder is defined by the user through the WebSphere® Business Monitor administrative console.

To deploy the Cube Views™ metadata file, complete the following steps:
  1. Start the DB2® OLAP Center. The DB2 database connection dialog box appears.
  2. In the DB2 database connection dialog box, do the following:
    1. In the Database name field, type the name of the Historical database.
    2. In the User name field, type the user ID of a user who has administrative rights to the database.
    3. In the Password field, type the password of a user who has administrative rights to the database.
    4. Click OK.
    5. The first time you connect to the database, a message may inform you that the database needs to be configured for Cube Views. Click Yes on the message to start the initialization and configuration.
  3. In the OLAP Center window, import the Cube Views metadata file as follows:
    1. From the menu, select OLAP Center > Import. The Import wizard starts.
    2. Select the Cube Views XML file, which is stored in the Schema Generator output folder. The name of the file is model_cv.xml.
    3. Click Finish. The import process starts.
  4. After import is completed, on the Import Options page of the Import Wizard window, click Finish.
Related concepts
Database artifacts deployment
Business Measures Model deployment scenarios
Artifacts generation and deployment
Cube views definitions
Related tasks
Creating and configuring databases
Deploying data movement services
Creating dynamic database tables
Deploying Cube Views database schema on the AIX platform
Creating ABX cubes manually

Copyright IBM Corporation 2005. All Rights Reserved.