Analyze Cube Data with Management Studio

Hossein.K

6,642

Like ( 0 )

Report

Data can be analyzed by using Microsoft SQL Server Management Studio to connect to a Microsoft Dynamics AX OLAP cube.
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.
Follow these steps to analyze cube data:

1. Open Microsoft SQL Server Management Studio.

2. On the Connect to Server page, for the Server type field, select Analysis Services. Enter the name of the server that contains the Analysis Services database for the General Ledger cube, enter the
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 can vary.

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

5. In the General ledger cube [Browse] window, drag Chart of accounts > Main Account onto the row field area.

NOTE: The available dimensions will vary depending on your Analysis Services
Project.

6. Browse the data.