Raymond Ellis

• Jun 25th, 2006

 

1 Start Cognos Impromptu Administrator.

2.From the File menu select Catalog -> New.

3. In the File name text box, type the desired name of the catalog. In the Description text box you can add a description but this is not mandatory.

4. In the Database dropdown select the database that you want to use or click on the "Databases" button select an ODBC connection that you want to use i.e. DB2, Oracle etc. and click the "New Database" button.

5. Click "Ok" and enter the database logon and password.  Click "OK" again.  You should see a database icon in the lower left of you screen without a red X over it.

6. Select the tables that you want to use my highlighting them  on the left side and using the "Add" arrow key to add them to the "Catalog Tables" side. Click "Ok" when your finished.

7.  To create Joins in your tables select the table under the "Join path" window and the table that you want to join it to from the "Available tables" window.

8. Click "Add" and choose the fields to join the tables, click the "Add link" button to create your join.