Access Rule Examples

The following example forecast and access rules illustrate the most common use cases.

Project Forecast Example
Time Period End Date (Year) 2027
Time Period End Date (Month) 01 02
Revenue/Cost Revenue Cost Revenue Cost
Hierarchy Amount (Record Currency) Amount (Record Currency) Amount (Record Currency) Amount (Record Currency)
 Acme Company - Managed Services-Project Part 1 USD 12,605.00 USD 28,796.12 USD 10,605.00 USD 26,796.12
 Actuals USD 4,755.00 USD 26,007.23 USD 3,755.00 USD 25,007.23
 Deliverable: Timecard USD 4,755.00 USD 26,007.23 USD 3,755.00 USD 25,007.23
 Resource: Jamie Smith USD 0.00 USD 12,320.00 USD 0.00 USD 11,320.00
Pending Recognition USD 0.00 USD 12,320.00 USD 0.00 USD 11,320.00
Recognized to Date   USD 0.00   USD 0.00
 Resource: Taylor Hughes USD 0.00 USD 9,722.23 USD 0.00 USD 9,722.23
Pending Recognition   USD 9,722.23   USD 9,722.23
Recognized to Date   USD 0.00   USD 0.00
 Resource: Billie James USD 0.00 USD 3,965.00 USD 0.00 USD 3,965.00
Pending Recognition   USD 3,965.00   USD 3,965.00
Recognized to Date   USD 0.00   USD 0.00
 Timecards USD 4,755.00 USD 0.00 USD 4,755.00 USD 0.00
Pending Recognition USD 4,755.00   USD 4,755.00  
Recognized to Date USD 0.00   USD 0.00  
 Forecast USD 7,850.00 USD 2,788.89 USD 6,850.00 USD 1,788.89
 Deliverable: Assignment USD 0.00 USD 2,788.89 USD 0.00 USD 1,788.89
 Resource: Jamie Smith USD 0.00 USD 1,750.00 USD 0.00 USD 750.00
Scheduled   USD 1,750.00   USD 750.00
Unscheduled   USD 0.00   USD 0.00
 Resource: Taylor Hughes USD 0.00 USD 388.89 USD 0.00 USD 388.89
Scheduled   USD 388.89   USD 388.89
Unscheduled   USD 0.00   USD 0.00
 Resource: Billie James USD 0.00 USD 650.00 USD 0.00 USD 650.00
Scheduled   USD 650.00   USD 650.00
Unscheduled   USD 0.00   USD 0.00
 Deliverable: EVA USD 7,850.00 USD 0.00 USD 6,850.00 USD 0.00
 Est vs Actuals USD 7,850.00 USD 0.00 USD 6,850.00 USD 0.00
Scheduled USD 7,850.00   USD 6,850.00  
Unscheduled USD 0.00   USD 0.00  

Example 1: Close a Time Period for All Users

When the period 01 for year 2027 is closed, you want to prevent all users from making further adjustments to it. You can create an access rule for closed 2027 time 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.

Example 1 Access Rule Details
Field Value
Access Rule Name 2027 Closed Time Periods
Description Prevents all users from making adjustments to the 2027 closed time periods.
Access Level "Read-Only"
Example 1 Dimension Value Conditions
Dimension Operator Value
Time Period End Date (Year) "Equals" 2027
Time Period End Date (Month) "Equals" 01

The AND logical operator is applied between the dimension value conditions.

At the end of each period, you can edit the Time Period End Date (Month) dimension value condition to add the newly closed period.

Note:

If your org is configured to use the Time Period dimension instead of Time Period End Date (Year) and Time Period End Date (Month), use the Time Period dimension in access rules instead of Time Period End Date (Year) and Time Period End Date (Month).

This rule does not have any measure or user conditions.

In Project Forecast Example, this rule prevents all users from making adjustments to any values in month 01 of year 2027.

Example 2: Prevent Project Managers and Services Leader from Adjusting Actuals

You want project managers and services leaders to only be able to make adjustments to forecasted values. They must not adjust actual values.

The Example 2 Access Rule Details, Example 2 Dimension Value Conditions, and Example 2 User Conditions tables detail the access rule, dimension value condition, and user condition values to apply.

Example 2 Access Rule Details
Field Value
Access Rule Name Actuals for Project Managers and Services Leaders
Description Prevents project managers and services leaders from making adjustments to actuals.
Access Level "Read-Only"
Example 2 Dimension Value Conditions
Dimension Operator Value
Actuals/Forecast "Equals" Actuals

This rule does not have any measure conditions.

Example 2 User Conditions
Type Operator Value
User "Equals"

Jamie Smith

Taylor Johnson

Billie Williams

In Project Forecast Example, this rule prevents Jamie Smith, Taylor Johnson, and Billie Williams from making adjustments to actual rows.