Managing Server Settings

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

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

Note:

Report Designers cannot change Server settings.
Server settings are not available in the Fusion edition of Financial Reporting Web Studio.

To edit Server settings in Financial Reporting Web Studio:

Select File, then Manage, and then Server.

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.
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 user name 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.
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.
Related Content URL Launch Mode	post	Defines the type of HTTP request made for related content URLs. The default launch method is HTTP post. In scenarios where the related content URLs do not support a post request, change the server setting to HTTP get.
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.)
Export to Excel Ignoring Page Breaks	true	Defines how page breaks are handled when exporting reports to Excel. When set to true, reports are exported to Excel as a single sheet, ignoring page break definitions in the report. When set to false, reports are exported to Excel as multiple sheets based on page break definitions in the report.
Export to Excel in One Sheet	false	Defines how to export physical pages from Excel. When set to true, physical pages are exported into a single Excel sheet. When set to false, physical pages are exported into separate sheets.
Export Physical Pages to Excel in Multiple Sheets	false	Defines how to export Financial Reporting reports with multiple physical pages to Excel, where a physical page is the same as a single page in PDF preview. When set to true, reports with multiple physical pages are exported to different sheets. When set to false, reports with multiple physical pages are exported to one sheet.
Cleanup Batch Jobs Older Than	never	Defines how long a batch job and its files are retained in the repository before being deleted. Options include: Never 7 days 15 days 20 days 30 days
Batch Cleanup Process Interval	never	Defines the interval between batch cleanup. Options include: Never 7 days

Click OK.