Set Up the InfoSphere Warehouse Cubing Services Sample

Before you begin

Before you set up the InfoSphere® Warehouse Cubing Services samples, you must restore the DB2® sample database.

Procedure

  1. On the computer where IBM® Cognos® software is installed, go to the db2 directory located in c10_location/webcontent/samples/datasources/cubes/CubingServices/. Select the language of your choice.
  2. If required, copy the csgodw.xml file to your working directory.
  3. In IBM InfoSphere Warehouse Design Studio, import the csgodw.xml metadata file into a data model based on the DB2 GS_DW schema.
  4. Deploy the CSGODW cube to the DB2 GS_DW schema.
  5. Use the IBM InfoSphere Warehouse Administration Console to add the new cube to a cube server, and run it.

    Note the XMLA port number for the cube, as this number is required for the data source connection.

Results

You can now create the data source connections in the IBM Cognos Connection portal.
Parent topic: Setting up the samples