Calculate the Access of Users

Prerequisites

Navigation

From the nav menu, go to

Administration

>

User Access Calculator

.

Dimension Lists

Select a version to calculate the version access controls for the user, which supersedes access rules.
Select a value from each secured dimensions. This calculates the access rules.
Select any other dimension values that aren't secured. This could include accounts and any custom dimensions. This has no affect, but is still required to proceed.

Check Access to a Coordinate

Select a username from the
User
drop-down list.
Click a value from each of the lists.
For
Mode
, click
Single Coordinate
.
Click
Calculate
.

Check Access to a Single Dimension

Select a username from the
User
drop-down list.
For
Mode
, click
Single Dimension.
From the
Single Dimension
prompt that appears, select the dimension you want to calculate. Example: Select
Account
if you want to see all the accounts the user can access somewhere.
Click a value from each of the dimension lists. Selecting dimensions from the list that you're searching, has no affect, but is still required. Example: If you selected
Account
from the prompt, you must click some account from the account list. The results still show all the accounts the user can access.
Click
Calculate
.

Example: Pivot Single Dimension Calculations

Find Any Accessible Levels

Select
User1
from the
User
drop-down list.
Click
Single Dimension
and select
Level
from the
Single Dimension
prompt.
Click any level from level list, and any version from the version list.
Click
Revenue
from the account list.

The results are:

Name	Access
Sales	None
Marketing	None

You see that the user has

Some kind of access to 2 levels in the entire model: Sales and Marketing.
No access to either level at the Revenue account.

Find Accessible Accounts at the Sales Level

Your next step is to find the accessible coordinate for those 2 levels. You could:

Click through the account list and recalculate for each account.
Pivot your search.

To pivot:

Select
Accounts
from the
Single Dimension
prompt because you already know all the levels User1 can access.
From the level list,
click
Sales
because you already know User1 has access to
Sales
.
Leave the other list selections as-is.
Click
Calculate.

The results are:

Name	Access
Expense	Write
Inventory	Read

You now know User1's access at the Sales level and all the accounts the user can access at some level:

Access only 2 accounts in the entire model at some level: Expense and Inventory.
Change data at Expense and view data at Inventory for the Sales level.

Find Accessible Accounts at the Marketing Level

Click
Marketing
from the level list.
Leave everything else as-is.

The results are:

Expense	Write
Inventory	None

You now see that at the Marketing level User1 has only change data in 1 account, Expense.

You now know all User1's access:

Change data in Expense
at the Sales
and Marketing
levels
View Inventory
at the Sales
level.

Access Calculation Results