I hate to think how much time I’ve spent trying to work out how to get the Metrics functionality to work in Connections 4.0 with SQL databases. I did the testing against DB2 and that was fine, there was documentation for that, but the documentation in the IBM Connections Wiki doesn’t include a section on SQL. There is a recent update though, in the comments to the section on “Installing the database client for Cognos Transformer” there is a warning for the SQL Server implementation:
IMPORTANT: When using the default database instance the metrics.db.local.name property should be empty, that is, in the cognos-setup.properties file the property should be set like this:
And Carl Radino offered some helpful advice as well, as being unfamiliar with Cognos and the SQL requirements this is something I’d also spent time trying to determine:
… explain how the configuration of the MS SQL environment is done highlighting the fact that a separate MS SQL Client install is not necessary but how the cognos-setup.properties is used to configure the connections. Additionally, illustrating how you can check this connection using the Cognos Administrator Web Tool for the METRICS_CUBE_DS connections alias.
Now to reinstall and reconfigure Cognos and see if I can get the Metrics to work this time.