Edit

Share via

Database Dimensions - Browse Dimension Data in Dimension Designer

  • Article

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

You can browse the data in a dimension by using the Browser view in Dimension Designer, which is accessed from SQL Server Data Tools.

In order for dimension data to be displayed in the Browser view, the dimension must be in a processed state. For more information, see Processing a multidimensional model (Analysis Services).

To browse a dimension in SQL Server Data Tools

  1. Open the dimension that you want to browse, and click the Browser tab.

  2. In the Hierarchy drop-down list, choose the hierarchy for which you want to browse data.

  3. Optionally, if your dimension includes translations, in the Language drop-down list, choose the language in which you want to display the data.

    Note

    You must have a translation defined in the dimension for the selected language.

See Also

Introduction to Dimensions (Analysis Services - Multidimensional Data)
Dimensions in Multidimensional Models