Basic configuration settings
The "Settings" tabulator of the configuration editor allows to edit the basic settings for a configuration. This includes timeouts, limitations or the automatic startup for a model.
To open the setting, click on the last tabulator "Setting" in the configuration edit.
The settings panel is a simple table with a number of properties, which can be edited inside the table. The following settings are available:
- Build stores immediatley: If this property is set to "true", all offline cubes of the model will be build immediately after the model is started and online. However, in the time span between the starting of a model and the successful build of a offline-cube, the cube may operate in the "adhoc" mode. The default setting for this property is "false".
- Enable adhoc queries: Since the 2.5 portal, users can perform adhoc-queries on models. But a model will only be visible for adhoc-queries if this property is set to "true". The default value is "false".
- Load timeout: This is the timeout for a model (in seconds) when it is initially loaded or synchronized. The default value is 1200 seconds.
- Lock-on-error time: Whenever the loading or synchronizing of a model fails, the usage of the model is disabled for the amount of time defined by this property (in seconds). This is, because a faulty model would, every time it is going to be used, try to load its dimensions and stores and unless it is fixed - users trying to use the model again and gain would cause a neccesary CPU load on the server. The default value is 300 seconds.
- Max cell count: There is a maximum size for queries and their results, because queries cannot be infinite complex. This property defines the maximum number of cells (rows multiplied by columns) a result must contain. If the number of cells of a result exceeds this limit, an error will be raised. The default value is 250.000 cells.
- Max result size: Like the "Max cell count", this property limits the maximum result size - but, in this case, the maximum number of rows or columns a result must own. The default value is 5000 rows or cells.
- Max selector size: Selectors accept anything for their "options" property, but the number of options must not exceed the limit defined by this setting, otherwise the amount of data transferred from the server to the browser could become too large. The default maximum is 5000 options.
- Max ToDoList size: The ToDo-List is the list of all facts (or coordinates) a query needs to load from the model-datasources. Even if a query looks quite small and simple, it (and its formulas) could need a large amount of data to perform. Because the size of the ToDo-List is related to the memory and CPU- usage of the query, there is a default limit of 250.000 entries for it. If a model only contains offline cubes, no ToDo-List is generated and this property is not used.
- Query timeout: This is a very basic property - no query must take longer than the number of seconds determined by this property to perform, other a "timeout" exception will be raised and the query is interrupted. The default timeout is 120 seconds.
- Shutdown-On-Idle time: Every model being started and online used memory and CPU time (because the system is synchronizing its dimension and stores). Therefore, a model, which hasn't been used longer than the seconds defined by this property, will be shut down and removed from memory. The default shutdown time is 86400 seconds (one day).
- Start model automatically: Frequently used models should set this property to "true" as the first user performing queries on it does not has to wait for the model to start up.
After you edited the properties and saved the configuration, the changes will be used immediately.
