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 HCL® 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.
Complete the following steps to upgrade the 7.5.1 model and install new reports:
Procedure
- Verify that you backed up the model and the old reports.
- Browse to the ProductNameReportsPack\CognosN directory under your HCL
EMM product
installation.
The N in the path refers to the Cognos® version number.
-
Copy the reports archive .zip file, such as Unica Reports for
Campaign.zip, to the directory where your Cognos
deployment archives are saved.
The default location is the deployment directory under your HCL 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, the directory is located on the system that runs 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. Then, 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 HCL
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.
The scripts are all in the ProductNameReportsPack\cognosN\ProductNameModel directory under your HCL EMM product installation.
The N in the path refers to the Cognos version number.
Campaignupgrade80to81.xmlupgrade81to85.xmlupgrade85to86.xmlupgrade86to90.xmlupgrade90to91.xmlupgrade91to911.xmlupgrade911to9112.xml
Interactupgrade80to81.xmlupgrade81to85.xmlupgrade85to86.xmlupgrade86to90.xmlupgrade90to91.xmlupgrade91to911.xmlupgrade911to9112.xml
Leadsupgrade81to85.xmlupgrade86to90.xmlupgrade90to91.xmlupgrade91to911.xml
Campaign with Marketing Operationsupgrade80to81.xmlupgrade82to85.xmlupgrade86to90.xmlupgrade90to91.xmlupgrade91to911.xmlupgrade911to9112.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.xmlupgrade911to9112.xml
Distributed Marketingupgrade86to90.xmlupgrade911to9112.xml
In each script, edit the file paths that point to directories where the localized language versions of the models are stored to reflect your product installation location. Modify the file path in each script for every language that 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
- zh-tw
- 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.
The scripts are all in the ProductNameReportsPack\cognosN\ProductNameModel directory under your HCL 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.xmlupgrade911to9112.xml
InteractpreUpgrade_86_fromanyversion.xmlupgrade75to751.xmlupgrade751to80.xmlupgrade80to81.xmlupgrade81to85.xmlupgrade85to86.xmlupgrade86to90.xmlupgrade90to91.xmlupgrade91to911.xmlupgrade911to9112.xml
Leadsupgrade75to80.xmlupgrade81to85.xmlupgrade86to90.xmlupgrade90to91.xmlupgrade91to911.xml
Campaign with Marketing Operationsupgrade80to81.xmlupgrade81to82.xmlupgrade82to85.xmlupgrade86to90.xmlupgrade90to91.xmlupgrade91to911.xmlupgrade911to9112.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.xmlupgrade911to9112.xml
Distributed Marketingupgrade86to90.xmlupgrade911to9112.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 tasks 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 HCL EMM authentication for information about the new authentication mode, "authenticate per user."