This example demonstrates how to use dynamic cell access to control access to monthly product sales by customer.

Before you create an access driver module, create a simple Products list, and a short Customer list such as:

ProductsCustomers

All products

  • Soft drinks
  • Beer
  • Red wine
  • Rose wine
  • White wine
  • Craft ale
  • Coffee
  • Tea
  • Customer - Galaxy
  • Customer - Forward

To control access to sales by customer:

  1. Select Modules in the model settings bar.
  2. Create an access driver module, and name it Access drivers - Products, Customers.
    1. Position the Customers list on Pages, and the Products list on Columns. Remove Time.
    2. Insert two line items, Read and Write. These are the access drivers.
    3. Select Blueprint , then change the format of both line items to Boolean.
  3. Create a target module, and name it Products by Customer.
    1. Position Time on columns.
    2. Insert a line item, name it Data, and position it on Pages.
    3. Nest the Customers and Products lists on rows.
    4. Select Blueprint , then apply Access drivers - Products, Customers.Read and Access drivers - Products, Customers.Write to the Read Access Driver and Write Access Driver columns, respectively.
    5. In the Access drivers – Products, Customers module, select the checkboxes for both customers, and enter some numbers.
  4. For the purposes of this example, publish both modules to a single dashboard, and name it Product sales by Customer.
Dashboard that shows access drivers set by product and customer.

In the Access drivers - Products, Customers module, for Customer - Galaxy, the Soft Drinks, Coffee, and Tea list items have Read access. Rose Wine is not set for either Read or Write, so no data is visible. Red Wine, White Wine, and Craft Ale are set to Write.