Monday, July 16, 2018

Report Development Tools

Several tools are available to help you create reports, configure data sources, and
deploy and display report data in Microsoft Dynamics AX 2012. Integration
between these tools makes report development more streamlined than ever and
reduces the time that is required to create and modify reports.


MorphX and the Application Object Tree

MorphX is the integrated development environment that is included in Microsoft
Dynamics AX 2012. The programming language X++ is used within the MorphX
development environment. X++ is an object-oriented programming language that
is used to develop the objects that are used in the Microsoft Dynamics AX
application.


The Application Object Tree (AOT) holds all the application objects that are used
to build Microsoft Dynamics AX. The AOT contains objects that will be used to
collect data for a report and objects that give users access to display reports.
The objects in the AOT are grouped into nodes according to their type. The AOT
objects include:


Tables - made of fields that contain business data

Views - grouped data from multiple tables

Classes - source code for application logic

Visual Studio Projects - report definitions copied from Visual Studio

Queries - select data to display in a form or in a report

Menu items - used to access reports and forms

Menus - groups of menu items

Other objects in the AOT are used to manage application processes and for
various other functions.
When you develop a report, objects from the AOT will be used to access data and
to display the reports.


Visual Studio

Microsoft Visual Studio is an integrated development environment that is used to
develop applications. Development in Visual Studio can be done using Visual
Basic, Visual C#, Visual C++, and other programming languages. Whereas many
development tasks in Microsoft Dynamics AX 2012 can be completed by using
X++ in the MorphX development environment or the Visual Studio development
environment, report development can only be done in Visual Studio.
 

Visual Studio consists of several features that support development of Microsoft
Dynamics AX applications. Visual Studio Tools for Microsoft Dynamics AX is a
collection of tools and functionality that allow you to manage code development
for Microsoft Dynamics AX. Visual Studio Tools integrates Microsoft Dynamics
AX with Visual Studio. Objects that are developed in Visual Studio can be saved
to the AOT and AOT objects can be used in Visual Studio development projects.




Application Explorer is a tool in Visual Studio that provides a view into the AOT
in Microsoft Dynamics AX. In Application Explorer, you can view and debug
X++ code in the AOT.


Solution Explorer displays a collection of items for a specific solution. A solution
contains one or more projects, and a project contains one or more items. From
Solution Explorer, you can open files for editing, add new files to a project, and
view solution, project, and item properties.
 

SQL Server Reporting Services

SQL Server Reporting Services (SSRS) provides tools and services to help you
create, deploy, and manage reports. SSRS also provides programming features
that allow you to extend and customize your reporting functionality.
Reporting Services is a server-based reporting platform that provides
comprehensive reporting functionality for a variety of data sources. Reporting
Services includes a complete set of tools for you to create, manage, and deliver
reports, and provides APIs that enable developers to integrate or extend data and
report processing in custom applications. Reporting Services tools work within
the Microsoft Visual Studio environment and are fully integrated with SQL
Server tools and components.


With Reporting Services, you can create interactive, tabular, graphical, or freeform reports from relational, multidimensional, or XML-based data sources. You
can publish reports or access reports on demand. Reporting Services also enables
you to create customized reports based on predefined models, and to interactively
explore data within the model. Additionally, you can select from a variety of
viewing formats or export reports to other applications. The reports that you
create can be viewed over a web-based connection or as part of a Microsoft
Windows application or SharePoint site.


SQL Server Analysis Services

Microsoft SQL Server Analysis Services (SSAS) delivers online analytical
processing (OLAP) and data mining functionality for business intelligence
applications. Analysis Services supports OLAP by letting you design, create, and
manage multidimensional structures that contain data that is aggregated from
other data sources, such as relational databases. For data mining applications,
Analysis Services lets you design, create, and visualize data mining models that
are constructed from other data sources by using a wide variety of industrystandard data mining algorithms


Analysis Services helps you analyze large quantities of data. With it, you can
design, create, and manage cubes that contain detail and aggregated data from
multiple data sources.
For more information, see Chapter 3: SQL Server Analysis Services of this
manual.
 

Business Intelligence Development Studio

Business Intelligence Development Studio is Microsoft Visual Studio 2008 with
additional project types that are specific to SQL Server business intelligence.
Business Intelligence Development Studio is the primary environment that you
will use to develop business solutions that include Analysis Services and
Integration Services projects. Each project type supplies templates for creating
the objects that are required for business intelligence solutions, and provides a
variety of designers, tools, and wizards to work with the objects.
 


Best Regards,
Hossein Karimi

No comments:

Post a Comment

Configure the Firewall on the Enterprise Portal Server

After you install Enterprise Portal, enable Web Server (HTTP) in Windows Firewall. If you do not enable the web server in Windows Firewall...