DB Settings

  1. From the menu, select Data Administration > DB Settings.
  2. In Subsystem ID, select an action from the list.

    This table shows the available actions:

    Action Description
    3 - Scenario Part Information
    4 - Form Change Information
    5 - User Rights
    6 - User Domains
    7 - Forecast Method
    8 - Conversion Value
    9 - Favorite View Panel
    10 - Scoreboard Panel
    11 - Base Change Panel
    12 - Sales Activity Panel
    13 - Version List Panel
    14 - Favorite View Panel
    15 - Scoreboard Panel
    16 - Version List Panel
    17 - Promotion Panel
    18 - Promotion Line Panel
    19 - Import/Export Setup
    20 - Import/Export MI Setup
    21 - Import/Export Advance MI Setup
    22 - Menu Launch
    23 - Additional Key String
    24 - Additional Numerical Key
    25 - SubSys Scripts
    26 - Workflow Semaphore
    27 - SubSys Version
    28 - Promotion Grid Head Panel
    29 - Promotion Grid Line Panel
    30 - Global Settings
    31 - Promotion Settings Panel
    38 - Export V2
    • Set the SndDatasetDta setting to true to use OSS401MI.SndDatasetDta as an alternative to OSS401MI.SndBudget. However, using SndDatasetDta instead of SndBudget offers no added benefit.
    • ExportFilesRetentionHours controls whether new JSON files are written during export. When set to a value greater than 0, the export generates files for the duration of that period, after which the setting automatically resets to 0 and file generation stops until the user reconfigures the setting.
    • ExportFilesRetentionTimeStamp defines the start of the retention period for exported JSON files generated by the Export Dataset function and stored in the DmpPack/<TenantID>/Export folder. Files are automatically deleted 24 hours after the ExportFilesRetentionHours expires. The timestamp is updated when the retention period expires.
      Note: Files generated more than 24 hours past expiration are deleted only during the next execution of Export Dataset. Files are not automatically deleted immediately after reaching the 24-hour expiration period.
    44 - Data Lake Setting
    • IngestionFileRetentionHours defines the retention period in hours for saving ingestion and export files. Saving new files is disabled after the retention period expires. The existing temporary payload files are deleted after 24 hours.
    • Set CompressedPayload to false to avoid compressing the payload before sending it to Data Lake. This is helpful for validating that the payloads are correct.
    49 - Import Settings
    • Set IngestionFileRetentionHours to define the retention period in hours for saving ingestion and export files. Saving new files is disabled after the retention period expires. The existing temporary payload files are deleted after 24 hours.
    • Set the ImportFilesRetentionTimeStamp in hours.
    • Set the ImportStgTableRetentionTimeStamp in hours.
  3. Click Reload.
  4. To set a feature to active, select the feature, then specify 1 in the Active column field.
  5. Click OK.