Arrays in Microsoft Dynamics Axapta 2012

Array is a list of items with the same datatype and the same name, Only the index differs

Arrays can be declared by brackets [ ]

real      MyArray[];                    //unlimited index value
real      MyArray1[15];              //maximum 10 index value

myarray[1] = 1.1;
myarray[2]= 1.2;

etc...

for [i =1; i <= 15; i++)
   {
      print MyArray1[i];
   }

A container variable can contain different types and value of simle and extended data types, including arrays

container  xyz;

int             a,b;
xyz = [15, 30, "SempleText"];
print compeek(xyz,3);

 

Characteristics of X++ in Axapta 2012

Reliable
     X++ provides extensive compile-time checking,
     Memory management model is simple,
     Object create by New operator,
     Automatic garbage collection
     Eliminates entire classes of programming errors

Interpreted and dynamic
     Benefit from faster developement cycle prototyping,
     Rapid developement and experimentation

Interoperable
     components in AX are seamlessly available to any application supporting .Net,
     conversely x++ is able to consume external managed code and COM objects.


 

Change the font style based on parameter in SSRS

How to change font style in SSRS 2008, SSRS 2012

               Like

               "Bold", "Normal", "Thin", ExtraLight", "Light", "Medium",
               "SemiBold", "Bold", "ExtraBold", "Heavy"



If your Parameter ShowSummary  = True than  change the Font Style to  "Normal" otherwise "Bold"

Step 1)

Create Parameter ShowSummary
Data type : Boolean
Default Values, Click Add and type True (Defining default Value = True)

Create New Parameter as ShowSummary, data type Boolean

Set default value as False so by default summary value will be False

Right click on your textbox, Select Textbox Properties, Select Font, Click on the Fx button besides Bold

as per the parameter value, show font type

Now run the reports, you can see that when you select show summary = true your text box font type appears "Normal" or it will show in "Bold "

Thanks



SSRS 2012 Report Parameter and multiple filter code

//Define Parameters as below

   MbooleamParaMtr             as Boolean
   MMultipleSelectionParam as Multiple secection Txt Parameter

// your selection criteria as below

  select field1, field2
  from
           Table1
where
           @MbooleamParaMtr = 1                       or
            field1 In (MMultipleSelectionParam)

Index was outside the bounds of the array

you may face this issue when axapta 2012 excel import of data


solution

check mandatory fields should be present in entity you are trying to import
 

Axapta 2012 Developer point of view

View

• Use tables and views to model data in perspectives
• Modeling data using views and tables makes it easier to customize cubes.

Analysis Services Project wizards

• Deploy default cubes.
• Use the Analysis Services project wizard to deploy an existing Analysis Services project. Choose the default cubes from the AOT.
• It is easier to deploy the default cubes.

Configure an Analysis Services project

• Use the Analysis Services project wizard to remove measures, dimensions, and KPIs that you do not have access to according to the license and configuration keys in Microsoft Dynamics AX.

Analysis Services project.

• It is easier to update an existing Analysis Services project.

ValidTimeStateFieldType

• select statement , validTimeState keyword to filter rows by date or date range, like ValidTimeStateFieldType property

Application programmers no longer have to track every detail of foreign key relationships when they perform a set of data modification calls. The UnitOfWork class helps enforce transaction integrity.

Prerequisite for Microsoft Dynamics Axapta 2012

Start with check of prerequisite for business intelligence components, select reporting services extension and click on validate

You notice the existing prerequisites that had been installed in this computer as well as missing, click on below error link

Error link showing error indicate I need to update Microsoft SQL server, I would need to have install cumulative update package3 for SQL Server 2008 r2

Also I would need to have Visual C++ 2008 SP1, Required Cumulative update 3 or higher if you are installing on Microsoft SQL Server 2008 r2 (You can download Cumulative Update package 3 for SQL Server 2008 r2 from http://go.microsoft.com/fwlink/?LinkeID=205864)

The reporting service integration not support to report server that is complicated one in SharePoint integrate, from start menu click on Reporting Services Configuration manager from configuration tools menu under Microsoft SQL Server 2008 r2 start menu

By launching this configuration utility we can verify to see whether or not the reporting service integration is set to SharePoint integrated or not

I select connect and choose Database

As seen below report server mode set to SharePoint integrated, we can either choose the AX database or another database selecting change Database

Axapta 2012 required Database could be on a dedicated box or on the same machine, for production environment it is recommended dedicated server

For the server components, needs Application Object Server (AOS) either installed in same box or on dedicated server, having multiple AOS speed up the operation and also allow to have a cluster environment.

Web server components and Enterprise Portal (EP) give you similar functionality to the client application over the web

Enterprise Search give you the capability to find different information in your environment either a client utility or Enterprise Portal (EP)

Business Intelligence components required reporting service extension to gives you the capability to create reports using visual studio

Analysis Services Configuration gives you capability to use OLAP and OLTP

Client components are necessary for dynamic AX users to able to access the Dynamic Features

Office Add-ins gives you the interaction between Microsoft Office products like excel and Dynamic

Remote Desktop Service integration gives you the capability to run dynamic AX client to use terminal services on operating system

For developer you need to install the developer tools, you have

Debugger

Visual Studio tools which gives capability to create visual studio project in C# and same into the AOT also to create Enterprise Portal using Visual Studio

Trace Parser gives you capability to troubleshooting to find out exactly how many problems do you have in regards to client to server and server to database communication also give you benchmark utility to allow you to find out performance related to those communication

For Integration Components

Web Services on IIS which is based on wcf

.NET Business Connector is a gateway between dynamics AX and Visual Studio or any third party language which allows you to run AX command from visual studio application or vise a versa between dynamics AX using X++ or MrophX called the .NET library Application

Synchronization proxy for Microsoft Project Server if you are going to manage your projects Microsoft project server is one of the products that Microsoft offers Dynamics Ax has the capability to synchronized all the project and associated task within Dynamics Ax , you can also provide project accountant in regards to manage in the cost of running the project.

Manage utilities uses the window power shell 2.0 to maintain the Dynamic Ax 2012 using the power shell options

Go ahead and check per-requisite for business intelligence components

 

 

 

 

 

 

 

 

 

Microsoft Messenger Queuing (MSMQ) server should be per-installed, it enables application running at different times to communicates across heterogeneous networks and system that may be temporarily offline. MSMQ provides message delivery Routing Security and priority-based messaging. It can be used for both asynchronous and synchronous messaging To install this feature, use Windows Server Manager, Right click Features and Click Add Features. In the Message Queuing node, expand Message Queuing Services and select Message Queuing Server and Directory Services Integration, Click Next and then click Install, you must restart the computer for the configuration to take effect., It is the windows part of the system.

 

 

 Check the client components and Development tools components

Network Requirements

   Axapta 2012 can operate on IPv4 or IPv6

   Network Reponse Time

             Between Cilent And Application Object Server (AOS) - 100 Mbps

             Between Application Object Server (AOS) to Database - 100 Mbps

 

In axapta 2012 Terminal Service is not Required, in WAN environment that uses legacy x++   Reporting, connect by using Windows Server Terminal Services or another Remote Connection Product

Domain

• Axapta 2012 installation requirement
• computer belongs to Active Directory Domain and the same configured in Native Mode
• computer have access to other computers in active directory, computer should be in same domain or in another trusted domain
• For Email alert SMTP server present in the environment

Hardware Requirements

• Processor - Intel Pentium/Celeron 1.1 ghz Xeon or Higher (Axapta do not support Itanium 64 bit processor)
• RAM - Server - 4gb or Higher depends on concurrent users and processing of transaction
• RAM - Client - 2gb or Higher
• DVD Drive
• Monitor - VGA minimum 1024x768 or higher resolution
• (for above actual requirement may change depends on Transaction, Concurrent Users, EP Users, Remote Client Users,  etc..)

Software Requirements

 

•  .NET Framework 3.5 SP1, .NET 4.0 required depends on additional requirement
•  Windows Installer 3.1 or 4.0

 

 Axapta Components requirements

•   Database
•   Application Object Server (AOS)
•   Enterprise Portal
•   Enterprise Search
•   Help Server
•   Microsoft SQL Server Reporting Services Extensions
•   Microsoft SQL Server Analysis Services Configuration
•   Web services on Internet Information Services (IIS)
•   Synchronization proxy for Microsoft Project
•   Management Utilities

Server Operating System (OS)

•   Windows Server R2 Std., Ent., Web, Datacenter
•   (only 64bit version of Windows Server 2008 are supported)
•   Windows Server 2008 std., Ent., Web edition , Datacenter with SP2

Software requirement for Database Server

 

•   MS SQL Server 2012 Std., Ent., or BI edition            or
•   MS SQL Server 2008 R2 Std., Ent., or Datacenter     or
•   MS SQL Server 2008, Std., Ent. with SP1
•   Required Hot Fix 2680186 of MS Dynamics AX
•   Only 64 bit of of SQL Server are supported
•   for more details minimum HW requirement for SQL server check  url  http://www.microsoft.com/sql/default.mspx
•   use latest cumulative updates for SQL server
•   Microsoft Dynamics AX supports Unicode collations
•   Install native client on AOS server if AOS server is separate from the database server
•   install SQL 2008, 2012 version of Native client

Additional Requirement

 

AOS

• .net 4.0 with hotfix 2390372
• SQL Server 2008 native client

EP

• web server role
• IIS 7.0 or IIS 7.5
• ASP.NET 2.0
• Microsoft SharePoint Foundation 2010 or
• Microsoft SharePoint Server 2010, Standard Edition or Enterprise Edition (recommended)
• SQL Server 2008 R2 Analysis Management Objects AMO
• Install SQL server 2008 AMO even if you are using SQl server 2012

Enterprise Search

• Web server role
• IIS 7.0 or IIS 7.5
• ASP.NET 2.0
• Windows PowerShell 2.0
• Microsoft Search Server 2010 or
• Microsoft Search Server Express 2010 or
• Microsoft Fast Search Server 2010 or
• SharePoint Server 2010,Standard Edition or Enterprise Edition (recommended)

Help Server

• Web server role
• IIS 7.0 or IIS 7.5
• ASP.NET 4.0

Reporting Services Extensions

• SQL Server 2012 Reporting Services or with Cumulative update 3 or a later update or with SP2
• It is must to install Microsoft Dynamics AX hotfix 2680186
• Windows PowerShell 2.0

Analysis Services Integration

• SQL Server 2012 Anylysis Services or with SQK 2008 R2 services or with SQL Server 2008 services
• SQL Server Management Studio
• SQL Server Business Intelligence Developement Studio

 

Webservices on IIS

• Web server role
• .NET Framework 4.0
• IIS 7.0 or IIS 7.5
• If you use web services to exchange documents with external partners, we recommend that you install the Windows SDK
• The Windows SDK contains tools that make it easier to configure Web services.
• SvcConfigEditor.exe graphical user interface (GUI) that you can use to create and modify configuration settings

Management utilities

• Windows PowerShell 2.0

Client Operating Systems requirement

• Windows 7 Professional Edition, Ultimate Edition, or Enterprise Edition, support 32-bit and 64-bit version
• Windows Vista Business Edition, Ultimate Edition, or Enterprise Edition, with Service Pack 2, support 32-bit and 64-bit version

Microsoft Dynamics AX client Software requirements

 

       Browser is required for Client Computer to access Enterprise Portal (EP)

• .NET Framework 4.0
• Internet Explorer 9.0 or Internet Explorer 8.0 or
• Mozilla Firefox 3.5 or
• Safari 5.1.2 (Enterprise Portal does not support Safari for developer or system administrator tasks)
• Microsoft Office 2007 release SP2 or Microsoft Office 2010 Office release ( MSOffice required for Outlook,Word, Excel integrations with AXAPTA.
• SQL Server 2008 R2 Analysis Management Objects (AMO), used to administer the OLAP database.

Virtual client support

Client for Axapta is certified to work as a virtual application on Microsoft Application Virtualization (App-V) 4.6. App-V transforms applications into virtual services. When an application is virtual, it is no longer installed on a user's computer. Therefore, the application does not conflict with other applications. Updates are centrally managed, so users do not get prompt for restarts.

 

 

Microsoft Dynamics AX for Retail

 

Software requirements to implement

 

• Retail Headquarters
• Retail POS (point of sale)
• Retail Store Connect
• Retail Transaction Service
• Retail Store Database Utility
• Retail POS Plug-Ins

Supported peripheral devices for Retail

• Cash drawers
• Receipt printers
• Line or pole displays
• Dual displays (with a second monitor that faces the customer)
• Magnetic stripe readers (MSRs)
• Bar code scanners
• Scales
• Keylocks (keyboard locks for manager override keys)
• Keyboards
• PIN pads

OPOS Common Control Objects, version 1.13, are required for peripheral devices

 

64-bit operating system support

• Application Object Server (AOS) - (Run on 32 bit is not recomanded)
• Windows client
• Office Add-ins
• Remote Desktop Services integrationVisual Studio Tools
• Enterprise Portal (no support to run on 32 bit)
• Reporting Services extensions (not recomanded to run on 32 bit)
• Visual Studio Tools