Skip to main content

Data Model Designer Properties

In the Data Model Designer, you can configure settings that define the behavior, performance, and data source associations for your data model. These properties are organized into General and Performance tabs.

Configure data model properties​

  1. In Data Models and Views, right-click a data model and select Data Model Designer.
  2. On the File tab, click Data Model Properties.
    Or click Data Model Properties on the toolbar.
  3. Modify the data model name and change the data source if needed.
  4. Edit the properties in the General and Performance tabs.
  5. Click Ok to save your changes.
  6. On the File tab, click Save Data Model.

Data model properties​

General​

PropertyDescription
Unique name for the prompt(Optional) Enter a unique name for the prompt. The unique ID for this data model can be reused in other data models.
Select distinct recordsRemove duplicate rows from the model results. Use when the prompt is defined from a table where the list of values is not unique.
Return distinct values using
the SQL clause "Group By"		Return a distinct set of values using the GROUP BY SQL syntax. In some databases, such as DB2, GROUP BY can be faster than DISTINCT, which may require a table scan or index creation.
Worksheet is updatableAllow data entry for editable fields at the data model level. If unchecked, editable fields cannot be updated. Only fields from the fact table can be updated.
Display Selection page on openRequire users to choose from existing selection pages when opening a view that uses this data model.
important

For Cloud installations, performing a manual backup is highly recommended if you use the data entry feature (for example, Sales Forecast or Financial Budget) through SEI to provide greater data retention.

You can manually back up data by exporting to Excel, or automate the process using the scheduler or DataSync module to replicate Cloud data to a local environment for enhanced security.

Performance​

PropertyDescription
Query timeout(DB2 only) Set the maximum number of seconds SEI waits for a query to return results. Cancel the query when the timeout is reached to prevent long or unwanted queries from consuming system resources. If not set, wait until the query finishes. Applies only to DB2 data sources.
Maximum number of recordsLimit the number of records that can be loaded in any view that uses this data model. If not set, apply no restriction.