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.