[]
(Showing Draft Content)

Data Model Settings

As an administrator in the Wyn Enterprise Portal, you can configure global settings that control how data models behave across reports and direct models. These settings help optimize performance, manage data volume, and ensure consistent query behavior.


Data Model Settings

Access Data Model Settings

  1. Open the Admin Portal.

  2. Navigate to Configuration→ Data Model Settings.

The Data Model Settings panel opens, allowing you to view and modify available configuration options.


Prevent Generating DISTINCT for Report

  • Type: Toggle (True / False)

  • Default: True


    Description:


    Determines whether the system automatically generates the DISTINCT keyword when building report queries.


  • Enabled (True)

    • Disables automatic DISTINCT generation.

    • Preserves duplicate records when fields from a data model are used in reports.

    • Recommended when using aggregation functions such as Sum or Count, where deduplication may result in incorrect values.

  • Disabled (False)

    • Allows the system to generate DISTINCT.

    • Duplicate records may be removed from the query result.


      Expected Result: When enabled, report calculations are based on the original data set without enforced deduplication.

Direct Model Local Entity Max Column Count

  • Type: Numeric

  • Default: 14


    Description


    The default maximum value is 14; excessively large values can lead to a decrease in query performance or even prevent the return of query results.

  • Use the + / – buttons to adjust the value.

  • This setting helps limit schema width and maintain predictable performance.


    Expected Result: Local entities that exceed the configured column limit cannot be created.

Direct Model Local Entity Max Row Count

  • Type: Numeric

  • Default: 2000


    Description


    The default maximum value is 200; excessively large values can lead to a decrease in query performance or even prevent the return of query results.

  • Adjust the limit using the + / – buttons.

  • Prevents excessive data from being materialized locally.


    Expected Result: Once the row limit is reached, no additional rows are loaded into the local entity.

Actions

  • Save Changes: Saves the updated configuration and applies it across the environment.

  • Cancel: Discards all changes and closes the settings panel.