You have a Power Pivot data model that contains a table named DimProduct. DimProduct has seven columns named ProductKey, ProductLabel, ProductName,
ProductDescription, ProductSubCategoryKey, Manufacturer, and Brand.
Only the members of the product team use all the data in the DimProduct table.
You need to simplify the model for other users by hiding all the columns except Product Name.
What should you do?
A. Create a perspective that has only the ProductName field from DimProduct selected.
B. Select all the columns in DimProduct except ProductName, right-click the columns, and then click Hide from Client Tools.
C. Edit the Table behavior settings for DimProduct and add ProductName to the Default Label.
D. Edit the Default Field Set for DimProduct and add ProductName to the Default Field.
