Switch when postprocessing

When a Model Server has started and loaded the model, it will start caching and postprocessing a number of predefined fields. In a model environment with multiple Model Servers, this setting controls when the execution of queries will be switched to the Model Server with the most recent data:

Lower bound for orders in past

The Model Server uses this lower bound to limit the number of closed orders that will be loaded into Angles for SAP after downloading them from SAP. Closed orders that are older than this number of months will not be loaded and will not be visible in Angles for SAP. The reference date for closed orders is the 'Realized Finish date'.

Keep in mind that:

Tolerance early

Set the number of workdays for the status Delivered early. Only when a closed order is delivered early more than this tolerance, the delivery reliability/service level is 'delivered early'.

Tolerance late

Set the number of workdays for the status Delivered late (when execution status = 'closed') and late (when execution status = 'open' or 'partially open')

Tolerance under delivery

Select the percentage of an order that is allowed to be underdelivered before the order can be closed.

Tolerance pollution

Set the number of workdays for the status Pollution (only when execution status = 'open' or 'partially open' and the order is late more than the tolerance, it is shown as 'pollution')

Unallocated quantity horizon

Set the horizon for ONC quantity to be allocated in X days.

Only requirements (sales orders, safety stock, planned independent requirements, stock requirements, etc.) that are planned within this horizon, are taken into account calculating the unallocated quantity within X days.

Safety stock demand factor

Define how much of the safety stock quantity is used as a requirement during the Supply/Demand Matching using the following formula:

Safety stock demand = safety stock x safety stock demand factor

Possible values:

To disable safety stock from being consumed, set this value to 0.

Values lower than 0, and greater than 1 are not allowed

Default value: 1.00

Safety stock demand lead time

Specify the number of days after which safety stock requirements become effective.

Default: 998

Restrict ONC for StockBatch Shelf life expiration date

Select how batches with an SLED are considered during the Supply/Demand matching.

There are two options:

Forecast requirements load mode

Select the forecast requirements load mode from the dropdown list.

Forecast requirements horizon active

Select the check box to activate the forecast requirements horizon.

Forecast requirements horizon

Specify the lower bound of the requirement date of Forecast and Independent requirements as X-days from now (=modeldate).

In SAP MD04, forecast/PIR's can be scheduled in the past. In MD04 then the available stock is first consumed by this forecast in the past. By using this parameter, the requirement of the forecast can be postponed to after X-days. As a result, the requirements date is then adjusted. The result is that first other requirements within this horizon (e.g. sales orders) consume the stock, and then the forecast.

Use SAP calendar

Select the check box to use the SAP calendar. One of the advantages of using the SAP Calendar is that workdays are calculated for each country taking holidays into account.

First day of week

Specify the first day of the week. This is used for week aggregations.

Log currency info

Select the check box to log the currency statistics. Logfiles are stored in the Model Server general log.

Standard SAP language key

Enter the SAP language key as a single character.

The SAP language key specifies the language in which you display texts, enter texts, print documents in SAP, etc.

SAP language keys are stored in SPRAS-T002.

Default is E (English).

Query cache size

Select the maximum number of queries in cache.

Minimum value: 10

Translation currency

Select the Server currency (main currency) for the model in Angles for SAP.

Standard exchange rate type

Enter the exchange rate type that is primarily used for currency conversion. The list is available in SAP table TCURV. Common values are 'M' and 'EURX'.

Fallback exchange rate type

Enter the exchange rate type that Angles for SAP should use for currency conversion if the Standard exchange rate type entered above is not a usable exchange rate type. The list is available in SAP table TCURV.

Common values are 'M' and 'EURX'.

Open order delivery status based on realized finish date

Select this check box in order to use the 'Realized Finish Date' of orders to determine the 'Delivery Status' of the order.

Max size of enumerated sets

The set of values for a specific field (the enumerated set) may be very large causing performance issues when retrieving all values.

To avoid this, specify the maximum number of possible values.

Default: 10000

Disabled enumerated sets

Use this setting to prevent unwanted enumerated sets to be created.

Default: MATNR

Syntax:

MRP relevant requirements types

Use this setting to force specification of MRP relevance for specific requirements in type/plant combinations. You can use this setting in combination with the field MRP irrelevant requirements types. Wildcards (*) are only supported for the plant part.

Syntax: <requirement type>/<plant>, for example 011/* or KSV/1000.

MRP irrelevant requirements types

Use this setting to force specification of MRP irrelevance for specific requirements in type/plant combinations. You can use this setting in combination with the field MRP relevant requirements types. Wildcards (*) are only supported for the plant part.

Syntax: <requirement type>/<plant>, for example 011/* or KSV/1000.

Consumption trend per day

Specify the number of days Angles for SAP uses to determine the consumption trend fields when the period indicator is D (day).

Consumption trend per week

Specify the number of weeks Angles for SAP uses to determine the consumption trend fields when the period indicator is W (week).

Consumption trend per month

Specify the number of months Angles for SAP uses to determine the consumption trend fields when the period indicator is M (month).

Consumption trend per fiscal period

Specify the number of days Angles for SAP uses to determine the consumption trend fields when the period indicator is P (fiscal period).

Split product hierarchy fields

Select this check box to split the different levels of the product hierarchy into separate fields.

Example: machine > pumps > displacement pumps

Default fiscal year variant

Specify the name of the fiscal year variant.

Show internal properties

Select this check box if you want to show the internal Angles for SAP fields. These fields are for internal use for instance when running an Export Compare.

Blocked PO is cancelled

Select how you want to treat blocked Purchase Orders.

Possible values:

Number of property caching threads

Specify the number of field caching threads used after the server is live. Increasing or decreasing the number of threads influences load time.

Minimum value: 0 (field caching is off)

Maximum value: 99

Model Server watchdog shutdown timeout (minutes)

If you shut down a model some processes may remain active preventing the Model Server from shutting down the model.

Specify the number of minutes before the Model Server watchdog stops all remaining processes.

Prevent property cycles

Select this check box to use cycle detection to determine field values. Cycle detection prevents recurring field calculations.

ONC Cycle detection maximum

Specify the maximum number of steps in order network dependencies that is used to determine if a cycle in dependencies exists.

Minimum value: 0

Default: 15

Maximum number of matrix nodes

Specify the maximum number of entries in a matrix.

Minimum value: 10000

Default:

Maximum value: 2000000

Maximum number of property concatenations

Select the maximum number of concatenations in a text field.

For instance, the ' Order numbers delivering orders' field consists of a concatenation of all order numbers of delivering orders. If the maximum number of field concatenations is set to 10, only the first 10 order numbers will be displayed in the resulting concatenated field. To achieve a situation where no limit is used, set this maximum to 0.

Minimim value: 0

Default: 10

Maximum number of rows to sort

Select the maximum number of result rows to be sorted by the Model Server. Setting a maximum will prevent the Model Server from slowing down. If you set this setting to 0, all rows will be sorted which will have a negative effect on performance.

Minimum value: 0

Default: 100000

Time-out running queries (minutes)

Running queries will be canceled after the specified timeout in minutes.

The Model Server can only execute a limited number of queries at the same time. To prevent long-running queries locking up the Model Server query engine, these queries will be automatically canceled.

Specify the number of minutes you want the system to wait before canceling running queries. If you select 0 (zero), no running queries will be canceled.

Minimum value: 0

Default: 0

Changes to this setting will take effect immediately (at runtime).

Maximum number of queries running parallel

This setting specifies the number of queries that the Model Server can execute simultaneously.

Minimum value: 1

Maximum value: 40

Default value: 10

Changes to this setting will take effect immediately (at runtime).

Log level

The log level determines the activities that are logged to file. The default level is Info. The following levels are available:

Max size of enumerated sets

Specifies the max number of possible values for a lookup (set) field. When a lookup-type-field has more rows in the lookup table than the number specified here, it will be represented as a regular string field and the lookup functionality will not be enabled.

The default value is 10,000.

DBMS

Select one of the following supported DBMS types:

Connection String

The connection details in order to connect to the DBMS. Please check the Installation Manual for requirements and/or the documentation from the DBMS vendor for full details.

An encrypted connection requires DMBS specific actions. Please check the documentation from the DBMS vendor.

Max query size

The maximum SQL query size in bytes.

Query statements larger than the default value of 10485760 (10MB) will be rejected by the Real-time Model Server. The default value leaves plenty of room for very complex SQL queries.

Maximum concurrent running queries

The maximum number of queries that are allowed to run at the same time on the DBMS. The default value is 1000. Use a smaller number to limit the load on the DMBS. When this threshold is met, the most recent queries will wait until some older queries are finished.

Maximum query preparation queue size

The size of the first internal waiting queue in the Real-time Model Server. The default value is 1000 queries. There is no need to lower this value. Use a larger value when users experience error messages that mention the preparation queue.

Maximum query execution queue size

The size of the second internal waiting queue in the Real-time Model Server. The default value is 1000 queries. There is no need to lower this value. Use a larger value when users experience error messages that mention the execution queue.

Default paging size

The default number of rows that is fetched when no page size is specified by the Application Server. You can leave this at its default value of 30.

Sorting Limit

This setting is used to limit the number of result rows that can be sorted by the Model Server, to avoid slowdowns.

Enter 0 to disable the limitation. The default sorting limit is 1000000.

Clear expired profile interval in minutes

If an authorization profile is not used for the configured amount of time, in minutes, then a background task in the Real-time Model Server will remove the profile. The Application Server will take care of re-creating the profile when needed. This setting will not impact users.

This setting enables a basic cleanup of the system which is necessary to provide a 24/7 service. You can enter any value between 1 minute and 24 hours. We recommend you to use the default value of 30 minutes.