Skip to content

Latest commit

 

History

History
49 lines (31 loc) · 2.65 KB

attribute-properties-modify-the-keycolumn-property.md

File metadata and controls

49 lines (31 loc) · 2.65 KB
Raw
title description ms.date ms.service ms.custom ms.topic ms.author ms.reviewer author
Modify the KeyColumn Property of an Attribute | Microsoft Docs
Modify the KeyColumns property of an attribute, for example to specify a composite key instead of a single key as the key for the attribute.
05/02/2018
analysis-services
multidimensional-models
conceptual
kfollis
kfollis
kfollis

Attribute Properties - Modify the KeyColumn Property

[!INCLUDEappliesto-sqlas] You can modify the KeyColumns property of an attribute. For example, you might want to specify a composite key instead of a single key as the key for the attribute.

To modify the KeyColumns property of an attribute

  1. In [!INCLUDEssBIDevStudioFull], open the project in which you want to modify the KeyColumns property.

  2. Open Dimension Designer by doing one of the following procedures:

    • In Solution Explorer, right-click the dimension in the Dimensions folder, and then either click Open or View Designer.

      -or-

    • In Cube Designer, on the Cube Structure tab, expand the cube dimension in the Dimensions pane and click Edit <dimension>.

  3. On the Dimension Structure tab, in the Attributes pane, click the attribute whose KeyColumns property you want to modify.

  4. In the Properties window, click the value for the KeyColumns property.

  5. Click the browse (...) button that appears in the value cell of the property box.

    The Key Columns dialog box opens.

  6. To remove an existing key column, in the Key Columns list, select the column, and then click the < button.

  7. To add a key column, in the Available Columns list, select the column, and then click the > button.

    [!NOTE]
    If you define multiple key columns, the order in which those columns appear in the Key Columns list affects the display order. For example, a month attribute has two key columns: month and year. If the year column appears in the list before the month column, [!INCLUDEssASnoversion] will sort by year and then by month. If the month column appears before the year column, [!INCLUDEssASnoversion] will sort by month and then by year.

  8. To change the order of key columns, select a column, and then click the Up or Down button.

See Also

Dimension Attribute Properties Reference