Home / All Courses / Microsoft / Microsoft Dynamics / 80318: Reporting in Microsoft Dynamics AX 2012

80318: Reporting in Microsoft Dynamics AX 2012 Training & Certification Course

Overview

This two-day course with an introduction to the reporting and business intelligence features and functionality in Microsoft Dynamics AX 2012. The purpose of 80318: Reporting in Microsoft Dynamics AX 2012 course is to introduce key features, explain the reporting architecture, and describe the procedures for common reporting tasks.

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.

Required:

80300: Introduction to Microsoft Dynamics AX 2012

Prerequisite

Basic understanding of Microsoft Dynamics AX 2012, Knowledge of any Programming Knowledge

Full Description

 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 centres 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

  1.  Introduction
  2.  Installation
  3.  Report Development Tools
  4.  Develop Reports
  5.  Deploy Reports
  6.  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

  1.  Introduction
  2.  Analysis Overview
  3.  Installation and Configuration
  4.  Develop Cubes
  5.  Define KPI to Display in Role Center
  6.  Develop a Report to Display in Microsoft Dynamics AX 2012
  7.  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 centre.

Lessons

  1.  Introduction
  2.  Enterprise Portal Improvements
  3.  Install Enterprise Portal and Role Centers
  4.  Modify Existing Role Centers
  5.  Create New Role Center
  6.  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

Fees & Schedule

Delivery ModeCourse DurationFees
Live Virtual Training 2 DaysAsk for Quote
Onsite Classroom Training 2 DaysAsk for Quote
Customized Training 2 DaysAsk for Quote

FAQ's

SpireTec solutions is the latest technology enabled I.Tmanagement training company specialized in offering 1500+ courses with the state of art training facilities backed by a team of industry experts in various domains with assuring best quality services.
Since SpireTec provides 24X7 training and support for your training needs is very adaptable to your time availabilities and offers customized training programs according to your availability and time zones of your contingent.
Because SpireTec aims for the personal & professional growth of you as individual & corporate as a whole, providing training on the latest and updated versions in the designated domains.
It is preferable but not mandatory to have domain experience in the area of your interest in which you want to opt training, supported by good English communication skills, a good Wi-Fi and computer or laptop system in case you want remote training
Spire Tec aims and ensure to offer finest and world-class training to the participants by giving them a proper counselling and a guided career path by our industry experts which leads guaranteed success for you in the corporate world
We offer online training (1-1, Group training), Classroom training, Onsite training with state of art facilities.
You can make payment online via PayPal with any of the debit & credit cards or via direct bank transfer.