Installing the IBM Cognos Samples

In this post we describe the installation of the Cognos Samples on an IBM Cognos BI and TM1 platform. 

We will describe how to get the following samples working:

  • The Go Sales and Great Outdoors databases for compatible and dynamic query mode.
  • The Go Sales Dynamic Cube samples (requires the previous step).
  • A selected number of TM1 samples.
  • A selected set of IBM Cognos PowerCube samples.
  • Sample packages and content for the above (requires the previous steps).

Prerequisites:

  • IBM Cognos Business Intelligence 10.2.1
  • IBM Cognos TM1 10.1
  • Microsoft SQL Server 2008 R2
  • A supported database system, in this case Microsoft SQL Server 2008 R2
  • The IBM BI Cognos Samples installation file bi_smps_10.2.1_mp_ml.tar.gz

All the above is running on a Windows 64bit environment.

1. Installing the Cognos Samples installation package

Note that the samples come in a separate installation file not included in the product installation file.

  • Once you have downloaded the samples file (bi_smps_10.2.1_mp_ml.tar.gz) place it on a machine from which the BI server has access to.
  • Unzipp the installation file twice (7Zip) and locate the installation file for your operation system. In this case “issetup.exe” found in the folder “winx64h”.

01 IBM Cogos 10.2.1 Samples Installation

  • Run the installation wizard and follow the screens.
  • When asked for the installation location enter the installation path of the Cognos installation, something like “C:\Program Files\ibm\cognos\c10_64”.

This will not really install anything, it will just put the samples material in your Cognos BI installation directory. You can check this by going to “\\installationpath\webcontent\samples”, so something like “C:\Program Files\ibm\cognos\c10_64\webcontent\samples”.

If you haven’t already done so, open IBM Cognos Configuration and start your BI server.

2. Restore Go Sales and Go Sales Data Warehouse databases

The most logical thing to do first is to restore the Go Sales and Go Sales Data Warehouse sample databases. These databases will serve as the source for the relational and ROLAP sample models and the Dynamic Cube samples. 

  • Navigate to the samples installation location, something like “C:\Program Files\ibm\cognos\c10_64\webcontent\samples”.
  • Open the “datasources” folder and open the “sqlserver” folder.
  • Locate the files “GOSALESDW.zip” and “GOSALES.zip” and unzip them.

IBM Cogos 10.2.1 Samples SQL Server Datasources GO SALES

Make sure that you can reach these files from your database server, or copy them to a location that can. First up is the Go Sales Data Warehouse.

  • Open Microsoft SQL Server Management Studio and connect to your database server.
  • Right-click in the navigation tree on “Databases” and click “Restore Database”.

IBM Cogos 10.2.1 Samples SQL Server Restore Database GO SALES

  • Enter “GOSALES” in the “To database” field.
  • Click “From device” and then “Add” in the specify backup location screen.

IBM Cogos 10.2.1 Samples SQL Server Specify Backup Database GO SALES

  • Navigate to the location where you extracted the files “GOSALES.zip” and “GOSALESDW.zip” and select that folder.
  • Enter the file names “GOSALES”.

IBM Cogos 10.2.1 Samples SQL Server Locate Backup File GO SALES

  • Click ok till you are back in the “Restore Database” screen and select the backup set for restore.
  • If you want, you can select under “Options” where you want to put the database on disk.
  • Click “OK” and wait.
  • If you are born under a full moon, you should see a display saying “The restore of database ‘GOSALES’ completed successfully.

 IBM Cogos 10.2.1 Samples SQL Server GOSALES Database

  • You should see the database GOSALES in the databases tree. Browse around a bit to make sure that there are actually tables in them with data.

 IBM Cogos 10.2.1 Samples SQL Server GOSALESDW Database

Repeat the above steps for “GOSALESDW” so everywhere it says “GOSALES”, use “GOSALESDW” instead.

If you want you can now clean up the files in the samples folder.

All Parts:

1. Installing the Cognos Samples installation package
2. Restore Go Sales and Go Sales Data Warehouse databases
3. Create data source connections for the samples databases
4. Running the Dynamic Cube Samples
5. Installing the TM1 Samples
6. Create Data Source Connections for TM1
7. Create Data Source Connections for PowerCubes Samples
8. Installing the IBM Cognos Content Store Samples

1 2 3 4 5 6

Cognos Service

Comments
  1. keith |