System Settings

Table 4-7 System Settings

System Setting Description
Display Users' Full Names

When selected, the system displays the user's full name (for example, Max Hennings). When cleared, the system displays the user's ID (for example, VHennings).

Include Shared Members in Cube Refresh

When selected, shared members will inherit the security access assigned to the base member.

When cleared, shared members will inherit the highest security access based on a combination of the access assigned to the base member and parent of shared member.
Default Ancestor Access

Select an option to specify the default user access to ancestor members in ad hoc grids and the Member Selector:

  • None: By default, users are not able to see the ancestor members of members that they have access to unless they are explicitly granted access to them.

  • Read: By default, users are granted Read Only access to the ancestor members of members that they have access to unless they are explicitly granted Write or Display access, which would override this default.

  • Write: By default, users are granted Write access to the ancestor members of members that they have access to unless they are explicitly granted Read or Display access, which would override this default.

  • Display: By default, users are granted Display Only access to the ancestor members of members that they have access to unless they are explicitly granted Read or Write access, which would override this default.

    Note: Members with Display Only access are displayed, but instead of data values in the cells associated with those members, users will see #NoAccess.

Email Character Set

Select UTF-8 or Regional Setting.

Business Rules Notification

If set to Yes, sends an emailed notification to a user or group when business rules created and enabled for notification in Calculation Manager are completed or encounter errors. In Notify These Users, select the user or group to notify.

Note: You specify whether to enable a business rule for notifcation when you create the rule in Calculation Manager using the Enable Notifcations option in the rule's properties. See Creating a Business Rule in Designing with Calculation Manager for Oracle Enterprise Performance Management Cloud.

Note: See Creating and Managing Business Rules for more information on business rules.

Notify These Users

If the Business Rules Notification setting is set to Yes, select the user or group to notify when business rules are complete or encounter errors.

Note: You can select only one user or group to notify.

Allow Drill Down on Shared Members in Ad Hoc
  • Yes enables drilling on shared members in an ad hoc grid.

    When set to Yes, the Drill to All Levels in Base check box is displayed.

  • No disables drilling on shared members in an ad hoc grid.

Enable Use of the Application for

Determines whether users can access the application in administration mode, such as during backups.

  • Administrators—When you select Administrators, if any non-administrative users are logged on to the application, they are forced off the system and will not be able to log on.
  • All Users— To restore access to an application for all users, select All users.
Assign Application Owner

Assigns ownership of the application to another Service Administrator.

Enable the Display of Substitution Variables

Set how substitution variables display in the Member Selection dialog box when users respond to runtime prompts in business rules.

  • Display All—Displays all substitution variables.
  • Display None—Displays no substitution variables.
  • Enable Filtering—Displays only substitution variables that are valid for the runtime prompt.
Suppression Mode

Choose a suppression behavior for ad hoc grids in the web and in Smart View for cases where rows and columns contain missing data or zeroes.

  • Suppress Missing values only (default)—Suppresses rows, or columns, or both that contain No Data/Missing.
  • Suppress Missing also Suppresses Zeros—Suppresses rows, or columns, or both that contain both No Data/Missing and Zero.
Smart View Ad Hoc Behavior

All new and recreated applications in Enterprise Profitability and Cost Management are automatically set to Standard. You cannot change this setting.

For a complete description of the ad hoc features available in Standard mode, see Smart View Behavior Options in EPM Cloud in Working with Oracle Smart View for Office (Mac and Browser).

Use All Alias Tables on Refresh

If set to Yes, the system evaluates the alias name against all alias tables. If set to No (default setting), the system evaluates the alias name against the currently selected alias table. In either case, if the system cannot identify the input as a valid member name or alias, the input is displayed as a comment.

Link Accounts by Default

Not applicable in Enterprise Profitability and Cost Management.

Attribute Dimension Re-order Threshold

Enter a threshold value between 0 and 500 (500 is the default value).

For attribute dimensions, when the number of members under a given parent exceeds the specified threshold value, then the members will be reordered at the end of a metadata load instead of during the load. Depending on the specific shape of the attribute dimension, adjusting this number can sometimes have an impact on performance. In general, this setting can be ignored unless attribute dimension load times degrade beyond acceptable levels.

Set Reporting Options

If you're using the next-generation Reports reporting solution, Oracle recommends you use this setting to upload any TrueType fonts that your company uses to produce reports. See Managing Fonts.

To upload TrueType fonts, click Report Settings, click Manage Fonts, click Add button, and then select the font files to upload.