A database named DB2 uses the InMemory query mode. Users frequently run the following query: You need to ensure no users see the PriorYearSales measure in the field list for the Sales table. What…

The correct answer is A. Create a perspective, and ensure that the PriorYearSales measure is not added to the. Using perspectives in the data model might help you expose a subset of tables, columns, and measures that are useful for a particular type of analysis. Usually, every user needs only a subset of data you create, and showing him or her the model through perspectives can offer a…

Implement a Comprehensive Datacenter Management Solution

Question

A database named DB2 uses the InMemory query mode. Users frequently run the following query: You need to ensure no users see the PriorYearSales measure in the field list for the Sales table. What should you do?

Options

ACreate a perspective, and ensure that the PriorYearSales measure is not added to the
BSet the Display Folder property for PriorYearSales toHidden.
CRemove the PriorYearSales measure from the default field set of the Sales table.
DCreate a role using Read permissions, and define a DAX expression to filter out the

How the community answered

(29 responses)

A
76% (22)
B
3% (1)
C
7% (2)
D
14% (4)

Explanation

Using perspectives in the data model might help you expose a subset of tables, columns, and measures that are useful for a particular type of analysis. Usually, every user needs only a subset of data you create, and showing him or her the model through perspectives can offer a better user experience. From scenario; The PriorYearSales measure is referenced by other measures, and is not intended to be analyzed directly by users.

Topics

#SSAS tabular#perspectives#measure visibility#field list

Community Discussion

No community discussion yet for this question.

Full 70-768 Practice