In CRM Analytics, you can control the visibility of dashboards and other assets using the asset visibility feature. This allows the consultant to restrict access to specific assets (like dashboards) for certain groups of users, such as sales reps, without needing to duplicate datasets or move dashboards to another app. This is the most efficient way to manage access for dashboards in progress while allowing only sales managers to view the in-progress dashboards.

The issue with the security predicate not functioning as expected likely stems from a permissions issue related to the custom field Demographic__c on the User object. Here's a detailed explanation:
* Field-Level Security: If the sales reps do not have access to the Demographic__c field, the security predicate which references this field cannot execute properly as the system cannot evaluate the predicate without accessing the field.
* Permission Settings: Ensuring that the sales reps have the necessary permissions to view and use the Demographic__c field is crucial for the security predicate to function correctly.
* Data Visibility: The security model in CRM Analytics relies heavily on the underlying data permissions in Salesforce. If these permissions are not correctly configured, the expected data visibility through CRM Analytics will not be achieved.