Export (0) Print
Expand All

Set Usage Property


Applies To: SQL Server 2016

You can set the usage for an attribute by using the Dimension Structure view in Dimension Designer, which is accessed from SQL Server Data Tools (SSDT).

When you set usage for an attribute, your changes do not take effect until you process the dimension. For more information, see Processing a multidimensional model (Analysis Services).

To set usage for an attribute

  1. In Solution Explorer, right-click a dimension, and click Open.

    The Dimension Structure view opens by default.

  2. In Attributes, right-click the attribute for which you which you want to set usage, point to Set Attribute Usage, and then click one of the following options:

    • Regular

    • Key

    • Parent

Attributes and Attribute Hierarchies
Add an Attribute to a Dimension

Community Additions

© 2016 Microsoft