Add Standard Column-Based Master Keys to a View
You can add a simple or composite master key based on standard columns to a view.
To add a standard column-based master key
On the NoetixViews Workbench home page, click Modify a View. The Modify View page appears.
Select a view, and then click Modify. For more information, see Select a View.
On the Modify View » <view label> page, under View, click Add, modify keys and joins, and then click Next. The Modify View » <view label>» Add, modify keys and joins page appears.
Under Master Keys, click the Add Master Key link. The Add Master Key <view label> dialog box appears.
Click Standard. By default, this option is selected.
In the Key Name box, provide a unique key name for the master key. However, the key name can match with that of an existing master key with different capitalization.
In the Description box, provide a meaningful description.
If the master key can return a unique value in every row, select the Master Key Columns Define Unique Values check box. If this check box is selected, the cardinality options in any join that uses this master key will be one-to-one and one-to-many from the perspective of the master view. If the check box is cleared, the cardinality options will be many-to-one and many-to-many from the perspective of the master view.
In the Available Columns list, select one or more columns that will be basis of the master key. The list includes only those columns that are present in all queries of the view and does not include columns of the descriptive flexfield type and unsupported column types in NoetixViews Workbench.
In the Master Key Columns list, specify the order of the columns in the master key to achieve better run-time performance of joins to the view.
Click OK. The Modify View » <view label> » Add, modify keys and joins page appears with the new master key listed under Master Keys.
In the Customization comments box, provide a summary of the customizations that you have performed. The customization comments can contain a maximum of 200 characters.
Click Save.The customizations are saved, and the Modify View» <view label> page appears.
Now, you can choose to perform any other customizations on the same view or go to the home page.