Skip to content

Workspaces

MIKE OPERATIONS are using workspaces to hold data. In a PostgreSQL database a workspace is equal to a schema.

Every workspace (schema) in the MIKE OPERATIONS contains the same database definitions (tables, columns, functions etc.). This means that workspaces can be used for keeping data separated based on user defined locations, model types, area etc.

By default, the workspace "wokspace1" is created. If no other workspace is added, "workspace1" will be contain all data of MIKE OPERATIONS.

The workspace1 schema in the PostgreSQL PgAdmin

The workspace contains tables and functions used by MIKE OPERATIONS.

Associate users

In order to give a user access to a workspace, the user must be associated to a workspace.

Administrators can associate users, using "User associations..." on the context menu of the workspace node.

Select the user and the role of the user in the workspace.

  • Workspace_lead: Can add, edit and delete data.
    • Time Series Manager
      • Create new providers
      • Set time zone
    • GIS Manager
      • Create new providers.
      • Set workspace symbology for feature classes and rasters.
    • Scenario Manager
      • Can include all parameters on a scenario.
  • Workspace_member: Can add, edit and delete data.
    • GIS manager
      • Set private symbology.
  • Workspace_reviewer: The user can view data, but not add, edit or delete data.

Workspace Settings

MIKE Workbench supports a range of settings associated to the manager of MIKE OPERATIONS.

The settings are stored in the database in database in the database schema for the workspace.

The table below, lists the supported settings.

Setting key Category Description
LockedEntity DHI.Solutions.Core XML defining locked entities.
Some entities as spreadsheets and script storages can be locked.
Lock a spreadsheet selecting “Lock” from the context menu of the spreadsheet in the spreadsheet explorer.
It is not recommended to edit this setting, as it is automatically updated when locking and unlocking entities.
KeepAliveFrequency DHI.Solutions.Core Value defining the interval in seconds for updating the online users table in the database.
0=The user table is not updated (default).
This setting makes sure that the database manager utility can show active users.
Updating the user table will affect performance.
E.g. this can create a lot of traffic on the table and in case of a long-running applications such as a web-service in some situations cause a timeout and loss of connection.
The information of the table is also visible in MIKE Workbench in the lower left corner.
FastLineChartLimit DHI.Solutions.TimeSeriesManager The limit of time steps (default=25000) of a time series shown on a chart, making the chart being displayed as a fast line chart. Fast line charts will not show.
The Fast line chart is a high-performance chart used for large amount of time series data. Use this setting when performance when showing line charts is important.
Value: integer
ShowTimeseriesStatistics DHI.Solutions.TimeSeriesManager Value indicating whether time series statistics should be calculated when querying time series, so that the following statistics are shown in e.g. the Properties Window.:
  • Minimum
  • Maximum
  • Standard Deviation
  • Average
  • Missing Values
  • Count
  • Enabling this property will affect performance querying time series.
    Value: True/False
    TimeSeriesStorageType DHI.Solutions.TimeSeriesManager Setting indicating whether time series values should be saved in the database as rows in the “time_series_value” table or as blob data zipped into single row in the “Blob” table of the database.
    Note that Simulation output data will always be saved as Blob data.
    Values: Raw/Blob
    UseChartControlScale DHI.Solutions.TimeSeriesManager Value indicating whether chart axis should be adjusted when zooming in or out in the chart control.
    Value: True/False
    Tools DHI.Solutions.Tools XML defining persisted tool settings when saving settings of tools.
    The setting will contain settings for all persisted tools.
    It is not recommended to edit this setting, as it is automatically updated when persisting tools.
    MessageUpdateInterval DHI.Solutions.JobManager Interval in seconds for updating job status (raising an update event message) when running jobs.
    The value will affect the updating frequency of the job view.
    Value: integer
    WriteEventsToDatabase DHI.Solutions.EventManager Value indicating whether writing events to the database.
    Value: True/False