Walkthrough: Analyzing Cube Data in Microsoft SQL Server Business Intelligence Development Studio
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 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.
Prerequisites
To complete this walkthrough, you will need:
The General Ledger default cube, deployed and processed.
Configure Analysis Services by running the Microsoft Dynamics AX Setup wizard
Microsoft SQL Server Business Intelligence Development Studio
Analyzing Cube Data in Microsoft SQL Server Business Intelligence Develpment Studio
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.