Step: Upgrade the reporting templates in the Marketing Platform
*
If you are upgrading Marketing Operations , skip this step: Marketing Operations does not have reporting schemas.
After you have run the report pack installer, complete the following steps.
1.
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.
2.
Ensure that the Marketing Platform is running.
3.
Log in to IBM® EMM as a user with administrator privileges.
4.
Under Settings > Users, give yourself the ReportsSystem role. Then log out and log back in.
5.
Campaign only.
The database schema for adding new campaign attributes changed in Campaign 8.0.0. Therefore, if the reporting schema customizations included additional campaign attributes, do the following.
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.
Copyright IBM Corporation 2012. All Rights Reserved.