Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

Salesforce Analytics-Con-301 Exam - Topic 4 Question 17 Discussion

A data analyst sets up a calculation to filter a dashboard so that it displays only the users' information. The dashboard will then be published to Tableau Cloud.The data analyst plans to use the following calculation to filter the data: USERNAME() = [Correct Answer]Which column in the table below should the data analyst reference in the calculation?
B) Email
A) Abbreviated Name
C) Lower case Name

Salesforce Analytics-Con-301 Exam - Topic 4 Question 17 Discussion

Actual exam question for Salesforce's Analytics-Con-301 exam
Question #: 17
Topic #: 4
[All Analytics-Con-301 Questions]

A data analyst sets up a calculation to filter a dashboard so that it displays only the users' information. The dashboard will then be published to Tableau Cloud.

The data analyst plans to use the following calculation to filter the data: USERNAME() = [Correct Answer]

Which column in the table below should the data analyst reference in the calculation?

Show Suggested Answer Hide Answer
Suggested Answer: B

When dashboards are published to Tableau Cloud, the function USERNAME() returns the user's Tableau Cloud username, which is the email address associated with their Tableau Cloud account.

Tableau documentation states:

On Tableau Cloud, the value returned by USERNAME() is always the user's email address.

Row-Level Security (RLS) is typically implemented using a comparison of USERNAME() to an email field in the data source.

For secure filtering, the field compared to USERNAME() must match the authentication identity exactly.

Looking at the provided table:

''Abbreviated Name'' contains short custom codes like ''SMiller,'' which do not match Tableau Cloud usernames.

''Lower Case Name'' contains names like ''sean miller,'' which also do not match Tableau Cloud usernames.

''Email'' contains the full email address for each user, such as ''Sean.Miller@superstore.com,'' which is the only field that corresponds to what USERNAME() returns in Tableau Cloud.

Therefore, the correct field to reference is Email.

Tableau Cloud authentication documentation stating USERNAME() returns the user's email address.

Row-Level Security setup guidance recommending the comparison USERNAME() = [Email Field].

Tableau security practices indicating only the email column will match USERNAME() values on Tableau Cloud.


Contribute your Thoughts:

0/2000 characters

Currently there are no comments in this discussion, be the first to comment!


Save Cancel