Administrators with Administration - Application task security rights can set application parameters. Application parameters control the way certain features behave in an application. The application parameters can be different for each application within an application set.
The following table describes the parameters you can set. 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 delete it if you want to.
Many of the journal (JRN_) parameters below are used to enable Statutory Consolidation journal
requirements. When these parameters are set, the system generates auto -generating closing values, data entry locking of opening balance, and automatic reversing of the sign of specific account details.
Key ID Description
APPROVALORG If you want to use the work status feature, you must use this field to identify the hierarchy level (H1, H2, H3, ..., Hn) for which you want to track the work status of deliverables.
You can define only one hierarchy for each application within an
application set. For alternate organizations, "No Status" is displayed when viewing those members in the work status screen.
If this field is left blank, work status tracking is not enabled. See Managing work status
Calculation Default = 1
DimsForFactTblIndex The Fact and Fac2 tables use a clustered index, and the write-back table uses a composite index. The default fields and order of the fields for the index is Category, Time, Entity, Account, RptCurrency.
If you need to change the field and order, enter them here. IntcoBookings Default = 1
JRN_ACCDETAIL_DIM A special dimension name used to manage the Opening, Closing, and Reverse Sign codes. This field is used in conjunction with the
JRN_CLOSING_CODE, JRN_OPENING_CODE, and JRN_REVSIGN_CODE fields.
Key ID Description
JRN_BALANCE Controls whether Journals are required to be balanced. 1=Yes, 0= No. (Optional)
JRN_CLOSING_CODE The member name for the 'closing' code. This member is part of the dimension defined in the JRN_ACCDETAIL_DIM field.
JRN_DESC_MODE Accept the default N when you want member IDs to be displayed in the application's journal template. The default also provides optimal readability.
Use the value Y to display the description in the journal template. JRN_IS_STAT_APP If the application is used for statutory consolidation, set this field to Y to
enable the subsequent journal fields. Set to N to disable the subsequent fields.
JRN_MAXCOUNT Maximum number of journal entries returned from a query in the Journal Manager. This parameter is useful if you have a large number of Journal Entries and want to protect a user from launching a very long query. (Optional)
JRN_OPENING_CODE The member name for the 'opening' code. This member is part of the dimension defined in the JRN_ACCDETAIL_DIM field.
JRN_POST_OVERWRITE Controls whether the system keeps the same Journal ID when saving journals that were previously set to Posted status, but changed to Unposted status. (Optional)
Y indicates that the Journal ID is preserved, while N indicated that a new ID is created when the unposted journal is saved.
JRN_REOPEN Allows you to define the default for reopening journals: N = do not allow reopening of journals (default); or Y = allow the reopening of journals.
JRN_REVSIGN_CODE The member property name that is used to reverse the sign during posting and unposting. The property value must be set to Y to use this feature.
This property is defined for the members defined in the 'JRN_ACCDETAIL_DIM' field.
JRN_VALIDATION_SP Allows you to specify the SQL stored procedure name to be executed before posting/unposting data. This stored procedure performs custom validation on the entire RecordSet to be posted/unposted and gives back go/no-go to the posting engine.
OpeningBalance Default = 1
JRN_ALLOWPOST The sequence number of the Approval status code to use for locking data for Journal changes only. You can set up a special approval status for Journals. See Locking data for journal input only in Admin help for more information. (Optional)
JRN_REOPEN_PROPERTY A custom Journal module assumes that property named UB must be present in account dimension to further filter the Journals to Re-Open. The default is Group. If Group, then there is no need to modify the account dimension.
Key ID Description
ORG_INTCO The default value is I_NONE, which should also be a member ID in the INTCO dimension in the ownership application if using dynamic hierarchies.
ORG_ACCOUNTOWN The default value is PGROUP.
ORG_ACCOUNTLIST The default value is METHOD,POWN,PCON.
ORG_PARENTPROPERTY This parameter is used with dynamic hierarchy statutory applications when defining fixed hierarchies. The value must match the value in the ParentProperty property value of entities in the statutory application's supporting ownership application.
OWNERSHIP_APP The name of the Ownership application. If this parameter does not exist, the consolidation procedure will by default search for an application named OWNERSHIP.
TOPDOWN 0=bottom up approval; 1=top down work status. (Required)
WORKSTATUSVALIDATE N/A, Yes or No
YTDINPUT This parameter controls whether data is input in year-to-date format. Valid options are 1, which means ytd format; or 0, which means periodic format. (Optional)
To set application parameters
1. Start BPC Administration, and from the Administration Configuration action pane, select Set Application parameters.
2. Modify the parameters, as desired, then click Update .