merblog

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.

Setting up the Cognos Metrics Manager Samples - Part 1

Part 1: Create and populate the databases in SQL.

Well, setting up the samples is not so easy, simply because the directions are not very clear. Here is the path I followed to get it going -

Step 1 - Set up the sample databases GOSALES, GOSALESDW

I'm using SQL Server 2005 so I go to SQL Server Management Studio, right click New Database, then enter the name GOSALES or GOSALESDW and click okay.

Then I right mouse click on the Database name and select Tasks -> Restore -> Database. I choose the Restore from File option and click Add.

Making sure I select the All Files File type from the drop down, I choose my unzipped GOSALES sample file and click okay.

I put a check mark next to the Restore check box.

And head over to the Options page where I check off the Overwrite the existing database option.

 

Hopefully this part at least is an easy success.

 

Step 2 - Create the GOMETRICS Metric Store.

Now, I don't know why Cognos tells you to create the metric store database in SQL using the command line prompt versus the SQL Server Management Studio, but I am just going to shut up, not ask too many questions and do it their way ;-).

I have to close SQL Server Management Studio and open it again to refresh it so I can see the new database.

Installing Cognos 8.3 BI is easier than ever.

Installing all the Cognos BI components on my work laptop has gotten oh so much easier than when I first started out 10 years or so ago. I remember in 1999 when Upfront and IWR were a hassle getting them to work together on my laptop let alone on the server. Now things like making sure your Hard drive is NTFS or the cognos.com is in the domain properties, is all in the past as it should be. There were times when it would take me several days to get things working. Now it takes only a few hours.

Tonight I started my install of Cognos 8.3 on my Windows XP laptop at 7PM. First thing I did was make sure I had my IIS installed. 

 

Then I put on SQL Server 2005.

 

I choose the Default instance, the Local System Account and the Mixed Mode options.

When that all finishes I set up my Content Store database in SQL Server Management Studio.

Then I install the Cognos installers with the BI Server being first and by accepting all the defaults and allowing the creation of all new directories. I expand the options and make sure they are all checked off such as with the BI Server Install, the Content Database (even though I delete this later).

 

I didn't bother installing the Composite Server or Transformer this time but I do install the Samples.

Then I configure my Virtual Directories in IIS (cognos83, cgi-bin, images). I choose Read, Run and Browse for Cognos83 and cgi-bin. For images I choose just Read and Browse.

Then I start up Cognos Configuration and Delete the Cognos content database.

And I add my SQL Server Cognos Content Database.

Then I click on the small pencil icon and enter my SQL user name and passcode (e.g sa).

 

Right click to test, then click at the top Local Configuration and choose Save, then Run.

Hopefully you get a success message.

Then you can open your browser and type http://localhost/cognos83

I'm going to do another blog post in the next few days with the steps of setting up Metrics Manager samples.

If there is anyone out there reading, give me a shout!

Night Night!