Defining a primary key

A primary key dimension is a field which contains keys unique for each record. When you add dimensions to your Qommentary Writeback table, you will need to select one dimension to be used as the primary key.

To select a dimension to be used as a primary key, please follow these steps:

1. Add a dimension to your table

2. Expand the dimension's properties 3. Click on the switch control to select dimension as Primary key dimension

Be aware of any additional dimensions added which could split the primary key dimension forcing it to display duplicated values - thus breaking the primary key purpose.

In that case, consider creating a composite key.

Using a single dimension

When the dimension chosen to act as a primary key displays unique records in the table, then selecting a single dimension is sufficient.

Example:

Using a composite dimension

When a single dimension cannot produce unique records, then a composite dimension must be created.

Example:

You may hide the column if you do not wish to display it in your table.