Reports > Schemas > [product] > [schema name] > SQL Configuration

Table/View Name

Specifies the name of the view or table that the SQL script you generate for this reporting schema will create. As a best practice, you should not change the name for any of the standard or default Table/View names. If you do, you must also change the name of the view in the Cognos model in IBM Cognos Framework Manager.

When you create a new reporting schema for a new audience level, you must specify the names of all the new reporting tables/views.

Valid values

A string with the following restrictions.

It can be no longer than 18 characters

It must use all UPPER-CASE letters

Following is the naming convention you should use:

Start the name with the letter "UAR"

Add a one-letter code to represent the IBM Unica application. See the list of codes, below.

Add an underscore character

Add the table name, including a one or two letter code to indicate the audience level

Finish with an underscore character.

The SQL generator appends a time dimension code, if appropriate. See the list of codes, below.

For example: UARC_COPERF_DY is the name of the reporting view or table for Campaign Offer Performance by Day.

Following is the list of IBM Unica application codes.

Campaign: C

eMessage: E

Interact: I

Distributed Marketing: X

Marketing Operations: P

Leads: L

Following is the list of the Time Dimension Codes added by the generator.

Hour: HR

Day: DY

Week: WK

Month: MO

Quarter: QU

Year: YR

Default value

Varies by schema