Skip to main content

#Trailhead Challenges토론 중인 항목 1,697개

Hands-on challenges are the “secret sauce” of Trailhead. Before searching for solutions to superbadge challenges, review the Salesforce Certification Program Agreement and Policies. ** NOTE ** : If you were able to get a response that solved your issue, please mark it as the 'Best Answer' to help other Trailblazers. If the issue persists after 48 hours, create a Trailhead Help case at https://help.salesforce.com/s/support for further assistance.

We have around 900 users in the system, and out of those, approximately 130

users have CPQ access and can view CPQ-related data. 

 

However, many users who do not have CPQ access also require visibility to these reports. Could you please suggest how we can provide CPQ report record access to non-CPQ users without granting them full CPQ access? 

 

Please advise on the best possible approach. 

 

#Trailhead Challenges

답변 2개
  1. 5월 26일 오후 12:00

    @Kiran Kharade - Vashi Integrated Solution Ltd depends on what you mean by "view CPQ report data."

    If the users need to open reports that are built directly on CPQ objects such as CPQ Quotes, Quote Lines, Subscriptions, Contracts, or other SBQQ__ package objects, then report folder access alone will not solve it. They still need the required object, field, record, and package/license access behind those reports. Salesforce’s CPQ permissions guidance states that CPQ access is controlled through CPQ licenses and package-specific permission sets (Get Started with Salesforce CPQ Permissions)

     

    Recommended option is to give CPQ licenses only to users who need direct access to CPQ records, then create a restricted read-only permission model for them as much as CPQ allows.

     

    For non-CPQ users, the safer approach is not to expose the CPQ objects directly. Create a separate reporting layer, such as a custom reporting object, summary object, scheduled snapshot, CRM Analytics dataset, or exported BI dataset, containing only the fields they are allowed to see. Then report on that object/dataset instead of the live CPQ package objects. That gives visibility without opening full CPQ record access.

     

    A dashboard with a running user may work for high-level summary visibility, but it should not be treated as a clean replacement for proper CPQ licensing or record access, especially if users need to drill into report details. 

     

    My recommendation is: direct CPQ report access usually requires CPQ access. For non-CPQ users, create a controlled summary/reporting layer and expose only the required CPQ data there. 

0/9000
0/9000
답변 2개
  1. 2월 13일 오후 5:39

    Hi @Angel Corpuz

     

    In Salesforce Marketing Cloud, while you can technically use CC, it is not recommended for large datasets. CC is meant for limited or internal use and can create deliverability, tracking, and privacy issues at scale. The best practice is to include all recipients in a sendable Data Extension and send personalized emails directly, which ensures better performance, accurate reporting, and compliance. 

0/9000

Hello, I have the following problem and would greatly appreciate your help.

There is a simple sales ranking of sales representatives. The representative who achieves the highest sales growth (2026 vs. 2025) receives 10 points, the next one receives 9 points, and so on, with the lowest-performing representative receiving 1 point.

Each sales representative has access to Tableau dashboards, but only for their own sales data. How can I create a calculation that allows them to see their position in the ranking?

In other words, when a representative (e.g., representative J) logs into Tableau, they can see their number of points (e.g., 8), but they cannot see other representatives' data. 

 

 

How to make a ranking position

 

 

 

#Trailhead Challenges

답변 2개
  1. 3월 24일 오전 10:43

    Yes, this is possible in Tableau, but there is one important limitation: if each sales representative is restricted by user-level security to see only their own data, Tableau cannot calculate a true rank across all representatives inside that same filtered view, because the other representatives are removed before the rank is calculated. 

     

    The usual solution is to calculate the ranking before row-level security is applied. For example: 

     

    1. Create a separate aggregated table or data source that stores each representative’s sales growth and assigned points.
    2. Calculate the rank in that source using all representatives’ data.
    3. Then use user-based filtering so each logged-in representative only sees their own final rank/points row.

    Another option is to calculate the ranking in the database or ETL layer and expose only: 

     

    • Representative name/login
    • Growth %
    • Rank
    • Points

    Then, in Tableau, filter by the logged-in user using USERNAME().

    So the key idea is: 

    Rank must be precomputed on the full dataset, then Tableau can securely show only the logged-in user’s own position.

0/9000
답변 5개
  1. 1월 13일 오전 11:47

    Hi @Amrita Sinha

    ,  This usually happens if the dashboard references reports, datasets, or folders with restricted permissions, or if a recent refresh broke references. Check that you have create/modify access on the folder, all underlying reports exist, and datasets are accessible. If cloning still fails, try saving a copy with a new name or recreate the dashboard using the existing components.  

     

    Mark if it is useful...

0/9000