Step: Upgrade the reporting templates in the Plataforma de Marketing
*
If you are upgrading Operações de Marketing, skip this step: Operações de Marketing 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 Plataforma de Marketing system tables database.
2.
Ensure that the Plataforma de Marketing 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.