How do i hide an attribute from appearing as a field when creating a pivot table.
e.g. i dont want the user to see the PK of a dimension. Thanks
Within SSAS, set teh AttributeHierarchyVisible value to false on the value of the dimension that you wish to hide from client tools. You will find this property available on each of the dimensions attributes.