Upgrading 7.5.1 model and installing new reports
Upgrading the 7.5.1 model and installing the new reports are the first steps that you must complete to upgrade your 7.5.1 reports.
About this task
The new report packages include new and changed reports as well as dashboard reports for most of the IBM® EMM applications. Although you can upgrade the model, you cannot upgrade the 7.5.1 reports. You must install the new reports and then re-create the reporting customizations that you made to 7.5.1, or copy the old reports into the folder.
Procedure
- Verify that you backed up the model and the old reports.
- Browse to the ProductNameReportsPack\CognosN directory under your IBM EMM product
installation.
The N in the path refers to the Cognos® version number.
- 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 EMM Cognos installation and it is specified in the Cognos Configuration tool that is installed with the Cognos Content Manager.
For example: cognosN\deployment.
The N in the path refers to the Cognos version number.
In a distributed IBM Cognos environment, this is a location on the system running the Content Manager.
- If the Reports Pack installation directory and Framework
Manager are on different computers, locate the cognosN\model directory under the Reports Pack installation
directory, and copy it to the directory on the computer where your
Framework Manager is installed.
The N in the path refers to the Cognos version number.
- Only if you did not install your IBM EMM product
to the default directory (C:\Unica on Windows™) you must update some
upgrade scripts as described in this step.
You must update the scripts that are listed here. The scripts that you must update differ, depending on the reports package, as shown below.
The scripts are all in the ProductNameReportsPack\cognosN\ProductNameModel directory under your IBM EMM product installation.
The N in the path refers to the Cognos version number.
Campaignupgrade80to81.xmlupgrade81to85.xmlupgrade85to86.xmlupgrade86to90.xmlupgrade90to91.xmlupgrade91to911.xml
Interactupgrade80to81.xmlupgrade81to85.xmlupgrade85to86.xmlupgrade86to90.xmlupgrade90to91.xmlupgrade91to911.xml
Leadsupgrade81to85.xmlupgrade86to90.xmlupgrade90to91.xmlupgrade91to911.xml
Campaign with Marketing Operationsupgrade80to81.xmlupgrade82to85.xmlupgrade86to90.xmlupgrade90to91.xmlupgrade91to911.xml
Marketing Operationsupgrade75to80.xmlupgrade80to81.xmlupgrade81to82.xmlupgrade82to85.xmlupgrade85to86.xmlupgrade86to90_DB2.xml(for DB2® database only)upgrade86to90_Oracle.xml(for Oracle database only)upgrade86to90_Sqlserver.xml(for SQLServer database only)upgrade90to91.xmlupgrade91to911.xml
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.- fr
- de
- es
- it
- ja
- ko
- pt
- ru
- zh
- Open Cognos Connection.
- Select Administer Cognos Content > Configuration > Content Administration.
- Click the New Import button on the
toolbar
and import the reports folder. - Open Cognos Framework Manager and select the project that corresponds to your old reports.
- Select Project > Run Script.
- Run the following scripts from your new version against
your old reports.
You must run the scripts that are listed here. The scripts that you must run differ, depending on the reports package, as shown below.
The scripts are all in the ProductNameReportsPack\cognosN\ProductNameModel directory under your IBM EMM product installation.
The N in the path refers to the Cognos version number.
CampaignpreUpgrade_86_fromanyversion.xmlupgrade75to751.xmlupgrade751to80.xmlupgrade80to81.xmlupgrade81to85.xmlupgrade85to86.xmlupgrade86to90.xmlupgrade90to91.xmlupgrade91to911.xml
InteractpreUpgrade_86_fromanyversion.xmlupgrade75to751.xmlupgrade751to80.xmlupgrade80to81.xmlupgrade81to85.xmlupgrade85to86.xmlupgrade86to90.xmlupgrade90to91.xmlupgrade91to911.xml
Leadsupgrade75to80.xmlupgrade81to85.xmlupgrade86to90.xmlupgrade90to91.xmlupgrade91to911.xml
Campaign with Marketing Operationsupgrade80to81.xmlupgrade81to82.xmlupgrade82to85.xmlupgrade86to90.xmlupgrade90to91.xmlupgrade91to911.xml
Marketing Operationsupgrade75to80.xmlupgrade80to81.xmlupgrade81to82.xmlupgrade82to85.xmlupgrade85to86.xmlupgrade86to90_DB2.xml(for DB2 database only)upgrade86to90_Oracle.xml(for Oracle database only)upgrade86to90_Sqlserver.xml(for SQLServer database only)upgrade90to91.xmlupgrade91to911.xml
- Publish the package to the Cognos content store.
- Run a report to ensure that it works properly.
- If the 7.5.1 reports were customized, re-create those customizations.
Alternately, if you can ensure that an old report works properly with the upgraded model, copy the old report back.
For information about fixing the old Campaign Performance by Cell reports and the old Offer Performance Summary by Campaign reports so they work with the new data model, continue with the remaining procedures in this section.
- If you have reports installed for multiple partitions, configure reports packages for the additional partitions by using the instructions in the chapter that describes how to configure multiple partitions.
- Optional: See Configure IBM Cognos to use IBM EMM authentication for information about the new authentication mode, "authenticate per user."