You must upgrade reporting templates in Marketing Platform before you
upgrade reports. If you are upgrading reports for Marketing Operations,
do not upgrade reporting templates because Marketing Operations does
not have reporting schemas.
Procedure
After you run the report pack installer, complete the
following tasks:
- Browse to the Unica\productReportsPack\schema directory, locate the templates_sql_load.sql script and
run the script in the Marketing Platform system
tables database.
- Ensure that the Marketing Platform is
running.
- Log in to HCL®
EMM as a
user with administrator privileges.
- Under Settings > Users, give yourself
the ReportsSystem role. Then, log out and log
back in.
- Campaign only.
The database schema for adding new campaign attributes was
changed in Campaign 8.0.0.
Therefore, if the reporting schema customization included additional
campaign attributes, complete the following steps:
- Use your database management tools to determine the
value from each attribute's AttributeID column
in the UA_CampAttribute table.
- In HCL
EMM, select Settings
> Configuration and expand Reports > Schemas
> Campaign > Campaign Custom Attributes > Columns > Campaign.
- 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.)
- Re-create the attributes that you deleted. Enter the
ID of the attribute in the Attribute ID field.