1. Modeling
  2. Line items
  3. Dynamic cell access
  4. Create an access driver module

Create an access driver module to store access drivers. Access drivers are line items with Boolean data types that define the dimensions that you want to control cell data access to.

An access driver's dimensions must be compatible with those of the target module or line item it's applied to. The dimensions are compatible if:

  • The access driver module and target module or line item have at least one matching dimension, or
  • The driver line item is dimensioned against users, or
  • The driver line item is dimensioned against the parent hierarchy and the target module or line item is dimensioned against the child hierarchy.

And

  • The access driver is a Boolean formatted line item with any of these summary methods: All, Any, None, or Formula (Boolean line items have a summary method of None by default)

For every list dimension in the target module that does not match the list dimensions in the access driver module, set a Top Level Item for flat lists. Set a Top Level Item on the Configure tab of the list

Create an access driver module

To create an access driver module that enables you to set access manually:

  1. Create a module that is dedicated to access drivers.
    • Select the dimensions that you want to control access to the target cell data with. For example, use the Time dimension on columns.
    • If you want to control access to cell data for individual users, add the Users list.
    • Optionally, name the module to describes its purpose. For example, SYS01 Access - Time.
  2. Insert line items to control access. For example, create one line item for read access, and one for write access. You can add extra line items to use with different target line items. 
  3. In Blueprint, format the Read and Write line items as Boolean.
    Note: You can use formulas to automatically enable or disable the access driver checkboxes depending on an external factor, such as the start of a new time period. To see examples, download the Dynamic Cell Access – Learning App(opens external page).
  4. Select Blueprint to move into Grid view. For write access, in the Write line item, select the cells that you want to be writeable. The Read line item is read-only. The leaf-level cells that were not selected in Write, are selected.
    For example, if you have a driver for write and a driver for read, and they're both on the line item you're controlling access to, then your access is:
    • Write: false, Read: false = no write, no read
    • Write: false, Read: true = no write, yes read
    • Write: true, Read: false = yes write, yes read
    • Write: true, Read: true = yes write, yes read

      Write driver gives read access.

Jan 22Feb 22Mar 22Q1 FY22Apr 22May 22Jun 22
Write



Read



Apply access drivers to target cell data

To control access to cell data by user, enable Show All Users in the target module.

To apply access drivers to target cell data:

  1. Open the target module in Blueprint.
  2. Navigate to the Read Access Driver or Write Access Driver columns, then select the appropriate access driver line item. To apply the access driver at module level, select the access driver in the first row. Access drivers cascade to every line item in the module where there's a hyphen. The same level of access applies to all cell data in the module when the driver is set at the module level.
  3. If you want a very fine level of granularity, you can apply separate access drivers to each line item.

Read Access DriverWrite Access Driver
Products over timeAccess - Time.ReadAccess - Time.Write
   Product A--