about Binding an Attribute to NameColumn and Binding an Attribute to KeyColumn

Question

I recently started learning SSAS. While trying to understand the Attribute properties, I came across two features under the source:

1. KeyColumn
2. Name Column; when browsed about them in microsoft SSAS documentation, I came across

"Bind An Attribute to a Name Column" and "Bind an Attribute to a Key Column" . I didn't understand the objective of 'Binding' here? Can anyone help me understand. Below are the links for the documentation source:

https://learn.microsoft.com/en-us/analysis-services/multidimensional-models/attribute-properties-bind-an-attribute-to-a-key-column?view=asallproducts-allversions

https://learn.microsoft.com/en-us/analysis-services/multidimensional-models/attribute-properties-bind-an-attribute-to-a-name-column?view=asallproducts-allversions

Answer 1

Hi,

The "binding" here in this context means to point(set) an column from DSV tables as Key Column/Name Column of the dimension attribute.

You could understand the process better by changing it in the test cube project.

And also key column / name column are important concept in Multidimensional Cube. You could find more description and info in this article :SQL Server Analysis Server (SSAS) KeyColumn vs NameColumn vs ValueColumn

Regards,
Lukas