80695AE: Reporting in Microsoft Dynamics AX 2012 R3 CU8 Training

• 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
• Identify available BI features in AX
• 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
• 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
• Develop Power View reports and integrate them into role centers
• Integrate reports into role centers
• 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
• 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 difference between Native mode and SharePoint Integrated mode for configuring reporting in AX

• Application Consultants
• Developers

• 80692AE: Introduction to Microsoft Dynamics AX 2012 R3 CU8

1. Overview

• Introduction to BI
• Overview of BI Tools
• Selecting the Right BI Tool
• List Pages
• Export to Microsoft Excel
• Auto Reports
• Build an Ad-hoc report in Microsoft Excel
• Working with Microsoft Word Templates
• Report Execution and Batch Printing
• Build a Report using SSRS
• Role Centers

2. SQL Server Reporting Services (SSRS)

• Out-of-the-box Content
• Report Data Sources
• Reporting Architecture
• Installation and Configuration
• Native Mode and Microsoft SharePoint Integrated Mode
• Report Development Tools and Process
• Creating Reports using AX Queries - Build Quer
• Creating Reports using AX Queries - Create Report
• Creating Reports using AX Queries - Add Dataset
• Creating Reports using AX Queries - Add Design
• Creating Reports using AX Queries - Preview and Customize
• Creating Reports using AX Queries - Integrate with AX
• Deploying Reports and Working with Static Reports
• Creating Reports using Business Logic
• Creating Reports using Business Logic - Temporary Tables
• Creating Reports using Business Logic - Create a Query
• Creating Reports using Business Logic - Create a Data Contract
• Creating Reports using Business Logic - Create a Report Data Provider
• Creating Reports using Business Logic - Create a Report
• Creating Reports using Business Logic – Summary
• Advanced Report Artifacts
• Customizing Reports
• Report Parameters - Introduction
• Report Parameters - Creating Parameters
• Report Parameters - Control Data and Presentation
• Report Parameters - Properties
• Report Parameters - Binding Parameters to Datasets
• Report Parameters - Securing Data
• Creating and Using Style Templates
• Auto versus Precision Reports
• Integrating Data From Multiple Data Sources
• Creating a Drill Through Report
• Shared Library and Shared Components
• Creating a Column Chart Report
• Migrating Reports from X++ to SSRS
• Interacting with Reports using X++
• Working with Data Methods

3. SQL Server Analysis Services (SSAS)

• Overview of SSAS and Cube Structure
• Installation and Configuration
• Out-of-the-box Content
• Exploring data using Microsoft Excel
• Developing New Cubes
• Customizing Existing Cubes
• Cube Security
• Advanced Analytics using Power BI
• Creating Reports using Cube Data

4. Enterprise portal and Role Centers

• Out-of-the-box Content
• Installation and Configuration
• Enterprise Portal Web Parts
• Customization and Personalization of Role Centers
• Creating new Role Centers
• Integrating Power BI into Role Centers
• Integrating Reports into Role Centers