You can use SQL scripts to create and populate reporting tables for Unica Campaign. The reports application uses reporting tables
to extract reportable data.
About this task
To create and populate reporting tables for Unica Campaign, complete the following steps.
Procedure
- Create the reporting database.
- Locate the SQL scripts that you generated and saved previously.
- Use your database administration tools to run the appropriate
script against the appropriate application database(s) for the report
package that you are configuring.
-
For Unica Campaign with a DB2® database, increase the DB2 heap size
to at least 10240. The default heap size is 2048. Use the following command to increase the heap
size:
db2 update db cfg for databasename using stmtheap 10240
where databasename is the name of the Unica Campaign 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 such as the Financial Summary report.
-
In the db/calendar subdirectory in the Unica Platform installation directory, find the
ReportsCalendarPopulate
script that is appropriate for the database type.
The
ReportsCalendarPopulate
script creates the following tables:
- Run the ReportsCalendarPopulate script
on the new database that you created with the table creation script.
-
For DB2 only, complete one of the following tasks:
- Use your database administration tools to populate the
new tables with the appropriate data from the production system database.
Note: You must use your own tools for this step. The SQL Generator
does not generate the SQL for you.
What to do next
Continue with Setting up data synchronization.