Application Set Parameters 
Application set parameters allow you to customize your application sets.
You have Appset task security rights to view and change application set parameters.
The following table describes the parameters you can set from 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 set 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 set parameter is optional, you can leave it blank or delete it.
Type |
Key ID |
Description |
||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
(O) for the Microsoft version (R) for the NetWeaver version |
ALLOW_FILE_SIZE |
The maximum file size the system permits users to upload. A warning message appears if the file size exceeds the parameter value when you upload a file. The default value is 100 MB. This parameter is used in:
|
||||||||||
(O) |
APPROVALSTATUSMAIL |
Defines whether owners and managers receive an e-mail when there is a change to an assigned work status. Has the following possible values:
In the Microsoft version of Planning and Consolidation, the following SMTP application set parameters must be set up as well to use e-mail notifications in the system: SMTPAUTH, SMTPPASSWORD, SMTPPORT, SMTPSERVER, and SMTPUSER. In the NetWeaver version of the system, the ABAP SMTP service is used for sending e-mails. |
||||||||||
(O) |
APPROVALSTATUSMSG |
Allows you to define a custom e-mail message that is sent to the owners and managers of a work status when a work status code is changed. The message is applicable to all applications in the application set. You can customize the message using the following variables:
You can create a message such as, This is to inform you that %USER% has updated the work status for %REGION% on %TIME%. End of the example. The text of the e-mail can be a maximum of 255 characters. There is no need for quotes or brackets around parameters. |
||||||||||
(R) |
AVAILABLEFLAG |
Controls whether the system is offline or not. Yes means the system is online and available for sending data to the database. You can take the system offline by changing the value to No. This parameter is used in Interface for Office - Send Data, Journal Posts, DM Imports |
||||||||||
(R) |
AVAILABLEMSG |
The message that displays to users who try to access an application that is offline ( The default value is “Current Appset status is available”
The message could be “The system is temporarily unavailable due to scheduled maintenance. Try again later.” End of the example. This parameter is used in Interface for Office - Send Data, Journal-post, DM-Import. |
||||||||||
(R) |
AVAILABLEURL (In NetWeaver version only) |
The URL of the warning page that displays when a user attempts to access an application that is offline. |
||||||||||
(O) |
BPFSTEP_COMPLETE_MSG (In Microsoft version only) |
Determines the content of the message that is displayed when a Business Process Flow step is completed. The default message is: [%BPF_STEP_NAME%] step of [%BPF_NAME%] has been completed by %USER_NAME%. This parameter is used in Admin console - Manage Business Process Flows. |
||||||||||
(O) |
CLR_COMMENTS_HISTORY |
Deletes the comment history except for the last comment entered. Possible values for this parameter are:
|
||||||||||
(O) |
COMMENT_MAX_LENGTH (In Microsoft version only) |
Customizes the length of comments. The default value is 256 and the maximum length is 4,000 characters.
If you set a smaller value than current value, the newly entered value does not apply to comment length and the previous value still applies even though the setting is updated successfully in AppSet parameters page. Therefore, the new value should be larger than the previous value. End of the note. |
||||||||||
(O) |
COMPANY_LOGO (In Microsoft version only) |
Use this parameter to add your corporate logo to the default templates in the interface for Excel. Enter the file name for the logo image that you want to display. This image must be stored in the Application Set directory, which is "
End of the example. If the COMPANY_LOGO does not exist or the file name is invalid, the default globe image displays. Allows the bmp, gif, and jpg image file types. |
||||||||||
(O) |
DEFAULT_EXTENSIONS |
The system allows the default file type even if you do not set this parameter. The default file extensions are hard-coded internally. The file extensions the system allows users to upload by default: .XLS, XLT, .DOC, .DOT, .PPT, .POT, .XML, .MHT, .MHTML, .HTM, .HTML, .XLSX, .XLSM, .XLSB, .ZIP, .PDF, .PPTX, .PPTM, .POTX, .POTM, .DOCX, .DOCM, .DOTX, .DOTM, .CDM, .TDM, .PNG, .GIF, .JPG, .CSS, .MRC. See ALLOWEXTENSIONS above. The user can change the value. This parameter is used in:
|
||||||||||
(O) |
DTSSTATUSCHECK (In Microsoft version only) |
Use this parameter to hide or show the Refresh Status Every checkbox in the Data Manager Status View. If the checkbox is enabled and large records exist, the performance when refreshing the status degrades. By hiding the checkbox, the refresh is performed whenever a user calls the refresh button manually. Possible values for this parameter are:
|
||||||||||
(O) |
EVDRE_STYLES (In Microsoft version only) |
Use this parameter to specify a report or input template containing the default style sheet. If no style template is specified in the EVDRE builder in the Formatting section, then the default stylesheet is applied from the template specified in this parameter. This allows users to customize their formatting and save the customization as the default style template. They do not have to manually reapply the template for each new report. Users can overwrite the default formatting for a given report or input template by using existing formatting options. The priority of formatting for a new EVDRE report or input template is:
By default, this parameter is empty. Style templates that are used for EVDRE formatting can be stored in any folder in the file service. The full file service path must be specified in the parameter, starting with Changes to the style template specified in this parameter do not affect reports and schedules previously created from this template. |
||||||||||
(O) |
EXECUTECUSTOMQUERY (In Microsoft version only) |
Set to Y to query the database using predefined SQL statements stored in the tblCustomQuery table. |
||||||||||
(R) |
FILESFOLDERDELIMITER (In Microsoft version only) |
When you create Web-ready files in Excel, the system creates subfolders based on the native Excel Save as HTML function. Since the naming rule of the subfolder is different for each Microsoft Office language, this parameter allows the system to find the subfolder having the defined delimiter when selecting Web-ready files in Interface for the Web. (Required) The default value is _:.:-. You must define a value for this parameter if the value is empty, or does not contain the required delimiter for your Microsoft Office version. Separate multiple delimiters with a colon; for example, :,:_.
For example, under a folder named 'Report.htm', the system creates the following subfolders:
End of the example. The user can define this delimiter depending on their country. Use “:” to separate multiple values. This parameter is used in Interface for Office - book publishing. |
||||||||||
(O) |
JREPORTZOOM |
This parameter allows you to set the default zoom magnification value on HTML journal reports. We recommend that you set the value to 75%. |
||||||||||
(O) |
LANDINGPAGEITEM |
This parameter allows you to set up a web page as your home page for the Web interface. Once you set this, this page displays for all users of this application set. The page must first exist as a Web page in Interface for the Web. (See Creating a Web Page.) The default value is 1. or you can enter the number that represents the web page you want to make your home page. |
||||||||||
(O) |
LIMITOFDIFFERENCE (In Microsoft version only) |
The least value for which the system processes logic. If a data value is smaller than this value, they system does not process the logic. For example, when you set 0.001, smaller data values, such as 0.0009, are not processed by logic. The default value is .00000001, so if the parameter is not set, logic ignores less than 0.00000001. This parameter is used in Script Logic - Processing of script logic. |
||||||||||
(O) |
LOGLEVEL (In NetWeaver version only) |
Controls the minimum level of ABAP messages to store in the log in terms of severity, which you view by the transaction SLG1. The default value for this parameter is Info. The possible values for this parameter are:
|
||||||||||
(O) |
LOGLEVEL (In Microsoft version only) |
This parameter controls the severity level of messages to store in the log file. The default value for this parameter is Info. The possible values for this parameter are:
|
||||||||||
(O) |
LOPTZ_AVAILABLE |
This parameter takes the system offline during a minimal optimization of an application. The default value for this parameter is: 0. The possible values for this parameter are:
This parameter is used in Admin - Lite optimize. |
||||||||||
(O) |
MAXLRCOLUMNS |
The maximum number of columns to display in a live report in Interface for the Web. The value includes header and data columns. The default value is 30.
If you specify a value of 5, one heading column and four data columns are displayed. End of the example. |
||||||||||
(O) |
MAXLRROWS |
The maximum number of rows to display in a live report in Interface for the Web. The default value is 50. and the value includes both header and data rows.
If you specify a value of 5, one heading row and four data rows are displayed. End of the example. |
||||||||||
(O) |
MSNIMPASSWORD |
The password that the system uses to operate Instant Message alerts in Insight. The default value is blank. This parameter is used in Insight - Alert. |
||||||||||
(O) |
MSNIMUSER |
The user name that the system uses to operate Instant Message alerts in Insight. The default value is blank. This parameter is used in Insight — Alert. |
||||||||||
(O) |
MULTIBYTE_FORMULA (In Microsoft version only) |
Use this parameter to support dimension formulas with member IDs that contain double-byte characters, such as those in Japanese, Chinese, Korean, and Russian. The value defines the dimension formula column type as Nvarchar or Varchar. The default value is blank. Possible values are:
This parameter is used in Admin - Process dimension. |
||||||||||
(O) |
RETRIEVE_ON_OFFLINE (In Microsoft version only) |
Use this parameter to restrict data retrieval and export while an application set is unavailable (system offline). The options are:
: The following tasks are exceptions to rule, and can be executed when the value is 0:
This parameter is used in all functions that retrieve or export data. For example: Refresh data in Interface for Office and Interface for the Web, Export DM package, Book Publish, and so on. |
||||||||||
(O) |
RUNPKGBYEXE (In Microsoft version only) |
Allows for the use of an .EXE file type wrapper for running a package out of process from COM+. The options are:
|
||||||||||
(O) |
SESSIONTIME |
Defines the session time (in minutes) for the Who’s Online feature. The default value is 3000 minutes. |
||||||||||
(R) |
SMTPAUTH (In Microsoft version only) |
The authentication method of the SMTP server. This setting does not change the method on the SMTP server, but must match the type of authentication enabled on it. Failure to set this appropriately can result in errors from the e-mail server. The default value is: 1. Possible values for this parameter are:
This parameter is used in:
|
||||||||||
(O) |
SMTPPASSWORD (In Microsoft version only) |
The password for the user name defined as the SMTPUSER. This parameter is Optional except when SMTPAUTH is “1” (basic), this parameter is Required The default value is blank. The user can input the SMTP password. This parameter is used in:
|
||||||||||
(R) |
SMTPPORT (In Microsoft version only) |
Port number for your SMTP e-mail server. The default is port 25, the default SMTP server port number. The user can input the port number. This parameter is used in:
|
||||||||||
(R) |
SMTPSERVER (In Microsoft version only) |
The name or TCP/IP address of the SMTP e-mail server the system uses to send e-mail. The default value is blank. The user can input the SMTP Server name or TCP/IP address. This parameter is used in:
|
||||||||||
(R) |
SMTPUSER (In Microsoft version only) |
The user name from which e-mail from the system originates. The default value is blank. The user can input the User name. This parameter is used in:
|
||||||||||
(R) |
TEMPLATEVERSION |
Current version number of the dynamic templates in your application set. Whenever you add to or change your input schedule or report dynamic templates, you should increment this version number so that users automatically receive the new templates when they log on to this application set. You can also reset the template version from the Admin Console. The default value is the current version number of the dynamic templates in your application set. The user can input the version, or it changes automatically. This parameter is used in Interface for Office - Logon, Save dynamic template. |
||||||||||
(O) |
TRACELEVEL |
Defines the level of tracing to conduct. The default value is Error. The following levels are available:
|
||||||||||
(O) |
TRACEUSER |
Defines the Planning and Consolidation user for which the system performs remote tracing, in the form DomainName\UserName. This parameter is blank by default, and is populated by an administrator only when conducting tracing activities for a specific client. |
||||||||||
(O) |
UNLIMIT_PRINT_LOG (In Microsoft version only) |
Determines whether all posted records are written in the log file. The default value is NO. The available options are:
This parameter is used in Script Logic. |
||||||||||
(R) |
UPLOADTEMP |
Temporary folder used to store Content Library documents. The default value is: The user can input the path and, if the system was installed in a different named folder, the Administrator must change this path according to the path. This parameter is used in Interface for the Web - Upload document in the Content Library menu. |
||||||||||
(O) |
USE_VARCHAR_FOR_DIM (In Microsoft version only) |
This parameter will be available in a future release. To set the SQL data type as Nvarchar or Varchar for the dimension tables, you must edit the App column in the tblDefaults table. The default for dimension tables is Nvarchar, which is typically used for double-byte character languages such as Korean, Japanese, Chinese, or Russian. You might want to change the setting to Varchar if you have space restriction issues in SQL and OLAP, or if you are not storing unicode data. In the tblDefaults table, you can enter a specific dimension name or leave the KeyID cell blank. If the KeyID is a specific dimension name, it is applied to only the specific dimension; if the KeyID is blank, all dimensions are applied in all dim tables.
This is tblDefaults table that manages all of system parameters.
End of the example. |
To update the value of a parameter, start the Administration interface, and from the action pane, select Set AppSet parameters. Modify the parameters, as desired, and then click Update.
To add a new parameter (you can add any 'optional' parameter if it is not already displayed), add a new row, enter the parameter name, then enter the desired value.