Show TOC

Function documentationApplication Set Parameters Locate this document in the navigation structure

 

Application set parameters allow you to customize your application sets.

Prerequisites

You have Appset task security rights to view and change application set parameters.

Features

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:

  • Interface for the Web - when posting documents in Content library menu

  • Interface for Office - sending data, journal posts, Data Manager imports, e-mail notification attachments

(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:

  • Yes: Send e-mail

  • No: Do not send e-mail

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:

  • %USER% — Name of user who changed this status

  • %STA% — Work status

  • %OWNER% — Entity owner (Microsoft version only)

  • %TIME% — Time of change

  • %REGION% - Lock region (NetWeaver version only) — For example: ENTITY: CG1, TIME: 2009.Q1, DATASRC: DC_1, PROJECT: PRJ_1, PRODUCT: PRO_1

Example Example

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 (AVAILABLEFLAG = No).

The default value is “Current Appset status is available”

Example Example

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:

  • 0: This is the default value and saves the history of comments.

  • 1: The historical comments are deleted and only the latest comments remain.

(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.

Note Note

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 "[Server Install]\Data\WebFolders\[Appset]".

Example Example

C:\Program Files\SAP BusinessObjects\PC_MS\Data\WebFolders\[Appset]

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:

  • Interface for the Web - When posting documents in the Content library menu

  • Interface for Office - Send Data, Journal-post, DM-Import

(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:

  • 0: Hides the checkbox

  • 1: Show the checkbox

(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:

  • If a template is supplied in the Allow Formatting section, it is used.

  • Otherwise, the style template specified in the EVDRE_STYLES parameter is used.

  • Otherwise, the default EVDRE colors are used.

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 //root/ of the file service, so that one template can be used globally, regardless of the AppSet.

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, :,:_.

Example Example

For example, under a folder named 'Report.htm', the system creates the following subfolders:

  • Chinese: report.file

  • English: report_files

  • French: report_fichiers

  • German: report-Dateien

  • Italian: report-file

  • Japanese: report.files

  • Korean: report.files

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:

  • Donothing

  • Info

  • Warning

  • Error

  • Fatal

(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:

  • None

  • Info

  • Warning

  • Error

  • Fatal

(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:

  • 0 – do not change to offline

  • 1 – change to offline

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.

Example Example

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.

Example Example

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:

  • 1 – Dimension formula column is nvarchar instead of varchar to support double-byte characters.

  • N/A or blank or 0 - Dimension formula column is varchar.

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:

  • 0: Does not allow retrieving or exporting data while an application set is unavailable regardless of OfflineAccess task security.

  • 1 (default): Allows retrieving or exporting data while an application set is unavailable (system offline) if the user has OfflineAccess task security.

:

The following tasks are exceptions to rule, and can be executed when the value is 0:

  • Execute logic (script, business rules) from DM packages

  • Run Export from fact table package

  • Run Append into Fact Table package

  • Add new comments

  • Save data through DHE (Dynamic Hierarchy Editor)

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:

  • 0: Run in process

  • 1 (default): Run out of process

(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:

  • 0 = Anonymous

  • 1 = Basic

  • 2 = NTLM

This parameter is used in:

  • Interface for the Web - When posting documents, Work status, Alert

  • Interface for Office - Offline distributor

(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:

  • Interface for the Web - When posting documents, Work status, Alert

  • Interface for Office - Offline distributor

(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:

  • Interface for the Web - When posting documents, Work status, Alert

  • Interface for Office - Offline distributor

(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:

  • Interface for the Web - When posting documents, Work status, Alert

  • Interface for Office - Offline distributor

(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:

  • Interface for the Web - When posting documents, Work status, Alert

  • Interface for Office - Offline distributor

(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:

  • Donothing

  • Debug

  • Path

  • Info

  • Warning

  • Error

(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:

  • YES – all posted records are written to the log file

  • NO – all posted records are written to the log file unless there are more than 300,000 records

    If there are more than 300,000 records, no records are written but replaced with the message More than 300,000 records. Details are not being logged.

This parameter is used in Script Logic.

(R)

UPLOADTEMP

Temporary folder used to store Content Library documents.

The default value is: <drive>\FTPServer\OSoftFTP (where <drive> is Folder name that was created at installation.)

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.

Example Example

This is tblDefaults table that manages all of system parameters.

User Id

Type

App

Key ID

Value

_GLOBAL

SYSTEM

USE_VARCHAR_FOR_DIM

ACCOUNT

1

End of the example.

Activities

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.