Upgrading the 8.x or 9.x model and installing new reports

Upgrading the 8.x model and installing the new reports are the first steps that you must complete to upgrade your reports.

1.	Complete the following steps to upgrade the 8.x model and install new reports:

2.	Navigate to the Unica\ProductNameReportsPack\CognosN directory, where N is the version of your Cognos® installation.

3.	Copy the reports archive .zip file, for example Unica Reports for Campaign.zip, to the directory where your Cognos® deployment archives are saved.

The default location is the deployment directory under your IBM® Cognos® installation and the directory is specified in the Cognos® Configuration tool that is installed with the Cognos® Content Manager, for example: cognos\deployment.

In a distributed IBM® Cognos® environment, the directory is a location on the system that runs the Content Manager.

Copy the pre-upgrade version of the Campaign model to a directory on the server where your Framework Manager is installed. If the Reports Pack installation directory and Framework Manager are on different servers, locate the upgraded cognos10\model directory under the Reports Pack installation directory and copy the appropriate upgrade.xml files to the directory on the server where Framework Manager is installed. Also copy the translation folder of upgraded model in the old model that is copied to the directory on the server where Framework Manager is installed. If prompted for replacement, click Yes

5.	If the Reports Pack installation directory and Framework Manager are on different servers, locate the cognos10\model directory under the Reports Pack installation directory, and copy the appropriate upgrade.xml files to the server where your Framework Manager is installed.

6.	Copy the translation folder of the upgraded Campaign model in the old model that you copied to a directory on a server where your Framework Manager is installed. If you see a prompt for replacement, click Yes.

7.	If you did not install your IBM® EMM product to the default C:\Unica directory on Windows™ you must update the following upgrade scripts:

You must consider the following points for the 8.x version from which you are upgrading:

You do not have to run the scripts that refer to earlier versions. For example, if you are upgrading Campaign reports from version 8.5.0, you would not have to run the upgrade80to81.xml and upgrade81to85.xml scripts.

You must run the preUpgrade_86_fromanyversion.xml script for upgrades from all versions except 8.6.

Campaign with Marketing Operations

upgrade86to90_DB2.xml (for DB2® database only)

upgrade86to90_Oracle.xml (for Oracle database only)

upgrade86to90_Sqlserver.xml (for SQLServer database only)

upgrade90to91.xml

Interaction History

Upgrade from version 9.0 is not supported.

Attribution Modeler

Upgrade from version 9.0 is not supported.

In each script, edit file paths that point to directories where localized language versions of the models are stored to reflect your product install location. Make this change for every language your users need. For example:

install_directory \ReportsPackCampaign\cognosN\CampaignModel\translations\L\translations.txt

The N in the path refers to the Cognos® version number.

The L in the path refers to one of the following language indicators:

8.	Open Cognos® Connection.

9.	Select Administer Cognos Content > Configuration > Content Administration.

10.	Click the New Import button on the toolbar and import the reports folder.

11.	Open Cognos® Framework Manager and open the project for the version from which you are upgrading.

12.	Select Project > Run Script.

13.	Run the following scripts from the new version of your product:

You must consider the following points for the 8.x version from which you are upgrading:

You must run the preUpgrade_86_fromanyversion.xml script for upgrades from all versions except 8.6.

Campaign

preUpgrade_86_fromanyversion.xml

preUpgrade_86_fromanyversion.xml

Campaign with Marketing Operations

upgrade86to90_DB2.xml(for DB2® database only)

upgrade86to90_Oracle.xml(for Oracle database only)

upgrade86to90_Sqlserver.xml(for SQLServer database only)

upgrade90to91.xml

Interaction History

Upgrade from version 9.0 is not supported.

Attribution Modeler

Upgrade from version 9.0 is not supported.

The scripts are all located in the ProductNameReportsPack\cognosN\ProductNameModel directory under your IBM® EMM product installation, where N is the Cognos® version number.

14.	If you are upgrading eMessage reports, complete the following steps:

If your database is DB2®, change the statement termination character from ; (semicolon) to ! (exclamation point).

a.	Go to Campaign_ReportPack_Installer_Home\Cognos10\ emessage-ddl\DB Type\Upgrade.

b.	Run the following scripts in the sequence shown:

If you are upgrading from eMessage 8.6.0.4:

acer_tables_upgrade_dbname.sql. Search for the base version name and run the following script:

--8.6.0.4 Updates--

If you are upgrading from eMessage 9.0:

acer_tables_upgrade_dbname.sql. Search for the base version name and run the following script:

--9.0.x Updates--

acer_indexes_upgrade_dbname.sql. Search for the base version name and run the following script:

--9.0.x Updates--

c.	Go to Campaign_ReportPack_Installer_Home\Cognos10\ emessage-ddl\DB Type and run the following script:

acer_scripts_dbname.sql

If you are using Microsoft™ SQL Server, you must drop the 8.6.0.4 version's procedures before completing this step.

d.	Generate the report view scripts by using Run SQL Generator and create materialized views for Oracle and IBM® DB2®, and views for Microsoft™ SQL Server.

e.	Run and schedule stored procedures. For more information about eMessage stored procedures, see Running and scheduling stored procedures for eMessage.

15.	Publish the package to the Cognos® content store.

16.	For all IBM® EMM products except eMessage and Attribution Modeler, complete the following steps in Cognos® Report Studio for each cross-object Performance by Cell and object-specific Performance by Cell report.

a.	Go to File > Report Package.

b.	Select Unica Campaign Package and click OK.

c.	Fill in prompts on the report as necessary.

d.	After the report is validated, click Close in the Validation Response window.

17.	Run a report to test your upgrade.