Walkthrough: Analyzing Cube Data in Microsoft SQL Server Business Intelligence Development Studio [AX 2012]
Updated: July 17, 2013
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 Business Intelligence Development Studio (BIDS) to analyze a Microsoft Dynamics AX analysis cube.
Note |
|---|
| In SQL Server 2012, BIDS is called SQL Server Data Tools. |
To analyze the General Ledger cube data by using BIDS you must open the Analysis Services project that contains the General Ledger cube.
To analyze cube data
-
In BIDS, open the Analysis Services project that contains the General Ledger cube.
-
In Solution Explorer, double click Dynamics AX > Cubes > LedgerCube.cube.
Note If you are using Microsoft Dynamics AX 2012 R2, double click Dynamics AX initial > Cubes > LedgerCube.cube.
-
Click the Browser tab.
-
Drag General ledger cube > Measures > Ledger transactions > General ledger amount – transaction currency onto the Drop Totals or Detail Fields Here area.
-
Drag a financial dimension onto the Drop Row Fields Here 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.
-
Browse the data.
