Home / Courses / Microsoft Technology / 80318A: Reporting in Microsoft Dynamics AX 2012

Dynamics

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

 

Course Registration

 

2 days
$1,200.00

 

Course Outline

 

Request