Cisco Cisco Prime Service Catalog 10.0 Installation Guide

If you click Restore Defaults, your edited values are overwritten by the current configuration values 
from your existing Data Mart database.

Click Next to proceed to the next page of the wizard.

The Form Data Reporting Dictionary Settings page of the wizard appears, as shown in 

 below.

Service table prefix

If you must change the prefix, use only alphabetic characters and the 
underscore character. Do not use any numeric or special characters. A 
modification will cause the tables to be deleted and then recreated. It also 
resets the timestamp in database. 

Your form reporting data will need to be regenerated by running the ETL 
Script 'update_datamart.cmd' in full mode (see the 

). You must also restart the “IMB Cognos 8” service.

Table columns prefix

The prefix for the field names in each table. This name is used to create 
tables with field name like FIELD1, FIELD2, …, FIELDn. A modification 
will cause the tables to be deleted and then recreated. It also resets the 
timestamp in database. 

Your form reporting data will need to be regenerated by running the ETL 
Script 'update_datamart.cmd' in full mode (see the 

). You must also restart the “IMB Cognos 8” service.

Text column max length This parameter indicates the maximum size of dictionary and service table 

object varchar field size.

You can only increment the current value. No data will be lost and timestamp 
is not reset. A modification will alters the Dictionary and Services tables in 
the Data mart database by changing the size of VARCHAR() columns.