Attribute Properties - Set Usage Property

Applies to: SQL Server Analysis Services Azure Analysis Services Fabric/Power BI Premium

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.

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

See Also

Attributes and Attribute Hierarchies
Add an Attribute to a Dimension