You are building a Microsoft SQL Server Analysis Services multidimensional model over a SQL Server database. In a cube named OrderAnalysis, there is a standard cube dimension named Stock Item.
This dimension has the following attributes:
Stock Item KeyWWI Stock Item ID
Stock Item
Color
Selling Package
Buying Package
Brand
Size
Lead Time Days
Quantity Per Outer
Is Chiller Stock
Barcode
Tax Rate
Unit Price
Recommended Retail Price
Typical Weight Per Unit
Photo
Valid From
Valid To
Lineages Key
Users report that the attributes Stock Item Key and Photo are distracting and are not providing any value. They have asked for the attributes to be removed. However, these attributes are needed by other cubes.
You need to hide the specified attributes from the end users of the OrderAnalysis cube. You do not want to change the structure of the dimension.
Which change should you make to the properties for the Stock Item Key and Photo attributes? property is set to False, the attribute hierarchy is not created and the attribute cannot be used as a level in a user hierarchy; the attribute hierarchy exists as a member property only. However, a disabled attribute hierarchy can still be used to order the members of another attribute. If the value of the AttributeHierarchyEnabled property is set to True, the value of the AttributeHierarchyVisible property determines whether the attribute hierarchy is visible independent of its use in a user-defined hierarchy.
A.
Set the AttributeHierarchyVisible property to False.
B.
Set the AttributeHierarchyEnabledproperty to False.
C.
Set the AttributeVisibility property to Hidden.
D.
Set the Usage property to Regular.
E.
Set the AttributeHierarchyDisplayFolder property to Hidden.
Explanation:
The value of the AttributeHierarchyEnabled property determines whether an attribute hierarchy is created. If this
References:https://technet.microsoft.com/en-us/library/ms166717(v=sql.110).aspx