Setting up the Cognos Metrics Manager Samples - Part 2

Part 2: Set up connections to the databases in Cognos.

This next part is quick, it is just setting up three connections to the databases in Cognos Connection. There is also a step at the end where you initialize the metric store and create a new metric package.

Step 1 - Set up connections to the sample databases GOSALES, GOSALESDW

Open up Cognos Connection go under Launch in the far right and select Cognos Administration.

Go under Data Source Connections and click on the New Database icon.

 

Enter great_outdoors_sales in the name field and click Next.

 

Of course choose Microsoft SQL Server as the Type of connection.

Then put in the SQL Server name, the Database name, the Signon info and test the connection.

Do the same thing for the great_outdoors_warehouse.

Then do the go_metrics Data Source connection.

When this one gets to the finish screen check off the Create a Metric Package box.

 

Enter the name GO Metrics.

Choose the Default Deployment and on the next screens the Standard Calendar with Years, Quarters and Months.

 

Enter the date as shown and click Initialize.

Hopefully it all works out and you get to this screen where I checked off the open in Metric Studio option.

Next is Part 3: The Metric Studio content.