. For data to be transferred successfully,
the user account that is used to access the database must have a
default language of English.Before users can use IBM Cognos 8 Metrics Manager, you must create at least one metric package using the New Metric Package wizard. A metric package is an IBM Cognos Connection representation of an IBM Cognos 8 Metrics Manager application. A metric package contains connection information, reports, and metric management tasks for that application. The metric package content is stored in a metric store.
You open the New Metric Package wizard from the toolbar in IBM Cognos Connection and create a metric package using
a new data source connection to a metric store
an existing data source connection to a metric store
an existing metric store if the database was used with an earlier version of IBM Cognos 8 Metrics Manager 8.1 or later
Use the wizard to define the metric package name and the data source connection to the metric store. For a new metric store, you also provide the information necessary to initialize the database, including the start and end dates of the fiscal year.
Before you can use the New
Metric Package wizard, you must have access to a metric store used
with Metrics Manager version 2.0 or later or you must create a database
for a new metric store . For data to be transferred successfully,
the user account that is used to access the database must have a
default language of English.
Open IBM Cognos Connection by connecting to the IBM Cognos 8 portal and clicking IBM Cognos Content on the Welcome page.
Click the New metric package button.
Type a name and description for the IBM Cognos 8 Metrics Manager application to represent this metric package, and click Next.
Click New data source.
Type a name and description for the data source connection for the metric store that contains the content for this metric package, and click Next.
In the Type box, click the database type.
Select the isolation level, and click Next.
Specify the information required for your database type and click Finish.
For a Microsoft SQL Server database, type the name of the database server and the database. Under Signons, select the Password and Create a signon that the Everyone group can use check boxes, and type the user ID and password of the user account with access to the database.
The user account must have the default language set to English.
For an Oracle database, type the connection string. Select User ID, select the Password and Create a signon that the Everyone group can use check boxes, and type the user ID and password of the user account with access to the database.
For a DB2 database, type the name of the database and the connection string. Select User ID, select the Password and Create a signon that the Everyone group can use check boxes, and type the user ID and password of the user account with access to the database.
In most cases, a collation sequence is not required. If you want to provide one, ensure the value you enter is the same as the collation sequence specified when the database was created. For information about collation sequences, see the database documentation.
Tip: To test whether the parameters are correct, click Test the connection.
Click the new data source and click Next.
Click Next and follow the prompts to provide the information necessary to initialize the database. When you see the page that summarizes the data source details and the metric store settings, click Initialize.
Select Open this package with Metric Studio after closing the wizard and then click Finish.
Metric Studio opens and the new metric package is displayed in IBM Cognos Connection. For information about managing the metric store, including how to load data, see the IBM Cognos 8 Administration and Security Guide.
Open IBM Cognos Connection by connecting to the IBM Cognos 8 portal and clicking IBM Cognos Content on the Welcome page.
Click the New metric package button.
Type a name and description for the IBM Cognos 8 Metrics Manager application to represent this metric package, and click Next.
Click New data source and click Next.
Click Next and follow the prompts to provide the information necessary to initialize the database. When you see the page that summarizes the data source details and the metric store settings, click Initialize.
Select Open this package with Metric Studio after closing the wizard and then click Finish.
Metric Studio opens and the new metric package is displayed in IBM Cognos Connection. For information about managing the metric store, including how to load data, see the IBM Cognos 8 Administration and Security Guide.
Open IBM Cognos Connection by connecting to the IBM Cognos 8 portal and clicking IBM Cognos Content on the Welcome page.
Click the New metric package button 
.
Type the name and description for the IBM Cognos 8 Metrics Manager application to represent this metric package and click Next.
Click New data source.
Type the name and description for the data source connection for the metric store that contains the content for this metric package, and click Next.
In the Type box, click the database type and click Next.
Specify the information required for your database type:
For a Microsoft SQL Server database, type the name of the database server and the database. Under Signons, select the Password and Create a signon that the Everyone group can use check boxes, and type the user ID and password of the user account with access to the database.
The user account must have the default language set to English.
For an Oracle database, type the connection string. Under User ID, select the Password and Create a signon that the Everyone group can use check boxes, and type the user ID and password of the user account with access to the database.
For a DB2 database, type the name of the database and the connection string. Select User ID, select the Password and Create a signon that the Everyone group can use check boxes, and type the user ID and password of the user account with access to the database.
In most cases, a collation sequence is not required. If you want to provide one, ensure the value you enter is the same as the collation sequence specified when the database was created. For information about collation sequences, see the database documentation.
Tip: To test whether the parameters are correct, click Test the connection.
Click Next.
Select Open this package with Metric Studio after closing the wizard and then click Finish.
Metric Studio opens and the new metric package is displayed in IBM Cognos Connection.
Click the new data source and click Next.
Click Upgrade.
The wizard updates the database schemas and other information.
For information about managing the metric store, see the Administration and Security Guide.
