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

ArunRaaman 996 Reputation points
2021-03-02T00:33:44.5+00:00

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

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,256 questions
0 comments No comments
{count} votes

Accepted answer
  1. Lukas Yu -MSFT 5,816 Reputation points
    2021-03-02T02:19:43.28+00:00

    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


0 additional answers

Sort by: Most helpful