Skip to main content

Mandatory Parameters

The Manage Mandatory Parameters feature lets you require users to select one or more values before they can open a data model using the Link to functionality.

For example, you can require users to select a Company value when linking to another data model. If they attempt to link to a Product Number, they will also be prompted to select a Company.

This feature is useful for ensuring that all required values related to a specific index structure are used. In some databases, such as DB2, if the order of fields defined in the index is not met, a temporary index is created, which can take longer to process. If you know that all indexes in your system start with the Company field, you can require users to select Company before linking to another data model.

important

You must define fields for the data model before attaching scripts.

When to make parameters mandatory​

  • Ensuring index efficiency: Require key fields to match index order and avoid temporary indexes.
  • Limiting results to relevant data: Filter linked models by key fields to prevent irrelevant results.
  • Preventing incomplete links: Require all needed parameters so linked views have complete data.

Manage mandatory parameters​

  1. In Data Models and Views, right-click a data model and select Data Model Designer.
  2. On the Tools tab, click Manage Mandatory Parameters.
    Or click Manage Mandatory Parameters in the toolbar.
  3. In the Manage Mandatory Parameters dialog, select the check boxes for all fields you want to make mandatory.
  4. Click Ok to confirm your selection.