Database Dimensions - Browse Dimension Data in Dimension Designer

APPLIES TO:yesSQL Server Analysis ServicesnoAzure Analysis Services

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

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.


    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