Export (0) Print
Expand All

Modify the KeyColumn Property of an Attribute

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

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 SQL Server Data Tools (SSDT), 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.


    • 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 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, Analysis Services will sort by year and then by month. If the month column appears before the year column, Analysis Services 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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2015 Microsoft