80318A: Reporting in Microsoft Dynamics AX 2012

Module 1: Overview
This module provides a general overview of the features and functionality of Reporting and Business Intelligence in Microsoft Dynamics AX 2012.
Lessons
- Introduction
- SQL Server Reporting Services
- SQL Server Analysis Services
- Microsoft Dynamics AX Role Center
After completing this module, students will be able to:
- Identify available reporting features in Microsoft Dynamics AX 2012
- Explain how reporting features are used in Microsoft Dynamics AX 2012
- Explain how role centers make use of other reporting features in Microsoft Dynamics AX 2012
Module 2: SQL Server Reporting Services
This module defines the reporting architecture, describes the development tools and explains procedures for developing reports.
Lessons
- Introduction
- Installation
- Report Development Tools
- Develop Reports
- Deploy Reports
- Integrate SSRS with Microsoft Dynamics AX 2012
Lab : Create a Simple Report
- Create a Query
- Create a New Report in Visual Studio
- Apply Layout Template
- Add Column Sorting
- Group Report Data
- Filter Report Data
- Add a Dynamic Parameter
- Save and Deploy the Report
- Display the Report in Microsoft Dynamics AX 2012
Lab : Create a Report with X++ Business Logic
- Create a Temporary Table
- Define a Report Provider Class
- Define a Data Contract Class
- Define a Data Contract Method
- Define a Method to Return Data to Reporting Services
- Add Business Logic for the Report
- Create a Reporting Project
- Bind a Report to a Report Data Provider Class
After completing this module, students will be able to:
- Describe the SQL Server Reporting Services installation procedure and prerequisites
- Identify the tools used to develop and deploy reports for Microsoft Dynamics AX 2012
- Explain the process for developing reports by using Visual Studio
- List the three options for deploying reports
- Describe how SSRS reports can be used within Microsoft Dynamics AX 2012
Module 3: SQL Server Analysis Services
This module describes business analysis features, defines analysis cube structure and demonstrates the process for creating cubes and using cube data in reports.
Lessons
- Introduction
- Analysis Overview
- Installation and Configuration
- Develop Cubes
- Define KPI to Display in Role Center
- Develop a Report to Display in Microsoft Dynamics AX 2012
- Analyze Cube Data
Lab : Create a Report Using Cube Data
- Create a report using OLAP data
After completing this module, students will be able to:
- Provide an overview of SQL Server Analysis Services features and capabilities
- Describe the SQL Server Analysis Services installation procedure and prerequisites
- Develop cubes by using Business Intelligence Development Studio
- Display data in a Role Center web part using SQL Server Analysis Services
- Create a report in Microsoft Dynamics AX 2012 that uses data from a SQL Server Analysis Services cube
- Analyze cube data
Module 4: Enterprise Portal and Role Centers
This module provides a list of Enterprise Portal improvements, describes the Enterprise Portal installation procedure, and demonstrates how to modify or create a role center.
Lessons
- Introduction
- Enterprise Portal Improvements
- Install Enterprise Portal and Role Centers
- Modify Existing Role Centers
- Create New Role Center
- Troubleshooting
Lab : Create a Report to Display in a Role Center
- Define a Query
- Create a Reporting Project
- Create a Report
- Configure Report Parameters
- Apply Layout and Style Templates
- Create a Menu Item
- Create a Role Center
- Add Report to Role Center
After completing this module, students will be able to:
- Describe Enterprise Portal improvements
- Install Enterprise Portal and role centers
- Modify existing role centers
- Create new role centers
- Troubleshoot issues with role centers