SECTIONSAccess Rule Examples
The following example
Example 1: Close a Financial Period for All Users
When the period 001 is closed, you want to prevent all users from making further changes to it. You can create an access rule for closed 2025 financial periods.
The Example 1 Access Rule Details and Example 1 Dimension Value Conditions tables detail the access rule and dimension value condition values to apply.
| Field | Value |
|---|---|
| Access Rule Name | 2025 Closed Financial Periods |
| Description | Prevents all users from editing the 2025 closed financial periods. |
| Access Level | "Read-Only" |
| Dimension | Operator | Value |
|---|---|---|
| Period | "Equals" | 001 |
At the end of each period, you can edit the Period dimension value condition to add the newly closed period.
This rule does not have any measure or user conditions. This means that it applies to all plan cells with the 001 Period value, regardless of the measure and the user.
In Example Plan, this rule prevents any users from editing the Home and Dual values for Actual, Budget, and Variance balance types in Period 001.
Example 2: Prevent Users from Editing the Dual Currency Values
You want users to only edit the values in their home currency to prevent exchange rate conversion mistakes. You can create an access rule that prevents most users from editing the Dual measure. However, a select few users must be able to edit the measure values in case a value must be adjusted.
The Example 2 Access Rule Details, Example 2 Measure Conditions, and Example 2 User Conditions tables detail the access rule, measure and user conditions to apply.
| Field | Value |
|---|---|
| Access Rule Name | Dual |
| Description | Prevents most users from editing the Dual values. |
| Access Level | "Read-Only" |
| Operator | Value |
|---|---|
| "Equals" | Dual |
| Type | Operator | Value |
|---|---|---|
| User | "Does Not Equal" |
Jamie Smith Taylor Johnson Billie Williams |
This rule does not have any dimension value conditions. This means that it applies to all plan cells with the Dual measure, regardless of the dimension values. It applies to all users except for Jamie Smith, Taylor Johnson, and Billie Williams.
In Example Plan, this rule ensures that only Jamie Smith, Taylor Johnson, and Billie Williams can edit the Dual values. However, when applied together with Example 1: Close a Financial Period for All Users, those three users also cannot edit Dual values for the 001 period.
Example 3: Restrict a User to Editing Budget Values for Their GLAs in Home Currency
You want a user to edit only the budget values for their assigned GLAs in the home currency. They must not edit the values for other general ledger accounts, the actual or variance values, or the budget in the dual currency. You can create an access rule for each user.
The Example 3 Access Rule Details, Example 3 Dimension Value Conditions, and Example 3 User Conditions tables detail the access rule, dimension value and user conditions to apply.
| Field | Value |
|---|---|
| Access Rule Name | Sam Phillips |
| Description | Restricts Sam Phillips to edit only the budget values for the relevant GLAs. |
| Access Level | "Read-Only" |
| Dimension | Operator | Value |
|---|---|---|
| GLA | "Does Not Equal" |
1200 - Accounts Receivable 1205 - Unbilled AR |
| Balance Type | "Does Not Equal" | Budget |
The OR logical operator is applied between the two dimension value conditions.
This rule does not have any measure conditions. This means that it applies regardless of the measure.
| Type | Operator | Value |
|---|---|---|
| User | "Equals" | Sam Phillips |
In Example Plan, this rule restricts Sam Phillips to edit only the budget values for 1200 - Accounts Receivable and 1205 - Unbilled AR GLAs. When applied together with Example 1: Close a Financial Period for All Users, they can edit only the values for period 002. Example 2: Prevent Users from Editing the Dual Currency Values ensures that Sam Philips can edit only home values. In this case, we need the two access rules to work in tandem.