Course 80318A:

Reporting in Microsoft Dynamics AX 2012

Length:2 Days
Published:December 05, 2011
Language(s):English
Audience(s):Information Workers
Level:200
Technology:Microsoft Dynamics AX 2012
Type:Course
Delivery Method:Instructor-led (classroom)
About this Course
This two-day instructor-led course provides students with an introduction to the reporting and business intelligence features and functionality in Microsoft Dynamics AX 2012. The purpose of this course is to introduce key features, explain the reporting architecture, and describe the procedures for common reporting tasks.
Audience Profile
The intended audience is customer system administrators, high level users, and consultants typically working for a Microsoft Dynamics partner that is selling, consulting, implementing, and supporting Microsoft Dynamics AX 2012.
At Course Completion
After completing this course, 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
  • 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
  • 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
  • Describe Enterprise Portal improvements
  • Install Enterprise Portal and role centers
  • Modify existing role centers
  • Create new role centers
  • Troubleshoot issues with role centers
Course OutlineModule 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 ServicesThis 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
80300: Introduction to Microsoft Dynamics AX 2012
Looking for training resources, events and advice from peers? Join the Microsoft Training and Certification Community. Preparing for an exam now? Find your Microsoft Certification Study Group. Talk to us on these social networks:

Find a Microsoft Learning Partner near you

Find Training Near You

Location:

Eg: Seattle, WA or Paris, France