Create and populate reporting tables for Campaign or eMessage

1.	Create the new reporting database.

2.	Locate the SQL scripts that you generated and saved previously. Refer to Scripts SQL por Origem de Dados if necessary.

3.	Use your database administration tools to run the generated script(s) in the new database.

4.	For Campaign and a DB2® reporting database only, increase the DB2® heap size to 10240 or higher. (The default heap size is 2048.) Use the following command:

db2 update db cfg for databasename using stmtheap 10240

where databasename is the name of the reporting database.

Increasing the heap size ensures that Cognos® does not display SQL error messages if a user selects all the campaigns when running a report like the Financial Summary report.

5.	Locate the db/calendar subdirectory of the Plataforma de Marketing installation and find the version of the ReportsCalendarPopulate script appropriate for the database type. This script creates two more tables: UA_Calendar and UA_Time.

6.	Run the ReportsCalendarPopulate script on the new database that you created with the table creation script.

For DB2® only, do one of the following:

Either run the script from the command line using the command db2 -td@ -vf ReportsCalendarPopulate_DB2.sql

Or, if you use the DB2® client interface, change the termination character to the @ character in the Statement termination character field.

7.	Use your database administration tools to populate the new tables with the appropriate data from the production system database.

Note that you must use your own tools for this step. The SQL Generator does not generate this SQL for you.

8.	For eMessage only, do the following.

In the ReportsPackCampaign\tools directory under your reports pack installation, locate the uare_lookup_create_DB_type.sql script, where DB_type is the database type appropriate for your installation of Campaign .

Edit the appropriate version of the script to remove the drop table statements and save the script.

Run the appropriate version of the script against your Campaign system tables database.