Walkthrough: Analyzing Cube Data in Microsoft SQL Server Management Studio

  • Article

Important

This content is archived and is not being updated. For the latest documentation, see Microsoft Dynamics 365 product documentation. For the latest release plans, see Dynamics 365 and Microsoft Power Platform release plans.

Applies To: Microsoft Dynamics AX 2012 R2, Microsoft Dynamics AX 2012 Feature Pack, Microsoft Dynamics AX 2012

You can analyze data by using Microsoft SQL Server Management Studio to connect to a Microsoft Dynamics AX OLAP cube.

Prerequisites

To complete this walkthrough, you will need:

  • Microsoft Dynamics AX with sample data

  • The General Ledger default cube, deployed and processed. For more information, see Deploy the default cubes.

  • Configure Analysis Services by running the Microsoft Dynamics AX Setup wizard

  • Microsoft SQL Server Management Studio

Analyzing Cube Data in Microsoft SQL Server Management Studio

To analyze the General Ledger cube data by using Microsoft SQL Server Management Studio, you must connect to the cube data that is deployed and processed in a SQL Server Analysis Services (SSAS) database.

To analyze cube data

  1. Open Microsoft SQL Server Management Studio.

  2. On the Connect to Server page, select Analysis Services for Server type. Enter the name of the server that contains the Analysis Services database for the General Ledger cube, enter credentials used to access the server, and then click Connect.

  3. Right-click Databases > Dynamics AX > Cubes > General ledger cube and then click Browse.

    Note

    The name of the database that contains the General ledger cube may vary. For example, if you use Microsoft Dynamics AX 2012 R2, the database name is Dynamics AX initial by default.

  4. In General ledger cube [Browse], drag Measures > Ledger transactions > General ledger amount – transaction currency onto the data region area.

  5. Drag a financial dimension onto the row field area. If you included the Main account dimension in the Analysis Services project that contains the General ledger cube, use Main account OLAPMAINACCOUNT > Main account OLAPMAINACCOUNT.Main account.

    Note

    The available dimensions will vary depending on your Analysis Services project.

  6. Browse the data.

See also

Development Tasks for Analytics