Skip to main content
Adaptive Insights
Adaptive Insights LLC.

Salary Detail Permission and Settings

Explains how to protect sensitive data with the salary detail permission and settings in accounts, modeled sheets, and shared reports.

The salary detail settings are an access control found in general ledger and custom account settings, modeled sheet properties, and shared snapshot reports. The settings work with the Access Salary Detail user permission. The permission allows only privileged users to view or edit the details of sensitive or private data, such as personnel information, social security numbers, salaries, and addresses. 

In accounts, the protected details are the splits. The account setting blocks a user from expanding the account splits, or linking to the splits in Cell Explorer of all level-assigned sheets, reports, and charts. Only general ledger and custom accounts have the setting. For modeled accounts the setting is read-only and depends on the modeled sheet property.

In modeled sheets, the property blocks users from seeing the sheet and automatically activates the account setting for all the modeled accounts in the sheet. Although users without the Access Salary Detail permission can't open the sheet, there are many ways they can access the accounts, including through reports, charts, master formulas, and linked accounts. Use best practices described in this article to avoid breaches. 

In shared snapshot reports, the property blocks users from seeing the shared report.

How Salary Detail Works

In general, an Adaptive Insights model handles sensitive data, like salary accounts, one of two ways:

  • Standard sheet splits: The salary account is on a standard sheet. You add splits to the salary account to enter individual salaries. These splits roll up to the total in the salary account. Protect the account with the salary detail account setting. 
  • Personnel modeled sheets: The rows in the modeled sheet contains sensitive data that calculates the salary per employee. In a modeled sheets, all the rows are splits. Protect the entire sheet with salary detail sheet property. 

What the Salary Details Settings Don't Protect

  • Any user with permission to build reports and charts can use protected general ledger, custom, and modeled accounts. 
  • Any user who has access to a sheet, chart, or report with protected accounts can see the total values of the protected accounts and drill to the levels they have access to.
  • Any user can see all data in a user-assigned sheet, including protected details.

Before You Begin

For required permissions, see each section in this article.

How You Get There

Navigation Icon5.png For navigation, see each section in this article. 

Basic Steps to Protect Sensitive Data

  1. Create a privileged role with the Access Salary Detail permission. Assign this role to the users who can see sensitive details.
  2. Protect accounts with the Contains Salary Detail setting.
  3. Protect modeled sheets with the salary detail property.
  4. Use best practices to secure the modeled sheet details.
  5. Share snapshots with privileged users only, using the shared report setting.

Create a Privileged Role

The salary detail settings are meaningful only if you limit the Access Salary Detail permission to select roles. 

Required Permissions: Admin Access > Roles and Admin Access > Users.

Navigation Icon5.png From the nav menu, select Administration > Roles and Permissions.

To create the role:

  1. Select the New Role button. You can also edit an existing role. 
  2. Enter a Role Name, such as Salary Detail, or Privileged Data
  3. Find and select the Access Salary Detail permission. 
  4. Add other permissions that allow users with this role to view and edit sheets, reports, and charts. 
  5. Select Submit

To assign the role to users:

  1. From the list of roles, select the Assign link next to the new role.  
  2. Select each user from the list in the left container and click the arrow to add it to the list in the right container.
  3. Select Submit

Protect General Ledger and Custom Account Splits

If your salary account is a general ledger or custom account, select the Contains Salary Detail checkbox in the account setting.

When the Contains Salary Detail account setting is on, users without the Access Salary Detail permission can only see the account total in sheets, reports, and charts. They can drill through time and levels, but not through dimensions and splits. Users must have this permission to drill or explore contributing values and splits.

To protect modeled accounts, see the instructions in this article for protecting modeled sheets. 

Account Best Practices 

Cube accounts: You can't protect cube accounts or cube sheets. Sensitive accounts should be general ledger, custom, or modeled so that you can protect the data.

Linked Accounts: If you link the accounts, the Contains Salary Detail setting is read-only and depends on the source account. If you link to a modeled account in a protected modeled sheet, the setting is activated. If you link to a cube account or modeled account that's not in a protected sheet, the setting is off.

Master Formulas: If you use a protected account in the master formula or shared formula, you don't need the Contains Salary Detail setting to protect the account details . If you leave it off, users without the permission can explore the data of the linked account until they reach the protected account. 

Activate the Account Setting

Required permission: Access Model Management > Model 

Navigation Icon5.png From the nav menu, select Modeling.

  1. Select General Ledger Accounts or Custom Accounts. Your salary account may be either. 
  2. Select you salary account from the account list.
  3. In the settings on the right, find the Data Privacy section and select Contains Salary Detail radio button. 
  4. Save.  

Salary detail account setting.png

Protect Modeled Sheets

If your instance uses a personnel modeled sheet, activate the salary detail sheet property. 

This allows only users with the Access Salary Detail permission to open the sheet. Users without the permission cannot see the sheet. 

Best Practice with Dimensions and Modeled Accounts

Add custom dimensions to protected modeled sheets carefully.

Users without the Access Salary Detail permission can explore the data of protected modeled accounts in sheets, reports, and charts. They can only explore through time and levels. They can't see the dimension break down, which is considered a detail.

However, in reports, anyone can drag custom dimensions into a report. This breaks down the data of protected modeled accounts by dimension, potentially exposing data that you want to protect.

For example, a dimension for regions in personnel sheet lets users tag each employee with a region. In reports, the dimension breaks down the salary account by region. This doesn't expose sensitive data. 

A dimension for employee names or employee titles in personnel sheets lets users in the sheet tag each row with a name or title. In reports, the dimension breaks down the salary account by name, exposing the salary of individuals, or by title, exposing the salary of groups or individuals. 

 Best Practice: In your protected modeled sheets, don't use custom dimensions for sensitive data, such as employee names, titles, etc. Use data entry columns to keep the data protected.

Activate the Sheet Setting

Required permissions: Access Model Management > Model and Access Salary Detail.

Navigation Icon5.png From the nav menu, select Modeling.

  1. Select Level Assigned Sheets. 
  2. From the sheet list, select the Edit link next to the name of your personnel sheet.
  3. Select Columns and Levels
  4. From the toolbar, select Sheet Properties reportProperties.png
  5. Select the Security tab and check Viewing this sheet or any of its rows requires Salary Detail permission
  6. Save the sheet. 

The Contains Salary Detail setting of all its accounts are now activated and read-only: 

Salary Detail Read Only.png

If you use the accounts in reports and charts or link other accounts to the modeled accounts, only users with the permission can explore the data. Those without the permission can view only the totals.

Protect Snapshot Reports

Snapshot reports allow you to share reports exactly as you see them with others who have different access controls. This can potentially expose sensitive data. The salary detail snapshot setting protects the snapshot so that only users with the permission can open the report. 

Share a Protected Snapshot

Required permission: Access Reports > Create Shared Reports.

Navigation Icon5.png From nav menu, select Reports

  1. Either build a new report and save or open an existing report that you want to share.
  2. From the toolbar, select Save as Snapshot.
  3. Select the Shared report radio button. 
  4. Select File only available to users who can view salary detail checkbox. 
  5. Save. 

Only users with the permission can find the snapshot in the reporting shared folder. 

  • Was this article helpful?