This chapter describes parameters unrelated to the Analytical Engine and lists their default values, if any. As indicated, most parameters are visible to all users; a few are visible only if you log in as the owner of the component.
This chapter covers the following topics:
To access these parameters within Business Modeler, click Parameters > System Parameters.
The parameters listed on the Database, System, and Worksheet tabs are in the sys_params table in the database.
The parameters listed on the App Server tabs are in the aps_params table in the database.
Parameter | Location | Default | Details |
---|---|---|---|
A | |||
AccountLockoutDuration | System | 60 | Represents the number of seconds a user is locked out of system after ‘AccountLockoutThreshold’ has been reached. Value = -1: the account will be locked out until administrator unlocks it; Value >= 0 : the account will be locked for number of seconds specified. |
AccountLockoutThreshold | System | -1 | Controls the number of failed login attempts by the user before locking user account.Value = -1 : the account will not be locked after failed login attempts. Value >= 0 : the account will be locked after failed login attempts according to this value. |
accumulatedOrUpdate | System | update | For integration, this parameter specifies how to handle existing data. Use one of the following values: accumulate: Add the new data to the existing data. update: Overwrite the existing data. |
active_forecasts_versions | System | 5 | Specifies how many forecast versions the Demantra database should store. Use a positive integer. |
AlignNumericSeries | System Parameters > Worksheet | right | This parameter controls alignment of numeric series only (i.e. not date or string series). Feasible values are (left, center, right). |
align_sales_data_levels_in_loading | Database | no | Visible only to owner. Specifies whether to maintain matrix information (combination information that is time-independent) within the sales_data table. If the matrix information is within the sales_data table, then the Analytical Engine can use that table directly instead of internally creating the sales_data_engine table. Use one of the following values: no: Do not adjust the sales_data table for direct use by the engine. yes: Adjust the sales_data table for direct use by the engine, so that the engine can run more quickly. This adjustment is made when data is added through loading, integration, or other mechanisms. If you set this parameter to yes, it is also necessary to rewrite some database procedures. For configuration steps, see “Reconfiguring the sales_data_engine Table” . |
applicationDateFormat | Application Server> App. Server | mm-dd-yyyy | The system date format. |
applicationDateTimeFormat | Application Server> App. Server | mm-dd-yyyy hh:mm:ss | The system date/time format, used where both a date and time are displayed. |
application_root | Provides support for a relative path to files or applications referenced by workflow steps in Workflow Manager. See Parameters Used as Arguments for a Method. | ||
ApprovalProcessScope | System | "0" indicates approval scope as Global to maintain backwards compatibility | Approval process refers to Forecast approval process, which in turn locks approved combinations. This parameter determines the scope of the approval process. When set to '0' the scope is said to be global and causes the Approval series to be added to every worksheet in the application, thus enforcing the approval process everywhere. When set to '1' the scope is said to be specific to SALES_DATA. In this case, approval process series is added to a particular worksheet only if other SALES_DATA series are selected in the worksheet, either explicitly or through a client expression. SALES_DATA series are also referred to as "BASE 0" series. |
AppServerLocation | System | Visible only to owner. Path of the directory that contains the Web Platform Server; this is the directory that contains the Web_inf subdirectory. | |
AppServerSupport | System | Do not change this parameter; this is for internal use only. | |
AppServerURL | System | http://localhost:8080/demantra | Visible only to owner. URL of the Web Platform Server. In some cases, external notifications, such as simulation and security changes, are missed because the Web server is overloaded. If you are using IIS and JRun, you can work around this by pointing all the external notifications to the internal JRun web server rather than to the IIS and JRun connector. To do so, set the AppServerURL parameter to use the default JRun port (8100). For example: http://frodo:8100/demantra See the Oracle Demantra Installation Guide. |
audit_history_length | System | 12 | Number of months of audit data to keep. Used by the CLEAN_LOG_TABLES procedure. |
AuditMailAddress | Application Server> DP Web | Visible only to owner. Mail address of the BCC (blind carbon copy) recipient of Demantra email messages. | |
AutoRunMode | Worksheet | false | Specifies whether Demantra automatically runs worksheets. This applies to all worksheets, in Demand Planner Web, Promotion Effectiveness, and Settlement Management as well as Demand Planner and Demand Replenisher. Use one of the following values: true: Demantra automatically runs any worksheet as soon as it is opened. It will not rerun automatically if changes are made to the data, for example, after clicking the update button. Also, it will not rerun automatically if changes are made in the wizard (apart from the Layout Designer). false: Demantra does not automatically run worksheets |
B | |||
bce_log_parm | Database | 100 | Ignore this parameter. |
BLEThreadPoolSize | Application Server> App. Server | 4 | Visible only to owner. Number of threads that the Business Logic Engine can use. |
BLETimeOut | Application Server> App. Server | 5000 | Visible only to owner. Length of time, in milliseconds, before an idle thread (of the Business Logic Engine) times out. |
buildNumber | Application Server> Collaborator | Read-only. Current build number of Demantra. | |
C | . | . | |
client.dropdownCache.limit | APS_PARAMS table | 50 | The number of dropdown lists for series that the client can cache in memory. This is an internal client implementation parameter. Client Dropdown Cache is implemented in an LRU manner so that when the limit is reached, the oldest entry will be deleted from the client cache memory. When the system needs to access this deleted dropdown list, it will be reloaded again from the server. Changing this parameter may have en effect on client memory consumption as well as on client performance. This parameter originally prevented an OutOfMemory exception on a client with huge dropdown lists. |
client.ssl.authentication | System Parameters > Application Server > DP Web | false | This parameter controls two-way (mutual) SSL authentication. |
client.uilimitations.maxcombs.ws | Application Server > Collaborator | 2000 | The maximum amount of combinations that can be retrieved for a single worksheet |
client.uilimitations.maxcells.ws | System Parameters > Collaborator | 100,000 | This parameter determines the maximum number of cells that will be retrieved in a single worksheet. |
client.uilimitations.maxcells | System Parameters > Collaborator | 300,000 | This parameter determines the maximum number of worksheet cells that will be retrieved for a single client machine. The value is based on the total number of cells in all open worksheets. . |
client.uilimitations.maxdiskspace | System Parameters > Collaborator | 200,000 | This parameter sets the maximum disk space that a single client machine will allow per worksheet (in KB). It should not be necessary to change this parameter unless there is a disk space issue. |
client.uilimitations.warning | Application Server > Collaborator | 80 | The percentage of the allowable maximum combinations, cells, or disk space at which to display to a warning message. For example, if maxcombs is 1000 and this value is 80, then a warning message will be displayed after loading 800 combinations (80% of max). If user has entered 0, it is ignored and the default value is used instead. If this value is 100, then no warnings will be displayed, since the error messages will occur at the same |
charsetEncoding | Application Server> DP Web | UTF-8 | The encoding character set for the XML. |
check_validity_installation | Database | yes | Visible only to owner. Specifies whether to check the validity of the installation. |
client.enableOpenNoteWithDoubleClick | Double-click within the worksheet table to specify whether users can access the notes dialog box by . Use one of the following values: 0 = false (users cannot use double-click to access this dialog box) 1 = true In any case, it is always possible to access this dialog box by using the right-click menu, as in Microsoft Excel. |
||
client.JREMaxMemory | Application Server> DP Web | Visible only to owner. Maximum amount of memory (in MB) that JRE can use. The Web worksheets (Demand Planner Web, Promotion Effectiveness, and Settlement Management) use JRE. | |
client.lookAndFeel | Application Server> DP Web | com.demantra.common.ui.lnf.DemantraLookAndFeel | Renamed in 7.0.2. Specifies the user interface style. Do not change this. |
client.MaxCombsLoadChunkSize | Application Server> DP Web | 20 | Visible only to owner. Maximum number of combinations to load each time the user chooses to rerun a worksheet. |
client.task.attachments.security.filetypes | Application Server > Collaborator | empty | Defines which file types are allowed as Task attachments. default value is empty - meaning all file types are blocked. Each added extension is separated by comma. Need to add a file extension to this parameter in order to allow it as a task attachment. Example: *.html,*.htm,*.xml . *.* - means all files are allowed (mainly for backward compatibility use). |
client.worksheet.privateAccessType | Application Server> DP Web | Visible only to owner. Specifies the default setting of the public/private option in the worksheet designer (used by the Web products). | |
ClientDDCacheCapacity | 10 | Specifies the maximum number of distinct drop-down lists per worksheet that any client should cache. These caches are cleared when the worksheet is closed. | |
collaborator.supportURL | APS_PARAMS table | URL of the Support link, relative to http://server name/virtual directory/portal/. This link is in the upper right corner of Collaborator Workbench. | |
collaborator.searchURL | APS_PARAMS table | URL of the Search link, relative to http://server name/virtual directory/portal/. This link is in the upper right corner of Collaborator Workbench. | |
company.name | Application Server> Workflow | Demantra | Name of your company; the Workflow Engine uses this string when it sends email messages when a workflow step fails. |
ColorCodingLevel | Worksheet | PE only; visible only to owner. Specifies the ID of the level that will be used to color code promotions. | |
CopiedMembersPerProcess | Database | Specifies the maximum number of members that can be copied in a single copy/paste process. | |
CopyPasteIntersect | Database | 0 | Specifies whether the total volume is preserved when an item is removed from a promotion group. This is a global parameter that applies to the entire application installation. This parameter works in conjunction with the Copy/Paste preservation Type setting on the series configuration when it is set to Volume Preservation. Valid values:
Important: Ensure that the proportionality of the volume series is set to the desired proportions so that volume is distributed correctly. It is recommended that you set the volume series to be proportional to itself in the series configuration. |
CTO_Enable_Worksheet_Calculations | System Parameters > System | Yes | This parameters controls whether planning percentages are automatically calculated when a worksheet is updated. |
CTO_Calc_PP_Forecast | System Parameters > System | No | This parameters controls whether to forecast planning percentages. |
CTO_HISTORY_PERIODS | System Parameters > System | 52 | This parameter specifies the number of history periods to use when calculating planning percentages based on the history of the options. |
CTO_PLANNING_PERCENTAGE_CHOICE | System Parameters > System | Existing | This parameters specifies the planning percentage to use when series Planning Percentage Choice calculates the dependent information in Forecast Dependent Demand. Setting this to "Existing" means to use the downloaded planning percentages from Oracle e-Business Suite that are in series Planning Percentages - Existing. The other option is to have Oracle Demantra calculate planning percentages based on history and forecast of options. |
D | |||
DatabaseEncoding | Application Server> DP Web | Visible only to owner. Encoding style for Oracle Web products. For a list of possible encoding sets, see http://java.sun.com/j2se/1.4.1/docs/guide/intl/encoding.doc.html. Use the “Canonical Name for java.io and java.lang API.” | |
DBConnectionTimeout | Application Server> App. Server | 5000 | The database connection time-out period, in milliseconds. |
DBDateFormat | Application Server> App. Server | {call pre_logon()} | The date format used in the database. |
DBIdleTimeOut | Application Server> App. Server | 1800000 | The connection idle time-out period, in milliseconds. |
DBName | Application Server> App. Server | The meaning of this parameter depends on the database used: For Oracle databases, this is the Oracle SID. See the Oracle Demantra Installation Guide. |
|
DBPassword | Application Server> App. Server | Password of the database user in which the Demantra data schema resides. See the Oracle Demantra Installation Guide. | |
DBPort | Application Server> App. Server | The port number of the database server. See the Oracle Demantra Installation Guide. | |
DBType | Application Server> App. Server | oracle | Indicates the type of database that Demantra is using. |
DBUser | Application Server> App. Server | . | Database user in which the Demantra data schema resides. See the Oracle Demantra Installation Guide. |
Debug | Worksheet | false | Applies to the desktop productVisible only to owner. Specifies the debug mode, if any, in which the Demantra application server should run. In debug mode, the application server writes debug messages to the console. Use one of the following values: false (0): Do not write any debug messages at all. true (1): Write debug messages from all possible causes. Use this setting sparingly, because it generates a large number of messages.sql (2): Write SQL syntax from all database interactions. You can then copy and execute the SQL statements outside of the application to verify that desired results are achieved by the statements. mem (3): Write messages related to memory usage. Specifically it provides information about memory consumption at various stages of the application. You can use this information to find memory leaks. init(4): Write messages related to object initialization. This information helps you see which objects come into being as the application is working on various tasks. synch (5): Write notifications related to synchronization. Use this information to see if the various parts of the application are synchronized with one another. It is often useful to eliminate the issue of synchronicity as the source of whatever problem is being investigated. update (6): Write messages related to data updates, so that you can see what updates are passing through the system. If you are updating but do not see expected results, use this debug setting to verify first that the update has passed through in the correct way through the internal libraries. ts; visible only to owner. Specifies whether Demand Planner or Demand Replenisher runs in debug mode. In debug mode, these products pop up debug windows when errors occur. |
DebugMode | Application Server> App. Server | off | . |
DefaultContentSecurityAccess | System | Specifies the default security access per member, as seen in the Security menu options. Use one of the following values: 1 (no access) 2 (read access) 3(read/write access) 4 (full control; includes delete access) |
|
DefaultLevelSecurityAccess | System | Specifies the default security access per member, as seen in the Component menu options. Use any of the values listed for DefaultContentSecurityAccess. | |
DeskTopNotification | System | http notification | Applies to the desktop products; visible only to owner. Use one of the following values: http notification db notification |
dir.onlineHelp | Application Server> Collaborator | URL of the Help link, relative to http://server name/virtual directory/portal/. This link is in the upper right corner of Collaborator Workbench. | |
DSMAllShipDateDifference | System | DSM only. Specifies the window of time that Demantra uses to search for a promotion that matches a given settlement. Express this as the number of time buckets between the promotion end date and the deduction date. The promotion end date is given by the series specified by the DSMPEShipDateSeries parameter. | |
DSMOICheckProduct | System | Not used. | |
DSMOIPercentDifference | System | DSM only. The maximum percent difference (of monetary amount) permitted when matching an off-invoice settlement to possible promotions. | |
DSMOIShipDateDifference | System | DSM only. Specifies the window of time that Demantra uses to search for a promotion that matches a given off-invoice settlement. Express this as the number of time buckets between the promotion end date and the settlement date. The promotion end date is given by the series specified by the DSMPEShipDateSeries parameter. | |
DSMPEOIAmountSeries | System | DSM only. Specifies the ID of the series that stores the monetary off-invoice amounts for the promotions. This series must have an aggregating server expression. | |
DSMPEShipDateSeries | System | DSM only. Specifies the ID of the series that stores the ship dates of the promotions. This series must have an aggregating server expression. | |
DSMPromotionBudgetSeries | System | DSM only; parameter is visible only to owner. Specifies the ID of the promotion budget series to which adjustments will be made when settlements are matched to a promotion. | |
DSMWriteOffThreshold | System | DSM only. Specifies the monetary amount below which Demantra automatically writes off a settlement. See “Configuring DSM” for information on configuring the writeoff process. | |
E | |||
EnableIncrementalLoading | System | true | Enables the Demantra incremental loading feature, for faster worksheet reruns. There is no user impact apart from performance. |
EngineBaseUrl | System | http://server:port/EngineManager/ | Parameter defining path to web-based analytical engine. Server:port should be modified to match application server details |
EnginePlatform | System | 1 | Parameter indicates whether engine will be executed on Linux (1=default) or Windows (0) environment |
EnableWorksheetCaching | System | true | Specifies whether Demantra can cache the Web worksheets. |
execution.shell | Application Server> Workflow | Applies to the Executable Step. This parameter specifies any prefix that is needed in order to run executable steps. For example, you may need to specify the following for Unix: "./" (i.e. dot slash). | |
ExternalLogoutURL | System | none | The URL that points to the landing page after logging out from a remote system, such as the Oracle E-Business Suite. |
F | |||
FillValueExportToExcel | System Parameters > Worksheet | no | This parameter controls whether all rows or columns are labeled with combination information versus one label only at first row of data per combination. Enabling this parameter allows the user to more easily create reports, such as pivot tables, within Excel. Values (yes = fill all rows or columns with combination details; no = display combination information only once) |
FIRSTDAYINWEEK | Database | monday | First day of week to use when binning sales data into base time buckets. |
format.dates.longFormat | Application Server> Collaborator | mm/dd/yy hh:mm:ss a | Long date format. |
format.dates.shortFormat | Application Server> Collaborator | mm/dd/yy | Short date format. |
G | |||
GatherStatisticsThreshold | Worksheet | 2000 | For a temporary table, minimum number of rows needed in order to automatically run Analyze Table. Used by the ANALYZE_TABLE_TMP procedure. |
general.copyright | Application Server> Collaborator | Copyright Demantra; 2005 | Visible only to owner. Copyright notice displayed in lower left of the Collaborator Workbench window. |
general.homepage.title | Application Server> Collaborator | My Demand Collaborator | Title of the Collaborator Workbench home page, as used within the Collaborator Workbench title bar. |
general.title.text | Application Server> Collaborator | Demand Collaborator | Title of the browser window when it displays Collaborator Workbench. |
general.userList.tasks | Application Server> Collaborator | true | Not used. |
general.userList.whoisonline | Application Server> Collaborator | true | Specifies whether the Who's Online module is displayed. |
general.userList.worksheets | Application Server> Collaborator | true | Not used. |
Graph.MaxLabelWidth | Application Server> Collaborator | 20 | Maximum width of labels in graphs in Collaborator Workbench, Demand Management, and Promotion Effectiveness. If a label is longer than this width, the last characters of the label are represented by three periods (...). |
HintDisplayTime | Parameters > System Parameters > DP Web | 4 seconds | Global parameter controlling duration of hint visibility when user places mouse over any object that supports tooltips, measured in seconds. Set to -1 to display the hint as long as the mouse is over the object. Set to 0 if you do not want to display hints. |
ImportBlockSize | Application Server> App. Server | 5000 | The number of rows for each commit, used during import. |
indexspace | Database | TS_FORECAST_X | Database table space that stores the forecast table indexes, as specified during installation. |
indicator.synchronizeSalesData | Application Server> Collaborator | yes | Controls the synchronization of the general level indicators in the sales_data table. |
initial_param | Database | 20M | Default initial size of system table spaces. See also next_param. |
InsertDateTimeFormat | Application Server> App. Server | MM-dd-yyyy 00:00:00 | The date-time format that Demantra uses when writing to the database. When you enter dates in a worksheet, Demantra converts them to this format before writing them to the database. |
Insertmissingvalues | Worksheet | yes | Not used. |
J | |||
L | |||
Legend.MaxLegendItemWidth | Application Server> Collaborator | 30 | Maximum width (in characters) of the legend in a graph-type content pane in Collaborator Workbench. If any lines of the legend are too longer, the last characters of those lines are represented by three periods (...). |
License.ExpirationMessage | Application Server> App. Server | Your Security License File has expired. Please contact support. | Visible only to owner. Message shown when the system license has expired. |
LinkedDataAutoCopy | System | 1 - continue copy | Specifies whether to continue linking source and target data after initial link. If active, the linking process continues until the launch date is reached. Possible values are: (0) do not copy or (1) continue copy. |
LoadDataStop | System | yes | Specifies whether Demantra should stop loading data when it finds an error in the data. |
LockTimeout | Database | 10 | Specifies the period (in seconds) between killing a database session and releasing the lock for that session. |
log.history | Application Server> Workflow | 1 | The number of days for which workflow history is kept. |
M | |||
Application Server> DP Web | on | Specifies whether Demantra is enabled to automatically send email, as specified within a workflow. Use one of the following values: yes: no: You can set this parameter during installation or later. See the Oracle Demantra Installation Guide. |
|
mail.outgoing.server | APS_PARAMS table | ||
mail.server | Application Server> Collaborator | Name or IP address of the SMTP mail server that Demantra should use when it sends email. For example: mayflower.demantra.net You can set this parameter during installation or later. For details, see the Oracle Demantra Installation Guide. |
|
mail.strings.from.system | Application Server> Workflow | See details. | Visible only to owner. Specifies the title of the sender of Demantra email messages, for example “Demantra Solution Manager”. Default: Demantra Solution |
mail.strings.internalerror.message | Application Server> Workflow | See details. | Text of email message sent in case of internal error. Default: Internal error: please check database and network connections |
mail.strings.internalerror.subject | Application Server> Workflow | See details. | Subject of email message sent in case of internal error. Default: Workflow internal error |
mail.strings.processfailuresubject | Application Server> Workflow | See details. | Text of email message sent by a Fail-To-Execute Step. Default: Error in Process Execution |
mail.strings.processterminated | Application Server> Workflow | See details. | Message sent when a process is terminated. Default: The following process is terminated |
mail.strings.recovery | Application Server> Workflow | See details. | String included in recovery email message. Default: Please handle recovery for the following process: |
mail.strings.taskfailuresubject | Application Server> Workflow | See details. | Subject of email message sent by a Fail-To-Execute Step. Default: Workflow process has failed |
mail.strings.taskstimedoutsubject | Application Server> Workflow | See details. | Message sent when a task is timed out. Default: Task(s) timed out in workflow |
mail.strings.timeout.group | Application Server> Workflow | See details. | Message sent when a task is timed out in a group step. Default: Treatment period for this task(s) was finished and one or more of the group members haven't responded. \nThe process moved to alternative treatment. |
mail.strings.timeout.user | Application Server> Workflow | See details. | Message sent when a task is timed out in a user step. Default: Treatment period for this task(s) was finished and the process moved to alternative treatment |
mail-password | APS_PARAMS table | Visible only to owner. Password of the administrator account; this is also usually the network username of the administrator. You can set this parameter during installation or later. For details, see the Oracle Demantra Installation Guide. |
|
mail_recipient | System | no send | Specifies where to send a message when error is found during data load. Use one of the following values: no send send to administrator and changer send to administrator |
mail-username | APS_PARAMS table | Visible only to owner. Username of the administrator account from which Demantra sends email; this is usually the network username of the administrator. For example: admin You can set this parameter during installation or later. For details, see the Oracle Demantra Installation Guide. |
|
mailAddress | Application Server> DP Web. | The email address of the administrator email account. For example: demantra-admin@acme.com You can set this parameter during installation or later. For details, see the Oracle Demantra Installation Guide. |
|
mailProtocol | Application Server> DP Web | mail.smtp.host | Server for sending email. Demantra supports only SMTP servers. |
ManualRefreshAsDefault | System | true | Visible only to owner. Specifies the default setting of the Refresh Type caching option in the worksheet designer. This parameter has an effect only if worksheet caching is enabled (through EnableWorksheetCaching). Also see WorksheetCachingAsDefault. |
MatrixCombs | Read-only. Indicates the number of lowest-level combinations in the mdp_matrix table. For use in helping you set SimMaxSize and SimWarnSize. | ||
MaxAvailableFilterMembers | Specifies the maximum number of members that can be retrieved in the worksheet filter screen. If the user selects more members than allowed, a message asks the user to add further filtering. This limit is also applied to dropdown lists for series and attributes. |
||
MaxBackgroundLoad | Application Server> DP Web | 20 | Maximum number of worksheets that can be loaded in the background. |
MaxDBConnections | Application Server> App. Server | 50 | The maximum number of database connections for the Demantra database user. Recommended: the number of concurrent users multiplied by 2. |
max_fore_sales_date | System | Visible only to owner; read-only. The latest possible forecast sales date. | |
max_initial_members | Worksheet | 100 | Applies to Member Management in Demand Planner. Specifies how many members to display immediately when clicking on a parent member. |
max_records_for_commit | Database | 10000 | The number of records that Demantra will insert into the database before performing a COMMIT operation. If you increase this number, the insertion will run more quickly, but you risk losing all uncommitted records in case of a crash. |
max_sales_date | Worksheet | The latest sales date loaded as history in the system. | |
MaxSaleVal | System | 999999999 | Maximum allowed sale value within Demantra, for any possible unit of measure. |
MaxUpdateThreads | Application Server> App. Server | 2 | The maximum number of threads to use for the update mechanism. Must be an integer and should equal the number of database CPUs plus one. |
MinDBConnections | Application Server> App. Server | 4 | The minimum number of database connections for the Demantra database user. |
min_fore_sales_date | System | Visible only to owner; read-only. The earliest possible forecast sales date. | |
min_sales_date | System | Earliest possible sales date. | |
mix_max_members | Worksheet | 50 | The maximum number of members that a user will be allowed to work on. |
N | |||
navBarContentProvider.addNewContentLink.Text | Application Server> Collaborator | New | Text of the New link, which is shown at the top of the Contents menu in Collaborator Workbench. |
navBarContentProvider.interpriseContent.text | Application Server> Collaborator | InterpriseContent | Not used. |
next_param | Database | 20M | Incremental amount of storage that is added to a table space when more space is needed. See also initial_param. |
NpiUseWsFilter | Worksheet | No | Specifies whether or not worksheet filters are used when executing the Find Similar, Edit Lifecycle Definitions and Remove Combinations workflows. Choose one of the following values: No (0): Do not apply worksheet filters. Yes (1): Apply worksheet filters. |
O | |||
OpenWithContext | Worksheet | Selected member | Specifies the default setting of the Open With Context setting of the worksheet designer. Choose one of the following values: Selected member (filters only to the selected member) Selected context (filters to the selected member and any additional context where the user clicks within the Members Browser) |
P | |||
PasswordHistoryCount | System | 5 | Represents the number of historical passwords which cannot be used when resetting the password. Value = -1: do not restrict reuse of historical passwords; value > 0 : restrict password reuse to specified number of passwords. |
PasswordResetTime | System | -1 | Frequency with which passwords must be reset, measured in days. Warnings will be sent within 10 days of the reset deadline. Users who do not reset passwords prior to expiration will require administrator support to regain access to the application. Default reset interval is set to -1 to emulate no reset. Otherwise, should set to number of days between resets. |
PasswordRulesEnforcedGlobal | System | No | Controls whether the system enforces password policies. For details, see Password Policies. |
parts_factor_source | System | bom_factor.factor | Visible only to owner. Table and column of BOM factor. |
pct_increase_for_analyze | Database | 10 | Visible only to owner. Percentage of data increase for a given table, beyond which Demantra automatically increases the table size. |
phase_in_out | System | 1 | Visible only to owner. |
portalVersion | Application Server> Collaborator | Read-only. Current version number of Demantra. | |
PromoDefaultSpan | Worksheet | PE only; parameter is visible only to owner. Specifies the default length of time for promotions created within a worksheet. | |
PromoDefaultStart | Worksheet | start date of the worksheet | PE only; parameter is visible only to owner. Specifies the default start date for promotions created within a worksheet. Use one of the following values: today (0) last loaded sales date (1) start date of the worksheet (2) |
ProportDefaultEngineProfile | Database | 0 | Engine profile to be used when executing the proport procedure as part of data load or update process. 0 (default) points to the base engine profile. Value should be modified if a different engine profile is to serve as basis for proportion calculations. |
Q | |||
Query.MaxCombinations | Application Server> Collaborator | 10 | Maximum number of combinations that can be displayed in a graph-type content pane in Collaborator Workbench, when you display a single series plotted for multiple combinations. The user receives an error if a content pane contains more than this number of combinations. |
Query.MaxSeries | Application Server> Collaborator | 10 | Maximum number of series that can be displayed in a graph-type content pane in Collaborator Workbench. The user receives an error if a content pane contains more than this number of series. |
Query.TopBottom.MaxCombinations | Application Server> Collaborator | 30 | Maximum number of combinations that can be displayed in a Collaborator Workbench content pane that contains a stacked bar chart or pie chart. The user receives an error if a content pane contains more than this number of combinations. |
QueryMechanisimTimeOut | Application Server> App. Server | 5000 | Visible only to owner. The time-out period for the query notification listener, in milliseconds. The APS uses this parameter. |
QueryRunMaximumThreadUser | ds.ini | ||
R | |||
Rebuild_Sales_Table | Database | yes | Oracle only; visible only to owner. Controls the REBUILD_TABLES procedure. Use one of the following values: yes: The REBUILD_TABLES procedure rebuilds the sales_data table. no: The procedure ignores this table. |
ReceiveCollaborationMessages | Worksheet | true | Applies to the desktop products. Specifies whether desktop users should receive messages when data is changed. Use one of the following values: yes: Users receive messages when the currently displayed data has been changed by another user (who is logged onto either the desktop or the Web products). no: Users do not receive these messages. This parameter has no effect on the Web products. |
RefreshTimer | Worksheet | 10 | Applies to the desktop products. Idle event interval in seconds. |
RestartOnFailureInterval | System | 20 | Ignore this parameter. |
Run_full_matrix_proport | Database | no | Visible only to owner. Specifies whether to run the proport mechanism on all the item-location combinations. Use one of the following values: all combinations: Run proport on all combinations in mdp_matrix. only flagged combinations: Run proport only on the combinations that have prop_changes=1. all new combinations (2), run proport on all combinations that have new_member=1. |
RunProportInMdp_add | Database | yes | Visible only to owner. Specifies whether to call the proport mechanism from the MDP_ADD procedure. Use one of the following values: yes: The MDP_ADD procedure runs the proport mechanism. no |
S | |||
sales_data_engine_index_space | Database | TS_FORECAST_X | Database table space that stores indexes for the sales_data_engine table, as specified during installation. |
sales_data_engine_space | Database | TS_FORECAST_ | Database table space that stores the sales_data_engine table, as specified during installation. |
SecurityFromSystem | Worksheet | false | When starting the system it will try to log as the O.S user with password “system” |
server.generalurl | Application Server> Workflow | URL for the workflow server, not including the portal/workflow directory. | |
Server.SessionExpiration | Application Server> Collaborator | 1200 | Specifies how long (in seconds) before an idle Collaborator Workbench session expires. Does not affect worksheet sessions. |
ServerName | Application Server> App. Server | Database server name (host machine or IP address on which database resides). For example: @wysiwyg See the Oracle Demantra Installation Guide. |
|
SettlementLocationExtension | DSM only. Specifies the internal identifier of the location-type level with which settlements should be associated. This generally represents the entity that is being billed or refunded. To set this parameter, use the installer. See the Oracle Demantra Installation Guide. |
||
SettlementProductExtension | DSM only. Specifies the internal identifier of the item-type level with which settlements should be associated. This generally represents a promoted product or a product group. To set this parameter, use the installer. See the Oracle Demantra Installation Guide. |
||
show_legend | Worksheet | no | Applies to the desktop products. Specifies whether to display the display the legend in new worksheets. |
SimMaxSize | System | 0.1 | Specifies the threshold size of a simulation that is too large to run. If a user tries to perform a simulation of this size, Demantra displays a message and does not attempt the simulation. Specify this as a percentage of the total number of combinations in the mdp_matrix table. Also see SimWarnSize. The MatrixCombs parameter displays the number of combinations currently contained in this table. |
SimWarnSize | System | 0.03 | Specifies the threshold size of a simulation that is large enough to trigger a warning message to the user. Specify this as a percentage of the total number of combinations in the mdp_matrix table. Also see SimMaxSize. Note that the MatrixCombs parameter displays the number of combinations currently contained in this table. |
simulationindexspace | Database | TS_FORECAST_X | Database table space that stores indexes for the simulation tables, as specified during installation. |
simulationspace | Database | TS_FORECAST | Database table space that stores the simulation tables, as specified during installation. |
SortMemberbyCodeinFilter | Application Server> App. Server | 1 | Controls the order in which the Worksheet Manager displays the level members on the filter screen. |
sortSeriesByDisplayOrder | Application Server> App. Server | 1 | Controls the order in which Worksheet Designer displays series If sortSeriesByDisplayOrder is 1, display the series by display_order. If sortSeriesByDisplayOrder is 0, display the series alphabetically. |
SPF_Default_Profile | System | 1 | Default profile list for SPF Failure Rate calculation. If listing more than one profile ID, separate with commas. |
SPF_Enable_Worksheet_Calculations | System | Yes | Automatically calculates planning percentages during worksheet updates. Updates to relevant series trigger BOM tree propagation if set to yes.
Note: Enabling this parameter may negatively affect worksheet performance. When set to No (disabled), propagation occurs when the user modifies worksheet values. However, the new planning percentages are only displayed after the end user reruns the worksheet. |
SPF_History_Periods | System | 26 | Periods of history used for to calculate planning percentages. |
START_OR_END_WEEK | Visible only to owner. Specifies whether data is aggregated forward or backward in time, when loaded into Demantra through any Demantra loading mechanism. | ||
StartUpdateQueue | Application Server> App. Server | yes | Visible only to owner. Specifies whether to start the manual update listener. The APS uses this parameter. |
SynchRangeStart | System | 1/1/1900 will be automatically substituted by first period in future horizon. | Controls beginning of date range to be copied from GL data to Sales_Data. |
SynchRangeEnd | System | 1/1/1900 will be automatically substituted by last period in future horizon. | Controls end of date range to be copied from GL data to Sales_Data. |
SynchDefaultProfile | System | 1 | The default profiles for GL synchronization. (Example default profiles: “1”, “2”, “1,2,3”, “1,3”) |
SynchEnableBatch | System | Yes | Enable GL synchronization in batch mode, if set to NO GL synchronization will not copy data when called. |
SynchEnableAdHoc | System | Yes | Enable ad hoc GL synchronization, if set to NO ad-hoc synchronization will not copy data when called. |
sysadmin_email_address | System | Not used. | |
sysadmin_password | System | Not used. | |
sysadmin_username | System | Not used. | |
SystemStatus | Database | enabled | Read-only. Indicates the status of the system, according to the sessions monitor: enabled read-only mode disabled |
T | . | . | . |
tablespace | Database | TS_FORECAST | Database table space that stores the system tables, as specified during installation. |
task.default.option | Application Server> Collaborator | Select Option | The default option for a selection task. |
task.message.length | Application Server> Collaborator | 254 | Maximum length of task description field in characters. |
task.message.taskadded | Application Server> Collaborator | A task has been added to your tasklist | Do not change. |
tasklist.showTimeoutTasks | Application Server> Collaborator | yes | Specifies whether Collaborator Workbench should show tasks that are past their due date. Possible values are 1 (show tasks that are overdue) and 0 (don't show such tasks). Default value is 1. |
threadpool.attributesUpdate.per_comb | Maximum number of threads that a single thread can use. | ||
threadpool.attributesUpdate.size | Maximum number of allowed threads for this thread pool. This should be less than MaxDBConnections. | ||
threadpool.attributesUpdate.timeout | Idle time-out period. This specifies how long (in milliseconds) a thread is left unused before it is ended automatically. | ||
threadpool.copy_paste.per_process | Application Server> App. Server | Visible only to owner. Maximum number of allowed threads for the copy/paste mechanism in any given process. Must be an integer and should be less than MaxDBConnections. | |
threadpool.copy_paste.size | Application Server> App. Server | Visible only to owner. Maximum number of allowed threads for the copy/paste mechanism. Must be an integer and should be less than MaxDBConnections. Also be sure to leave room for system processes. | |
threadpool.copy_paste.timeout | Application Server> App. Server | Visible only to owner. Idle time out period. This specifies how long (in milliseconds) a copy/paste thread is left unused before it is ended automatically. | |
threadpool.default.size | Application Server> App. Server | 10 | Visible only to owner. Not used. |
threadpool.default.timeout | Application Server> App. Server | 10000 | Visible only to owner. Not used |
threadpool.level_method.block | Application Server> App. Server | wait | Visible only to owner. Specifies how the level methods should access this thread pool. Use one of the following values: wait: Wait for a free thread. abort: Do not wait for a free thread. |
threadpool.level_method.size | Application Server> App. Server | Visible only to owner. Maximum number of allowed threads for the level method mechanism. Must be an integer and should be less than MaxDBConnections. Also be sure to leave room for system processes. | |
threadpool.level_method.timeout | Application Server> App. Server | Visible only to owner. Idle time out period. This specifies how long (in milliseconds) a level method thread is left unused before it is ended automatically. Recommended setting: 300000 (5 minutes) |
|
threadpool.query_run.size | Application Server> App. Server | Visible only to owner. Maximum number of allowed threads that Demantra can use to run a worksheet. If this number is missing or negative, the worksheet run mechanism does not use threads. Must be an integer. Should be less than MaxDBConnections. Also be sure to leave room for system processes. |
|
threadpool.query_run.timeout | Application Server> App. Server | 180000 | Visible only to owner. Idle time out period. This specifies how long (in milliseconds) a worksheet thread is left unused before it is ended automatically. This parameter is ignored if threadpool.query_run.size is negative or missing. |
threadpool.update.size | Application Server> App. Server | 10 | Visible only to owner. Maximum number of allowed threads for the update mechanism. Must be an integer and should be less than MaxDBConnections. Also be sure to leave room for system processes. |
threadpool.update.timeout | Application Server> App. Server | 10000 | Visible only to owner. Idle time out period. This specifies how long (in milliseconds) an update thread is left unused before it is ended automatically. |
Timeresolution | System | week | Read-only. The base time unit. That is, the smallest possible unit of time visible in Demantra: day, week, month |
Read-only. The base time unit. That is, the smallest possible unit of time visible in Demantra: day, week, month | |||
TrendDampPeriod | System | 0 | The number of time periods used in application of residual dampening. The last group of periods is not dampened with previous groups dampened in an exponential manner. When set to 0 no dampening is applied. |
U | |||
update_dead_comb | Worksheet | "1" | The parameter determines whether the update mechanism saves information to dead combinations. If set to "1", dead combinations are allocated forecast. If set to "0" dead combinations are not allocated forecast. In this latter case, if all combinations that are part of an update are dead, the updated values will be lost. |
update_units_by_items | Database | by items | Specifies how to update units for the INSERT_UNITS procedure. Use one of the following values: by items: The procedure operates item by item. This is faster but less accurate. by combinations: The procedure operates on individual combinations. This is slower but accurate. |
UpdateAudit | Database | no | Visible only to owner. Specifies whether the MANUALS_INS_INTEGRATION procedure updates the audit tables. This procedure is used when data is imported at an aggregated level. |
UpdateQueueTimeout | Application Server> App. Server | 5000 | Visible only to owner. The time-out period for the manual update listener, in milliseconds. The APS uses this parameter. |
UpdateThreadTimeout | Application Server> App. Server | 5000 | The time-out period for the update threads, in milliseconds. The APS uses this parameter. |
UseDateRangeMatrix | This parameter controls whether the worksheet mechanism uses internal data structures can improve the performance of worksheets that include promotions. You can control whether worksheets use these structures; the system uses them automatically for other purposes. If you enable this option, the largest benefit occurs in cases where promotions are long (and have many rows of data). This affects only worksheets that include general levels that have population attributes. |
||
useGLExceptions | Application Server> Collaborator | true | Visible only to owner. Specifies whether Demantra respects worksheet exceptions that refer to promotion series. Use one of the following values: true: Demantra does consider worksheet exceptions that refer to promotion series. This affects the behavior of the worksheet and of the BLE Step. The worksheet behavior, however, is not intuitive; the Members Browser displays all the combinations. When the user clicks on a combination that does not meet the criteria, the worksheet then displays a message saying that the combination is empty. false: Demantra ignores worksheet exceptions that refer to promotion series. This means that such exceptions are useless, but the worksheets behave more intuitively. |
UseItemsAggri | Worksheet | no | Specifies whether to use data from the branch_data_items rather than the usual table. The branch_data_items table aggregates data by item, for improved performance in worksheets or within the Business Logic Engine. You can use this table only when you do not need to view specific locations or filter by location. Use one of the following values: yes: Whenever possible, Demantra uses data from the branch_data_items. In this case, the first time the engine runs, there will be a long update of all rows in sales_data. Also make sure that the DYNAMIC_SYNC procedure runs periodically to keep the branch_data_items table current. no: Demantra uses the usual tables. |
UserListContentProvider.commontitle | Application Server> Collaborator | Who's Online | The title of the Who's Online pane in Collaborator Workbench. |
UserTitleContentProvider.TimeToSleep | Application Server> Collaborator | 10000 | To update the Who's Online pane in Collaborator Workbench, Demantra polls at regular intervals to see which users are online. This parameter specifies the length of time (in milliseconds) between successive polls. |
V | |||
VisibleUserName | User Name | Determines how a user is identified in Demantra. This parameter is only available to administrators. Possible values are: User Name First Name Last Name |
|
. W |
|||
workflow.group | Application Server> Workflow | Comma-separated list of groups whose users are authorized to log into the Workflow Editor. Use the group names as specified in the Business Modeler. In order to log into the Workflow Editor, these users also must have System Manager permission level. See “Providing Access to the Workflow Editor”. |
|
worksheet.data.comb.block_size | Application Server > App. Server | 1 | Indicates whether we want to retrieve all WS Combinations in one sql (value=0) or with a block of Combinations in the sql (value>0). |
WorksheetBeanContentProvider. memberCombinationsLimit | Application Server> Collaborator | 4 | Maximum number of combinations in a worksheet. |
WorksheetCachingAsDefault | System | Specifies the default setting for the Cache Worksheet Data check box in the worksheet designer. This parameter has an effect only if worksheet caching is enabled (through EnableWorksheetCaching). Also see ManualRefreshAsDefault. | |
WorksheetDefaultDateChoiceMethod | Worksheet | relative to today | Visible only to owner. Controls the default start date for Web worksheets, as seen in the worksheet designer. Use one of the following values: relative to today (0) relative to last loaded sales date (1) |
WorksheetDefaultSpan | Worksheet | 104 (for a weekly system) | Visible only to owner. Specifies the default length of time for a Web worksheet, in base time units. Must be an even number, 2 or greater. |
The message that a user receives when he or she receives a task. Title of the "interprise" content link. Specifies whether the My Tasks module is displayed. If you disable this module, Collaborator Workbench also removes related options such as the Send as Task button. Specifies whether Collaborator Workbench displays worksheet content panes. If implemented, specifies whether to check whether the product matches between a settlement and the possible promotions. This parameter controls matching for all kinds of settlements, not just off-invoice settlements.