Course Overview
This training provides an introduction to the reporting and business intelligence features and functionality in Microsoft Dynamics AX 2012 R3 CU8. The purpose of this training is to introduce key features, explain the reporting architecture, and describe the procedures for common reporting tasks.
Course Outline
Module 00: Course Introduction
Module 01: Overview
Module 02: SQL Server Reporting Services (SSRS)
Module 03: SQL Server Analysis Services (SSAS)
Module 04: Enterprise Portal and Role Centers
Course Objectives
Identify available BI features in AX.
Explain how to select the right BI tool in AX based on the customer scenario.
Explain how to use List Pages to retrieve data from AX
Use the Auto-Report framework to build reports from List Pages.
Demonstrate how to use Microsoft Excel to develop an ad-hoc report against transactional data in AX.
Demonstrate how to use the Office add-ins for Microsoft Dynamics AX 2012 R3 CU8.
Demonstrate how to execute a report and run reports in Batch mode.
Describe the out of the box reports that exist in AX.
Describe the data sources that AX Reports support.
Explain the architecture of reporting in AX.
Describe the SQL Server Reporting Services installation procedure and prerequisites.
Identify the tools used to develop and deploy reports for Microsoft Dynamics AX 2012 R3 CU8.
Explain the process for developing reports by using Visual Studio.
List the three options for deploying reports.
Describe Native mode and SharePoint Integrated mode for configuring reporting in AX.
Create reports using AX queries.
Create reports using Business Logic in X++.
Describe the advanced report artifacts, and how to use Data Contracts and Controllers in Reports.
Demonstrate how to use Report Parameters within reports.
Explain how to use Style Templates.
Describe the difference between auto designs and precision designs.
Develop reports using precision designs.
Describe how to build drill through capabilities in reports.
Develop reports that use data methods.
Explain how to integrate reports with X++.
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 SQL Server Data Tools.
Display data in a Role Center web part using SQL Server Analysis Services.
Create a report in AX 2012 R3 CU8 that uses data from a SQL Server Analysis Services cube.
Analyze cube data using Microsoft Excel.
Describe how to define security on a SQL Server Analysis Services Cube built for AX.
Identify the web parts available in Enterprise Portal.
Modify existing role centers.
Create new role centers.
Develop Power View reports and integrate them into role centers.
Integrate reports into role centers.
Pre-requisites
80692AE: Introduction to Microsoft Dynamics AX 2012 R3 CU8