Upgrading reporting templates in the Marketing Platform

You must upgrade reporting templates in Marketing Platform before upgrading reports. If you are upgrading reports for Marketing Operations, do not upgrade reporting templates, because Marketing Operations does not have reporting schemas.

1.	After you have run the report pack installer, complete the following tasks:

2.	Navigate to the Unica\productReportsPack\schema directory, locate the templates_sql_load.sql script and run the script in the Marketing Platform system tables database.

3.	Ensure that the Marketing Platform is running.

4.	Log in to IBM® EMM as a user with administrator privileges.

5.	Under Settings > Users, give yourself the ReportsSystem role. Then log out and log back in.

6.	Campaign only.

The database schema for adding new campaign attributes changed in Campaign 8.0.0. Therefore, if the reporting schema customization included additional campaign attributes, complete the following steps:

a.	Use your database management tools to determine the value from each attribute's AttributeID column in the UA_CampAttribute table.

b.	In IBM® EMM, select Settings > Configuration and expand Reports > Schemas > Campaign > Campaign Custom Attributes > Columns > Campaign.

c.	Delete the existing custom campaign attributes that were added for this installation, but do not delete the standard custom campaign attributes. (The standard custom campaign attributes were upgraded by the installer.)

d.	Re-create the attributes you deleted. Enter the ID of the attribute in the Attribute ID field.