SSAS - Dimensions - Natural and Un-Natural Hierarchy

Refer Source: SSAS - Dimensions - Natural and Un-Natural Hierarchy 3

DimProduct

Key Columns:ProductKey
Name Column:English Product Name

(Descriptive Value)

note:automatically adds the related tables.

note: can add "Filter" to the dimension.

ProductKey:Properties

KeyColumn:  Name Column:

DimProduct: ( in the Dimension "Property")

UnknownMember:Visible
UnknownMemberName: UnknownValue

Note:

Attributes   Hierarchies  Data Source View (DSV)

note:
i.Hierarchies are build from Dimensions.
ii.After Hierarchies are build, in the browser those will show, along that "Dimensions" same attributes will show too, so on the Dimension , properties, "AttributeHierarchyVisible:false.
iii. In "Dimension" properties,  for unknown members
UnknownMember:visible
UnknownMemberName: UnknownValue