Course Content
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
Module 2: SQL Server Reporting Services
This module defines the reporting architecture, describ es 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
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
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 Lay out and Style Templates
Create a Menu Item
Create a Role Center
Add Report to Role Center