Cubing Services administration workflow

This topic outlines a typical workflow for managing your OLAP and cubing activities.

Figure 1 shows the a typical Cubing Services workflow.

Figure 1. Administration workflow for Cubing Services
A typical workflow for administering your OLAP and cubing activities can include the following tasks:
  1. Create a data source, which defines a database connection. For more information, refer to http://publib.boulder.ibm.com/infocenter/db2luw/v9r5/topic/com.ibm.help.etl.doc/administering/tadmcreatedsn.html.
  2. Import OLAP metadata. To use cube models that are defined in DB2® or from a partner tool, you can import OLAP metadata into DB2 databases. For more information, refer to Importing OLAP metadata.
  3. Optimize your cube model to improve the performance of your OLAP-style SQL query. For more information, refer to Optimizing a cube model.
  4. Configure a cube server. For more information, refer to Creating a cube server.
  5. Add a cube or cubes to a cube server. For more information, refer to Adding cubes to a cube server in a single step.
  6. Start the cube server. For more information, refer to Starting, stopping, or restarting cube servers.
Parent topic: Managing OLAP and cubing administration tasks

Feedback | Information roadmap