The Dashboard Designer supports two data processing modes to perform data-related operations such as grouping and filtering.
In
server
mode the database server performs data-related operations. For
instance, when an end-user applies filtering to a dashboard item, the Dashboard
requests the required data automatically by sending a query containing a
corresponding SELECT statement with the specified WHERE clause. Server mode is
only supported for queries created entirely using the query builder tool
(described in the next section).
In
client
mode the workstation performs data-related operations. In this
mode, a compressed snapshot of aggregated data is loaded into a workstation/web
server memory. This reduces memory consumption and improves the speed of
client-side data shaping operations using several techniques: data compression,
various data grouping and multi-threading algorithms, etc.
By default, the pre-defined queries for the AM.Net data warehouse use server mode. The main advantage of server mode is that the database server performs data-related operations.
|
Note: Performance in server/client modes depends on multiple factors such as database structure, server workload, etc. To decide which mode to use for your custom queries, test both. |
|
To enable or disable server mode for the selected data source, use the Server Mode button located on the Data Source ribbon tab.
|
|
Server Mode Limitations
In server mode, the Dashboard does not have simultaneous access to bound data in its entirety. This imposes some limitations. Some calculated fields cannot be evaluated in server mode. The Median summary function is not supported in server mode.
