Creating Models › Target Servers for Physical Models › Database Property Editors › Materialized Query Tables › Define the Properties of a Materialized Query Table › Specify an Organization Type for a Materialized Query Table

Specify an Organization Type for a Materialized Query Table

You can use the Organize By tab in the Materialized Query Tables editor to specify either dimension or key sequence as the organization type.

To specify an organization type for a materialized query table

1. Click Materialized Query Tables on the Model menu in a physical model based on DB2.

   The Materialized Query Table Editor opens.

2. Click the Organize By tab. Select one of the following options:
   • Select the Dimension type and indicate a Dimension Group.
   • Select the Key Sequence type and indicate choices for key sequence overflow, key sequence percent free, and key sequence columns.
3. Click Close.

   Your changes are saved and the Materialized Query Table Editor closes.