Reports | Schemas | [product] | [schema name] | SQL Configuration
The SQL script creates views for the reporting schemas. The Reports | Schemas | [product] | [schema name] | SQL Configuration property provides information about the name of the views.
Table/View Name
- Description
Specifies the name of the view that the SQL script you generate for this reporting schema creates. 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.
- Default value
Varies by schema
- Valid Values
A string with the following restrictions.
- It can be no longer than 18 characters
- It must use all uppercase letters
You must use the following naming convention:
- Start the name with the letter "UAR"
- Add a one-letter code to represent the 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 following list of codes:
For example: UARC_COPERF_DY is the name of the reporting view for Campaign Offer Performance by Day.
Following is the list of Unica application codes.
- Unica Campaign: C
- Unica Deliver: E
- Unica Interact: I
- Unica Collaborate: X
- Unica Plan: 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