Managing Server Settings

Server values are Financial Reporting server-side settings and properties that control global behavior for Financial Reporting reports.

Service Administrators can edit Server settings in Financial Reporting Web Studio.

Note:

Report Designers cannot change Server settings.

To edit Server settings in Financial Reporting Web Studio:

  1. Select File, then Manage, and then Server.
  2. In the Settings tab, edit the following properties:
    Property Name Default Value Description
    Missing Values in Formulas as Zero false Whether to treat missing values as zero in formula calculations.
    • When set to false, missing values are not the same as zero values in formula calculations.
    • When set to true, missing values are treated as a value of zero in formula calculations.
    Apply Application Security to FR POV and Prompt false Filters members in Prompts and Member Selection based on the data source security.
    • When set to false, users can see members to which they lack access.
    • When set to true, users cannot see members to which they lack access.
    Display Member Selection Filter in Workspace Preferences true Changes the FilterBySecurity settings in the Financial Reporting preferences for the User POV.
    • When set to false, users cannot change the FilterBySecurity settings, and cannot see members to which they lack access.
    • When set to true, users can change the FilterBySecurity settings in the Financial Reporting User POV preferences and can see members to which they lack access.
    Add Timestamp Suffix for Batch Output File true Specifies whether to add the timestamp suffix to the batch output file when bursting batch reports.
    Maximum Iterations for Calculations 10

    Specifies the maximum number of calculation iterations for all grids and cells. (Valid values are 1 through 9.)

    During the calculation process of a grid, it may be necessary to evaluate a cell multiple times due to reference precedence. This mostly occurs in grids with references to other grids. If there are no circular references and calculation cells are retuning an error, increasing the value may resolve the problem.

    Note: A high number may degrade grid execution performance.

    Number of Decimals for Zero 2 How many decimal places a number must have before it is considered a zero (0). (Valid values are 1 through 9.)
    Number of Decimals for Zero in Suppression 5

    How many digits to the right of the decimal place are evaluated when determining if a numeric value is zero in conditional suppression and conditional formatting. (Valid values are 1 through 9.)

    When you do conditional suppression/format against a ‘Value’ of ‘0’, the value to absolute zero (0) is compared. For example, using the default property of 5, a value of 0.00001 is considered zero.

    Maximum Number of Page Members for Excel Export 100 Specifies the maximum number of page dimension members that can be exported to Excel.
    Maximum E-mail Attachment Size 10 Maximum size of e-mail attachments when e-mailing books using the Batch Scheduler.
    Run Batch With Signed on User Credentials false

    When this property is set to true, there is no prompt for a username and password in the Batch Scheduler; instead, the batch is run with the credentials of the user who is currently signed in.

    Note: You must restart the service (for example via AMW) to enable the new setting. The setting will take effect after the next daily automated maintenance window.

    Export to Excel Using Default Sheet Name false

    Controls Excel sheet names upon export.

    • When set to false, the sheet name uses the Financial Reporting report name.

    • When set to true, the sheet name uses the Excel default name (Sheet1, Sheet2, etc.)

    Chart Plotting Ignores Data Values none

    Defines how charts treat #MISSING, #ERROR, and #ZERO values.

    • NONE: Do not display #MISSING, #ERROR, and #ZERO values in the chart.

    • ERROR: Display a plotted value as zero for #ERROR values in the chart.

    • ZERO: Display a plotted value as zero for #ZERO values in the chart.

    • MISSING: Display a plotted value as zero for #MISSING values in the chart.

    • ERROR & MISSING: Display a plotted value as zero for #ERROR and #MISSING values in the chart.

    • ERROR & ZERO: Display a plotted value as zero for #ERROR and #ZERO values in the chart.

    • MISSING & ZERO: Display a plotted value as zero for #MISSING and #ZERO values in the chart.

    • MISSING & ZERO & ERROR: Display a plotted value as zero for #MISSING, #ZERO, and #ERROR values in the chart.

  3. Click OK.