Varicent Sales Performance Management Documentation

TS002076059 — Able to create a custom table with 13 primary key columns

Fixed: Resolved an issue where users can create a custom table with more than 12 primary key columns by making the table effective dated.

Reproduction Steps

1. In Composer, open the component that you want to add the new table to.

2. From the Palette tab, drag the Table object into the component.

3. From the Table type drop-down list, select Custom and click Next.

4. Type a name and description for the table and click Save. The table name cannot contain spaces.

5. Type a name for the primary key field and select the column type from the Type drop-down list.

6. Click 'Add a column' to add more fields to the table.

7. For each field that you add, perform the following steps:

  a. If the field is a primary key field, select the ID check box to make the field a primary key.

  b. Type a name for the new field.

8. Repeat steps 6 and 7 until you have 12 primary key columns.

9. Select the 'Effective dated' check box.

The result is making the table effective dated adds an additional primary key column when users should not be able to create tables with more than 12 primary key columns.