System Registry Settings

Locks access to open object instances.
Available values:
0 (default) - write lock is enabled.
1- the object is locked separately for read and write operations, concurrent read access by multiple threads is possible.

Locks the entire session on processing requests. When the lock is enabled, requests to all objects within the session are executed one by one, otherwise they are executed concurrently, or individual locks are used (RWLockSlim).
Available values:
0 (default) - the lock is disabled.
1 - the lock is enabled.

Locks access to open dashboard instances. When the lock is enabled, read/write requests are executed consecutively, otherwise they are executed concurrently. The lock is also enabled for nested objects accessed using the dashboard moniker.
Available values:
0 (default) - the lock is disabled.
1 - the lock is enabled.

Enables gathering time and memory statistics for performance counters.
Available values:
IsOn - enables statistics collecting.
Memory - measures memory, spent on an operation.
Time - measures time of an operation.
Sql - gathers statistics of executing SQL queries to the repository database.
Cube - gathers cube execution statistics (building cube matrix according to the received selection).
Pivot - gathers statistics on working with pivots for building express report tables.
Sheet - gathers statistics on working with express report data tables.
Dim - gathers statistics on building dimensions used in various repository objects.
Rub - gathers statistics on building a time series database (getting series data according to the specified period).
Laner - gathers statistics on working of the table with the workbook data.
Report - gathers statistics on regular reports calculations.
RepSheet - gathers statistics on regular report sheets calculations.
RepDataIsl - gathers statistics on data areas calculations.
RepTabIsl - gathers statistics on relational data areas calculations.
Fore - gathers statistics on work of macros and event handlers in regular reports.
The IsOn checkbox is always specified, otherwise the statistics is not gathered. Other checkboxes that indicate, which counters must be used, are listed and separated with commas. Specifying only the IsOn checkbox equals to selecting all checkboxes.

Enables gathering time and memory statistics for performance counters.
Available values:
1 - gather statistics only for operations (times of execution, timing, and so on).
On - gather all statistics (on requests, on operations, memory/timing). This parameter is outdated, use the SamplingStr parameter instead.

An identifier of a repository, which contains system tables to store gathered statistics (Creating system tables to gather statistics is executed by means of the PP.Util.exe utility).

Period of inactivity (no requests), after which a session is closed. The period of time is set in seconds in the range [60, 127800]. When the value is set to -1, the timeout period is not limited. Default value is 1800.

Object state save and restore mode at state server. It is used with the StateServer settings group.
Available values:
Never or 0 (default) - do not save or load objects' states.
Yes or 1 - save on change, load if not available in the session.
Ever - save on change, and always load.

Generates consecutive session and object monikers.
Available values:
0 (default) - generate monikers via GUID.
Yes or 1 - generate consecutive monikers (for example, S1!M).

Sets a limit for the number of export results stored at the server with each object (for express reports and regular reports).
The default value is 0, but the number of saved results is not limited.

Maximum total size of loaded binary objects within the session. The size in indicated in bytes by default. If B, K or M Latin character is specified after the value, the value size is set in bytes, kilobytes, or megabytes respectively. The default value is 0, and the loaded volume is not limited.

Sets a limit to the number of repository database connections.
Available values:
0 (default) - do not reuse connections, always use the new one.
<0 - reuse without limit to the number (add a new connection if there are no free connections).
>0 - reuse with the limit to the number of connections specified in the parameter.

NOTE. The PoolMaxConnections parameter is outdated, it is kept to maintain compatibility with earlier versions of Prognoz Platform. Use the MaxConnections parameter in the registry subsection [HKLM\Software\Foresight\Prognoz Platform\9.0\PP\BIS\System\Pool].

This subsection is used to create parameters that affect operation of BI server application pool.

• MaxConnections. Maximum number of pool connections. The default value is 0, and the number of connections is unlimited.
• Strategy. Algorithm for discarding connections from the pool when it is required to free space for a new connection.
  Available values:
  LRU - algorithm of replacing the least recently used connections (LRU algorithm).
  Balance or Default - discarding based on the ratio number of open repositories/number of open database connections.
• UserMaxConnections. Maximum number of connections created with the same account. The default value is 0, and the number of connections is unlimited.
• RetryCount. The number of attempts of connection business check. Available value - [1; 1600], by default there are 160 attempts.
• RetryInterval. Interval between attempts in milliseconds. Available value - [10; 4000], by default, it is 400 milliseconds.

Additional subsections that contain parameters for specific repositories can also be created in the Pool subsection. A created additional subsection must have a unique name. It can be used to create the following parameters:

• Db. Parameters of user connection in the following format: {user name}:{metabase_identifier}@{DB_server}.
• UserMaxConnections. Maximum number of connections with the specified repository using the specified account.

NOTE. Connection pool parameters are applied, if the MaxConnections parameter value is greater than zero.

Parameters of connection to state server.

• Type. State server type. Depending on the software in use, the following values are available:
  MemCached (default).
  Redis.
• Host. Name or IP address of the state server (Localhost by default).
• Port. Number of the port to be used for connection (if the value is -1, the default port is used: 11211 for MemCached and 6379 for Redis).

This subsection stores private key of the security certificate. Parameters of this registry subsection are created at the runtime of PP.Util.exe application.

• Alg. Encryption algorithm.
• Data. Encrypted private key of the security certificate.
• Id. Security certificate identifier.
• Key. Security certificate GUID.

IMPORTANT. Parameters of this subsection must not be edited manually.

Parameters of objects for statistics gathering. In this subsection the user needs to create additional subsections with names matching repository identifier. A parameter can be created in each additional subsection:

• StatKeys. Keys of individual repository objects listed via comma, which will be used to gather information for performance counters.

Parameters or working via the OAuth protocol for user authentication at the third-party servers supporting this protocol. To set up, subsections with the names of OAuth servers are created inside OAuth. Each subsection has its own specific parameters. The following version offers the following OAuth server parameters:

• PPUserNameFormat. User name format (for example: "oa-tw-%s").
• consumerKey. Registered application key.
• consumerSecret. Secret code of the registered application.

Values specified in the ConsumerKey and ConsumerSecret parameters can be obtained after registering developed application at the required OAuth server. These parameters are necessary for the BI server to check and authenticate the corresponding user in the repository after Authentication at the OAuth server.

If the ConsumerKey and ConsumerSecret parameters are not specified, internal settings of the BI server are used; the OAuth server must contain registered application based on the Prognoz Platform 9 web application.

Parameters of SQL queries execution with the use of BI server. These parameters affect BI server work, if it is used as a client for access to DBMS.

In the current implementation the following checkbox is available:

• Allow. Permission for executing SQL queries via BI servers. Available values:
  0 (default) - SQL queries execution is forbidden.
  1 - SQL queries execution is allowed.

Parameters of working with development environment objects.

• Disallow. Indicates whether macros written in Fore/Fore.NET are executed by the operation ForeExec. If the value is 1, macros are not allowed, execution of the ForeExec operation is checked on the BI back end. If the value is 0, or parameter is missing, execution is checked by the web application with the value of the foreExec parameter in the PP.xml file.

The subsection, in which end points to remote servers are specified. Each point has a subsection with a unique name, for each point the following parameter is set:

• address. Actual address of a remote BI server.

The subsection contains repository settings. To set up, a subsection with a unique name, that is repository description identifier, is created inside Mbs. Each subsection has the Cubes subsections and the parameter:

• endpoint. Unique name of access point from Epts. The specified end point will be used to access cache data on creating repository cubes. If an empty string is specified as the name, the current BI server is addressed.

Cubes Subsection

The subsection contains settings for repository cubes, which are used to address data at remote BI servers. The subsection with a unique name is created for the setting, in which the following parameters are set:

• Keys. Cube keys separated with a comma, without spaces.
• endpoint. A unique name of the access point from the Epts section.

• Windows. C:\ProgramData\Foresight\Prognoz Platform\inmem_data\.
• Linux. /var/tmp/inmem_data.

NOTE. The operating system user who will work with cached data, must have read and write permissions for the specified folder.

Indicates whether aggregated data is stored in cache that can be obtained on aggregation of fixed dimensions. Aggregated data is stored in cache by default. To enable aggregated data caching, set the parameter to True, as this allows for the data to be quickly loaded and saves time avoiding repeated aggregate calculations on selection change, if source data was not changed. If data volume is too large, the first caching of aggregated data may take a long time and considerably increase the hard drive space used by cache.

The disk limit for variable cache part. If the parameter is not specified, the limit is 5120 Mb.