Hi there,
In order to use Metric Studio I have installed Metric Server and Metric Designer. The content store is a Cognos Content Store and the Metric installation directory the same as the BI directory.
On a SQL Server 2005 I created a database and made user TEST db_owner. Now this user seems to be able to connect and use the database (testing using Excel and ODBC) but when pointing to the database in the wizard "New Metric Package"/"New Data Source" the connection returns an error (unfortunatly in dutch);
(http://picsaver.org/files/zmznddldbum3jmzxjmut.jpg)
All feedback is welcome!
- Thijs
First you must create the metric content store as a distinct one from the Cognos content store :
In the Application Tier Components location, in the c8_location/configuration/schemas/cmm/sqlserver directory, run the cmm_create_db.cmd script by typing the following command:
path_to_script cmm_create_db host_name database_name user_name password [user_to_create]
then have a look there : http://publib.boulder.ibm.com/infocenter/c8bi/v8r4m0/index.jsp?topic=/com.ibm.swg.im.cognos.qrc_mm_inst.8.4.0.doc/qrc_mm_inst_id634inst_CreatetheContentStore.html (http://publib.boulder.ibm.com/infocenter/c8bi/v8r4m0/index.jsp?topic=/com.ibm.swg.im.cognos.qrc_mm_inst.8.4.0.doc/qrc_mm_inst_id634inst_CreatetheContentStore.html)