Application Parameters

Application parameters control the way certain features behave in an application.

Prerequisites

Administrators with Administration - Application task security rights can set application parameters.

Features

Application parameters can be different for each application within an application set. If an application parameter is required, you can leave it blank to accept the default. If you delete the parameter, the system may not work correctly. If an application parameter is optional, you can delete it.

The following table describes the parameters you can set within the Administration interface using the Administration Configuration action pane.

The parameters that require a value include (R) in the Type column. Parameters that do not require a value include (O) in the Type column. If an application parameter is required, you can leave it blank to accept the default, but if you delete the parameter, the system may not work correctly. If an application parameter is optional, you can leave it blank or delete it.

Type	Key ID	Description
(O)	`BPC_STATISTICS` (in NetWeaver version only)	Use this parameter to specify that various modules write detailed runtime statistics to the tables `UJ0_STAT_HDR` and `UJ0_STAT_DTL`. You can use this information to monitor system performance. Valid values are: `ON` `OFF`
(O)	`CUSTOMFACTBLINDEX` (in Microsoft version only)	Use this parameter to define a dimension list to create a custom index in the appropriate database table and accelerate import processing. Valid values for this parameter are: Category, Time, Entity, Account, and RptCurrency. Enter a list of dimensions into this parameter, separated by commas. The default value is blank. When you use a custom fact table index, we recommend that when you modify the application, you select the Reassign SQL Index option. This parameter is used in Admin - Modify application, Add a new application, Copy an application.
(O)	`DIMSFORFACTTBLINDEX` (in Microsoft version only)	Use this parameter to specify the fields and the field order for the indexes used by the Fact, Fac2 and write-back tables. The Fact and Fac2 tables use a clustered index; the write-back table uses a composite index. Valid values are: `Category` `Time` `Entity` `Account` `RptCurrency` Enter a list of dimensions into this parameter, separated by commas. The default value is: `Category, Time, Entity, Account, RptCurrency` If the parameter is blank, the default fields and field order are used. This parameter is used in Admin - Modify application, Add a new application, Copy an application.
(O)	`DTSLOGPAGESIZE`	Use this parameter to set the number of records that display in the Data Manager Status View. Enter the number of records to display. The default value is `300`. This parameter is used in Data Manager - Status View.
(O)	`JRN_ACCDETAIL_DIM`	Use this parameter to specify a special dimension name used to manage the Opening, Closing, and Reverse Sign codes. This is used with `JRN_CLOSING_CODE`, `JRN_OPENING_CODE`, and `JRN_REVSIGN_CODE`. This parameter is used in Interface for Office - Journal.
(O)	`JRN_BALANCE`	Use this parameter to control whether it is necessary for Journals to be balanced. Valid values are: `0` – Journals need not be balanced `1` – Journals need to be balanced The default value is `0`. This parameter is used in Interface for Office - Journal.
(O)	`JRN_CLOSING_CODE`	Use this parameter to specify the member name for the Closing code. This member is part of the dimension name specified by `JRN_ACCDETAIL_DIM`. The member name must be set to use this feature. The default value is blank. This parameter is used in Interface for Office - Journal.
(O)	`JRN_DESC_MODE`	Use this parameter to allow the display of the description in the journal template. Valid values are: `N` – Displays the member ID in the journal template for the application. This provides optimal readability. `Y` – Displays the description of member in the journal template The default value is `N`. This parameter is used in Interface for Office - Journal.
(O)	`JRN_IS_STAT_APP`	Use this parameter to enable or disable subsequent journal fields, if the application is used for statutory consolidation. Valid values are: `1` – Enables the subsequent journal fields `0` – Disables the subsequent fields The default value is `0`. This parameter is used in Interface for Office - Journal.
(O)	`JRN_MAXCOUNT`	Use this parameter to specify the maximum number of journal entries returned from a query in the Journal Manager. This is useful if you have a large number of Journal Entries and want to protect a user from launching a long query. The default value is blank. This parameter is used in Interface for Office - Journal.
(O)	`JRN_OPENING_CODE`	Use this parameter to specify the member name for the Opening code. This member is part of the dimension name specified by `JRN_ACCDETAIL_DIM`. The member name must be set to use this feature. The default value is blank. This parameter is used in Interface for Office – Journal.
(O)	`JRN_POST_OVERWRITE`	Use this parameter to specify whether the system keeps the same Journal ID when saving journals that were previously set to Posted status, but changed to Unposted status. Valid values are: `Y` – Preserves the Journal ID when the unposted journal is saved `N` – Creates a new ID when the unposted journal is saved The default value is `N`. This parameter is used in Interface for Office – Journal.
(O)	`JRN_REOPEN`	Use this parameter to define the default for reopening journals. Valid values are: `N` – Does not allow reopening of journals `Y` – Allows the reopening of journals The default value is `N`. This parameter is used in Interface for Office – Journal.
(O)	`JRN_REOPEN_PROPERTY`	Use this parameter to specify the property name in the account dimension that is used to further filter the journals to reopen. A valid value is a property in the account type dimension. The default value is `GROUP`. If this parameter is not set, the GROUP property must exist in the account type dimension. Alternatively, to use a property other than GROUP, change the value of the ACCOUNT_PROPERTY column in the Journal Translation template. This value can be any property in the account type dimension, or *. For more details, see SAP Note 1384731.
(O)	`JRN_REVSIGN_CODE`	Use this parameter to specify the member name that is used to reverse the sign during posting and unposting. This member is part of the dimension name specified by `JRN_ACCDETAIL_DIM`. The member name must be set to use this feature. The default value is blank. This parameter is used in Interface for Office – Journal.
(O)	`JRN_VALIDATION_SP`	Use this parameter to specify the SQL stored procedure name to be executed before posting or unposting data. This stored procedure performs custom validation on the entire `RecordSet` to be posted or unposted and returns go/no-go to the posting engine. The default value is blank. This parameter is used in Interface for Office – Journal.
(O)	`LOCKREPORT` (in Microsoft version only)	Use this parameter to specify a report name to launch when submission validation for a data region is not `0`. The template must be located in the folder`<drive>\webfolders\<appset>\<application>\eExcel\Input Schedules\Wizard\`. A sample validation template provided with ApShell is located in `<drive>\webfolders\ApShell\Planning\Excel\Input Schedules\Wizard\Validate.xlt.` The default value is blank. This parameter is used in Interface for Office – Validate submission.
(R)	`ORG_ACCOUNTLIST`	Use this parameter to specify what account dimension members of the ownership application represent the legal consolidation method, and the ownership percentage for the subsidiary company in the dynamic hierarchy. The account dimension members must exist in the ownership type application. The `METHOD` member for the consolidation method must be defined in the parameter. If you define any member other than `METHOD`, the legal consolidation fails due to the consolidation business rule referring to a reserved word. For the ownership percentage, you can define one or one more account dimension members according to your business needs. At least one member must be defined for the ownership percentage. This parameter is required if the application is an ownership type, and if performing legal consolidation that refers to the ownership application. The default value is `METHOD,POWN,PCON`. You can enter account dimension members from the ownership type application separated by a comma (,) delimiter. This parameter is used in Admin - Dynamic Hierarchy Editor.
(R)	`ORG_ACCOUNTOWN`	Use this parameter to specify the relationship of the parent and subsidiary companies in the dynamic hierarchy. The default value is `PGROUP`. If the parameter is not defined, Dynamic Hierarchy Editor does not work. During processing of the legal consolidation business rule, the rule refers to the parameter value as well. If the parameter is not defined, the rule finds the account dimension member named `GROUP` or `PGROUP` during processing. This parameter is required for ownership type applications that are used to perform legal consolidations. You can enter account dimension members of ownership type application. This parameter is used in Admin - Dynamic Hierarchy Editor.
(R)	`ORG_INTCO`	Use this parameter to specify a member ID from the `INTCO` dimension in the Ownership application. The default value is `I_NONE`. This parameter is used in Admin - Dynamic Hierarchy Editor.
(R)	`ORG_PARENTPROPERTY`	Use this parameter to specify the property name of the group dimension for dynamic hierarchy statutory applications when defining fixed hierarchies. The value must match the value in the `ParentProperty` for entities in the statutory applications that support ownership application. This parameter is required for ownership type applications that are used to perform legal consolidations. The default value is `PARENT_GROUP`. This parameter is used in Admin - Dynamic Hierarchy Editor, Business Rules.
(O)	`SEC_CACHE_EXPIRE` (in Microsoft version only)	Use this parameter to set the expiration time, in hours, for the secured profile cache. This specifies how long member access security profiles are cached. This limits the amount of memory required for the cache. If a user does not retrieve data during the specified time period, the cache memory is released on the application server. A valid value is a positive integer larger than 0. The default value is `24`. If you change this parameter, you must reset IIS on the application server.
(O)	`SEND_SGTABLE_COUNT` (in Microsoft version only)	Use this parameter to specify the count of the `sgData[Application]` table that is used by the data sending process. It is to be scalable for sending data, and it process sending data parallel as the number of the table. Use this parameter so that the system can split the `sgData[Application]` table when it sends large amounts of data. Valid values are positive integers larger than 0. The default value is `2`. After you add or modify this parameter, modify the application in the Administration console.
(O)	`SIGNED_DATA_FORMAT`	Use this parameter to specify the decimal precision and scale of the `signeddata` column of the tables `tblFact`, `tblFac2` and `tblFactWB` in an application. The default value is `25,10` (25 for precision and 10 for scale). This parameter is used in Admin – Add a new application, Modify application, and Copy an application.
(R)	`TOPDOWN` (in Microsoft version only)	Use this parameter to define how to handle the approval of work status. Valid values are: `Yes` – Top down approval of work status. Work status is approved regardless of whether sub-work status is approved `No` – Bottom up approval of work status. Work status can be approved only if all sub-work statuses are approved. The default value is `No`. When you change the value of this parameter, existing work status information is removed. This parameter is required if work status setting is enabled in the Administration console.
(O)	`VALIDATE_MBR_LOGIC`	Use this parameter to specify that the system validates members when processing logic. The performance of processing logic decreases due to this validation. Valid values are: `1` – The system filters records that would otherwise post to a parent member to a member that no longer exists or a member calculated dimension formula `0` – The system bypasses this validation The default value is `0`. This parameter is used in Script Logic – posting data during running script logic.
(O)	`WORKSTATUSVALIDATE` (in Microsoft version only)	Use this parameter to specify that the system checks the value of a cell for which a user tries to change the work status. If 0, it passes the validation; if not, it is rejected. Valid values are: `Yes` – Necessary to check validate `No` – Not necessary to check The default value is `No`.
(O)	`YTDINPUT`	Use this parameter to specify whether data is entered in year-to-date (YTD) format. Valid values are: `Yes` – YTD format `No` – Periodic format The default value is `No`. This parameter is used in Admin - Application process.
(R) if application type is YTD input type	`YTDINPUTTIMEHIR` (in Microsoft version only)	Use this parameter to specify the time dimension hierarchy that is used by a YTD storage application. The default value is `H1`.
(O)	`YTD_NECJ_RETRIEVE`	Use this parameter to specify the query type to improve the performance of data retrieval when retrieving YTD measures on Periodic applications or the opposite. This parameter is useful in the following circumstances: YTD / QTD measures data is retrieved on periodic application or Periodic / QTD measures data is retrieved on YTD application. The retrieval range is huge, but the portion of the data existing cells is small. `ColKeyRange` or `RowKeyRange` has more than two dimensions. The retrieval range has no members with a dimension formula. Valid values are: `1` – To use the `NonEmptyCrossJoin` query `0` – Not to use the `NonEmptyCrossJoin` query The default value is `0`. This parameter is used in Retrieve data functions `EVDRE`, `EVGET`, `EVGTS`, `EVSND`, `EVINP`.

Activities

To update the value of a parameter, start the Administration interface, and from the action pane, select Set Application parameters. Modify the parameters, as desired, and then click Update.

To add a new parameter (you can add any 'optional' parameter if it does not already display), add a new row, enter the parameter name, then enter the desired value.