Manage and Reset Default Security Predicates for Sales Analytics Datasets

This article explains how to remove and replace security predicates for Sales Analytics datasets in CRM Analytics Analytics Studio.

Removing the Security Predicate:

1. In Analytics Studio, hover over the target dataset and click the Edit link that appears.
2. Clear the contents of the Security Predicate field. Back up the current contents if you have customized them.
3. Click Update Dataset.
4. Refresh the app to apply the updated security predicate to your session. If a refresh does not work, log out and log back in to start a new session.

Replacing the Security Predicate:

To restore a dataset's security predicate, use the default values listed below for each Sales Analytics dataset.

Opportunities, Events, Tasks: The default security predicate is:

'Owner.Role.Roles' == "$User.UserRoleId" || 'OwnerId' == "$User.Id" || 'Account.OwnerId' == "$User.Id"

Quota with Users, User Allocation: The default security predicate is: 

'Role.Roles' == "$User.UserRoleId" || 'Id' == "$User.Id"

Users: The default security predicate is: 

'User.Role.Roles' == "$User.UserRoleId" || 'User.Id' == "$User.Id"

Opportunity Products, Pipeline Trending: The default security predicate is:

'Opportunity.Owner.Role.Roles' == "$User.UserRoleId" || 'Opportunity.OwnerId' == "$User.Id" || 'Opportunity.Account.OwnerId' == "$User.Id"