Monday 9 November 2015

Windows Azure for Dynamics AX - Foundational Learning for AX7


Get ready for the next AX release and grow your knowledge of Azure. This Topic Page covers baseline learning content across several core Azure product areas: IaaS, Hybrid Cloud (incl StorSimple), Performance, Developer, and Active Directory.

Microsoft Azure Trust Center
 The trusted cloud

Security and privacy are embedded into the development of Azure
Security: We work to keep your data safe
Privacy: You own and control your customer data
Transparency: You know how your data is stored and accessed, and how we help secure it
Compliance: We conform to global standards




Friday 6 November 2015

Dynamics AX -Intialization Checklist

Installing Dynamics AX is the first step of installation process. Follow the link to refresh the info about this process. After Dynamics AX is installed, it should be initialized. After the initialization, Dynamics AX should be populated with data (manually or by importing demo data). In this training lesson, we will go through Dynamics AX 2012 Initialization checklist. It is a common procedure for all versions of Dynamics AX. Let’s begin.
A license file is required to complete this lesson. If you have access to the Microsoft Partner or Customer sources, you can download the license file from here (the Demo Virtual Machine Licenses section). Microsoft has uploaded a new license file that expires on December 31, 2015.

Initialization checklist

Make sure that the Microsoft Dynamics AX object service is running in Windows services. Launch the Dynamics AX client. The Dynamics AX client with the Initialization checklist opens.
Check List First Time

Before you begin

When you expand the Before you begin node, you see the Lifecycle services and Customer feedback menu items. Click the Lifecycle services menu item. As a result, the node is marked as completed and you are proposed to join the Microsoft Lifecycle service. The service is more applicable for project management. It is optional and up to you to use it.
The Customer feedback menu item is also optional. You can click the Mark as complete menu item.
When both menu items are marked as complete, the Before you begin node is also marked as complete.
Check List Before You Begin

Compile

Open the Compile node. It contains two menu items: Compile applicationCompile into .NET Framework CIL. Both steps are mandatory and by the way time consuming.
Click the Compile application menu item. You are prompted that it can take long time. Click Yes. The system starts compiling the application. On average it takes up to 6 hours.
When the compilation process is finished, the Compile application menu item is marked as complete.
Click the Compile into .Net Framework CIL menu item. You are prompted that it can take long time. Click Yes. The system starts compiling CIL. On average it takes up to 30 minutes.
When CIL is compiled, the infolog with the information about the started services is shown. Now both menu items and parent node are marked as complete.
Check List Compile

Activate application functionality

Open the Activate application functionality node. It contains two menu items: Provide license informationConfigure application functionality.
I have downloaded the Dynamics AX license file from the Partner source.
Click the Provide license information menu item. The License information form opens. Click the Load license filebutton, select the license file, and click OK.
As a result, the Infolog with the messages appears and the License information form looks as follows:
License Information
On the Feature sets tab, you can find all modules that are enabled.
License Information Features Tab
TIP: If you want to disable some module, the easiest way is to clear the License code field. (You can reload the license file at any time).
Click the Configure application functionality menu item. The License configuration form opens. You can enable or disable some module features but you cannot disable the entire module.
Usually it is required to have either all module features or none. Use the tip above for instructions.
Click OK. We have both menu items and the node marked as complete.
Check List Activate Application Functionality

Configure data

Open the Configure data node. It contains three menu items: Modify data typesSynchronize databaseCreate partitions.
The Modify data types is an optional step. The user can change the default length of any data type. For example (from TechNet): To change the number of decimal values of the Amount data type, enter the number of decimal values you require in the Decimals field. If you change the number from 2 to 0, the amount that inherits from theAmount data type appears as 200 instead of 200.00. The change is reflected throughout the system where theAmount data type is used.
Each Dynamics AX table field should have a data type assigned.
Note that it is not about how this type is displayed rather how this type is stored in the SQL. So the TechNet explanation is a bit confusing.
For example the user specifies 20 decimals for the Amount data type. The customer transaction amount field uses the Amount data type. The customer transaction amount is saved in the SQL as 200.0000000000000000 (note there are no 20 decimals because the SQL maximum size of decimals is 16) and is shown to the User as 200.00.
Because the display format is set up in Windows:
  • Control Panel\Clock, Language, and Region
  • Change date, time or number format menu button
  • Additional settings button
  • of digits after decimal field
Click the Modify data types menu item. The Modify data types form opens.
Modify Data Types
Leave all values by default and click OK.
On the Synchronize database step, the system creates tables and views (CustTable, CustTrans, SalesTable etc) in the MicrosofDynamicsAX database from the metadata. For the DAX 2012R2 and above versions, the metadata is stored in the MicrosoftDynamicsAX_model database. For the lower DAX versions, metadata is stored in the same MicrosoftDynamicsAX database.
Click the Synchronize database menu item. The system starts synchronization. This is a time consuming process which usually takes up to 30 min.
Starting from DAX 2012 R2, the Create partitions menu item is added. For development, test, or education environments, it is enough to have one Initial partition that is created by default. Partition is a logical split of data. Data from different partitions is stored in the same database and tables use the same AOS instance. Each data contains information about its partition. Each user has access to one or many partitions.
Click the Create partitions menu item. The Partitions form opens. The form contains one default partition. Close the form.
As a result, we have all three menu items and the node marked as complete.
Check List Configure Data

Configure accounts and profiles

Open the Configure accounts and profiles node. It contains three menu items: Initialize user profilesSet up Application Integration FrameworkConfigure system accounts.
Click the Initialize user profiles menu item. The Initialize user profiles form opens.

Initialize User Profiles
Dynamics AX suggests creating listed user profiles (user roles) in the system.
For development, test, education environments, the SYSADMIN user role is used. This role is hardcoded and always exists in Dynamics AX. The user with the SYSADMIN role has the maximum permissions in Dynamics AX.
For production environment, user profiles can be used to restrict access to some data. For example, a sales manager should only see his/her own sales orders and not the orders of another sales manager. Or a billing clerk has access to Invoices but doesn’t have access to the company revenue information.
In any case having suggested user profiles does not harm our Dynamics AX application. Click the Select all check box in the Initialize user profiles form and click OK.
Click the Set up Application Integration Framework menu item. The process takes about 20 minutes. During this time, some standard services are published to the AOS. Starting from DAX 2012, the WSDL services are hosted on the AOS.
For example, you can check that the BI service has been deployed:http://localhost:8102/DynamicsAx/Services/BIServices. Note that in my case, the 8102 port is used (by default it is 8101). The port is configurable in the Dynamics AX Client configuration (can be run from the Control panel).
The Application Integration Framework is used to exchange data in XML format. Third-party applications can request some data from Dynamics AX or send some data to Dynamics AX.
Note that in AIF data is transferred in XML format only. User cannot change the file structure.
AIF is not about the file format it is about data transfer. So, for example, if it is required to export data to the CSV format, AIF cannot be used.
Click the Configure system accounts menu item. The System service accounts form opens. It is required to specify the Business connector account.
Dynamics AX Business connector uses this account to log in to Dynamics AX. (So this user should have access to DAX).
Business connector is used by a third-party application to access the DAX data or run the DAX business logics. It is the .Net library with a set of classes that can be used in third-party applications.
By the way, Business connector is used by SSRS when Dynamics AX reports is run.
I specify my domain account as Business connector account.
System Service Account
Click OK.
As a result, we have all three menu items and nodes marked as complete.
Check List Configure Accounts And Profiles

Partition initialization checklist

Starting from DAX 2012 R2, the Partitions are introduced and the new Partition initialization checklist is added.
Now Dynamics AX has the Companies and the Partitions. Both are a logical split of data. Data from different partitions and companies is stored in the same database and tables and use the same AOS instance.
A Company is a low level entity which contains one-company specific information (for example Sales orders). Some information is cross company for example Users, i.e. users are shared between all companies.
A Partition is a high level entity that has its own set of companies. Partition contains multiple-companies specific information plus cross company information. Cross company information from one partition is not accessible from another partition.
For development, test, or education environments, it is enough to have one Initial partition that is created by default.
Let’s run Dynamics AX. After you complete the tasks in the Initialization checklist, the Partition initialization checklistopens automatically when you first start the Microsoft Dynamics AX client. You can also open the Partition initialization checklist by clicking System administration > Setup > Checklists > Partition initialization checklist.
The Partition initialization checklist has the following view:
Basically this checklist contains the same steps that were in the Initialization checklist of the previous version of Dynamics AX.  You can check it here.
Click the Configure partition accounts menu item. The System service accounts form opens. You are asked to enter the Workflow execution account. It is an optional step. If you do not use the Workflow, you can leave this account empty. Otherwise fill it in. Click OK.
Click the Create reference data menu item. The job is run. As a result, all parameters tables are populated with default values (for example, the CustParameters table), and some default data is populated (for example the Currency and Language tables).
Click the Create legal entities menu item. The Legal entities form opens. The default company is already created in the previous step. It is the DAT company. In the next training lesson we will load demo data (with companies). ClickClose.
Click the Setup system parameters menu item. The System parameters form opens. Populate the System languagefield with the required language. Note that languages already exist in the Dynamics AX (they were populated on the Create reference data step). The rest parameters are optional. Close the form.
System Parameters
The “The Report data clean up job is added to the batch queue” message appears. This job runs recursively to clean up report data. The report data is collected and stored in special tables. When the report is printed, the collected report data can remain in the Dynamics AX tables. Since this data is no longer required, it can be cleaned up automatically. For this purposes this job is added to the batch queue. You can cancel this and any jobs from the batch queue later through the User interface: System administration > Inquiries > Batch jobs > Batch jobs.
Click the Import data menu item. The Import options form opens. Microsoft has not prepared the demo data in the DAT format for this version of Dynamics AX. We will import the demo data in the next training lesson. Close the form. Mark this step as complete.
Close the Dynamics AX and run again. The Microsoft Dynamics AX with all modules opens.Microsoft Dynamics AX


Dynamics Installation -AX server

Dynamics AX installation

Now we can set up Dynamics AX. Find the Setup.exe file in your Dynamics AX installation folder and run it:
  1. The Microsoft Dynamics wizard opens. Click the Microsoft Dynamics AX components menu button. DynamicsAx Inital window
  2. The Microsoft Dynamics AX Setup wizard with the Welcome page opens. Click Next to continue.
  3. The License terms page opens, select the I accept the license terms check box and click Next. (This page opens only if you run installation for the first time.)
  4. The Customer Experience Improvement Program page opens. Select what fits you and click Next. (This page opens only if you run installation for the first time.)
  5. The Select a file location page opens. I leave the default File location value (“C:\Program Files\Microsoft Dynamics AX\60”). Click Next. (This page opens only if you run installation for the first time.)
  6. The Ready to install page opens. Clicks the Install Setup will install the support files. (This page opens only if you run installation for the first time.)
  7. The Select an installation option page opens. Select the Microsoft Dynamics AX radio button and click Next.
  8. The Select installation type page opens. To see what will be installed, select the Custom installation typeradio button.
  9. The Select components window appears. Select the following components and click Next
    • Database
    • Application Object Server (AOS)
    • Reporting Services extension (it is used for reports). Info window will appears click Ok.
    •  Client
    • Debugger (for developers)
    • Visual studio tools (for developer for SSRS report development)
    • .Net Business Connector
    • Management utilities
    DynamicsAX Components
  10. The Prerequisite Validation page opens. I have 7 Errors. DynamicsAX Prerequisite Validation
  11. I have resolved all errors by clicking the Link button and installing all required components. Click Next.
  12. The Select a file location page opens. I leave the default File location value (“C:\Program Files\Microsoft Dynamics AX\60”). Click Next.
  13. The Select databases page opens. Select the Create new databases radio button and click Next.
  14. The Create new databases page opens. The Server name contains the SQL server name (was installed in the previous topic). All fields will be populated automatically, so I leave it as is. Click Next
  15. The Select additional models page opens. The Foundation model is mandatory and selected. This model contains all metadata and the en-us label file (English United states). If you need additional language, select the Foundation Labels model. In this case all available languages are set up. Click Next.
  16. The Configure an Application Object Server (AOS) instance page opens. All fields are filled in by default. If the fields’ values are acceptable to you leave them as they are. The TCP/Ip port can be changed later in the Dynamics AX Server configuration. Click NextDynamicsAX Configure AOS
  17. The Specify an AOS account page opens. You can specify your domain account or use the NT Authority local account for AOS. AOS will be installed as a Windows Service. As it often happens in production environment, the new domain user is created and assigned to the AOS. The AOS account can be changed later in the Windows Services. I will specify my domain account as it has all necessary rights and click Next.
  18. The Select client preference page opens. Here the Dynamics AX Client language is specified. I have set up the English language, the Developer installation type. Now select the Create a desktop shortcut checkbox, and click Next.
  19. The Specify Business Connector proxy account information page opens. Specify the domain user that will be used by the .Net Business connector to log in to Dynamics AX. Business connector is used by the SSRS reports. I will set up my domain account and click Next.
  20. The Specify a Reporting Services Instance page opens. The Instance name field will be filled in by default. I clear the Deploy report checkbox. I want to check the Dynamics AX report configuration before deploying reports. All in all I will deploy reports to SSRS later in the Load demo data lesson. Click Next.
  21. The Prerequisite validation page opens. I have one error – Microsoft Analysis Management Objects. This error is solved by clicking the Link Click Next.
  22. The Ready to install page opens. Click Install. This process will take about 1 hour. Dynamics AX Ready To Install
  23. When the process is complete, the Setup was not completed page opens. Dynamics AX Setup Was Not Completed We can see that Databases were installed successfully and the rest of components were not installed. But, it is not true, if we go to Windows Services, we can find the Microsoft Dynamics AX Object Server service in the Startingstatus. It means that AOS was installed.If we open the summary report, we can find that the wizard assumes that AOS was not installed because “The following error/warning occurred: Time out has expired and the operation has not been completed.”So AOS was installed but not yet started. The rest of components that depend on AOS were not installed also.
  24. Finish the Microsoft Dynamics Wizard and wait one more hour till AOS is started.
  25. Run the Microsoft Dynamics Wizard
  26. The Welcome page opens. Click Next.
  27. The Modify Microsoft Dynamics AX installation page opens. Select Add or modify components and click Next.
  28. The Add or modify components page opens. Select the following components: Reporting Services extension, Client, Debugger, Visual studio tools, .Net Business Connector, Management utilities and click NextDynamics AX Setup Add Or Modify Components
  29. The Prerequisite Validation page opens. Since we have already installed all required components, there are no errors. Click Next.
  30. The Select client preference page opens. Here, the Dynamics AX Client language is specified. I have set up the English language, Developer installation type. Select the Create a desktop shortcut check box and clickNext.
  31. The Specify a location for configuration settings page opens. Select the Save configuration in the registryradio button. If a configuration file will be required, later we can generate it from the Microsoft Dynamics AX Configuration application (it will be available in the Windows Administrative Tools). Click Next
  32. The Connect to an AOS instance page opens. Specify the connection parameters that will be used by the Client. I leave the default ones as they fit me. The parameters should match the AOS parameters that were specified in step 16. Note that on this step, the AOS should run (to review the service status go to Windows Services > Microsoft Dynamics AX Object Server). 
  33. The Specify Business Connector proxy account information page opens. Specify the domain user that will be used by the .Net Business connector to log in to Dynamics AX. The Business connector is used by the SSRS reports. I will set up my domain account and click Next.
  34. The Specify a Reporting Services Instance page opens. The Instance name field will be filled in by default. Again I clear the Deploy report checkbox. I want to check the Dynamics AX report configuration before deploying reports. All in all I will deploy reports to SSRS later in the Load demo data lesson. Click Next.
  35. The Connect to a SQL Server Database page opens. Here we should specify the SQL server and the database name where the Dynamics AX database was installed. In my case, it is: 
  36. The Prerequisite validation page opens. We already were at this step so now we don’t have any validation errors. Click Next.
  37. The Ready to install page opens. Click Install. This process will take about 0.5 hour. Dynamics AX Ready To Install
  38. When the setup is complete, the Setup was completed successfully page opens. Click FinishDynamics AX Setup Was Complited
  39. Congratulations! The Dynamics AX 2012 was installed successfully.

Dynamics Administration -Installation

Installation & Configuration: 


SQL Server installation


To install Dynamics AX, the SQL server is required. I have installed SQL Server Express edition and have problems with reports. In Dynamics AX 2012 reports are running on the SQL Server Reporting Services (SSRS). SQL Express edition has advance package that include the SSRS. But this SSRS can not use the AXREPORTDATAPROVIDER report data source. So advanced package of the SQL Express edition can not be used for Dynamics AX 2012 (and AX 2009 also, because there are also SSRS reports). For the Dynamics AX 2012 (2009) it is required to install the SQL Server Standard edition to be able to run Dynamics AX SSRS reports. I have installed the SQL Server Standardedition with SP1:
  1. The SQL Server installation center window opens. Click the New SQL server stand-alone installation or add features to an existing installation menu button. (For SQL 2008, the menu button is called “New installation and add new features to an existing installation”)
  2. The SQL Server 2012 Setup wizard opens. If it is your first SQL server installation, then it is required to enter the Product key. Then the support files will be installed. After that the computer restart is required. You will be notified about this on the Setup Support Rules page.
  3. Restart the computer if required. Run installation again and repeat the step 1.
  4. The License Terms page opens. Select the I accept license terms check box and click Next.
  5. The Setup Role page opens. Select the SQL Server Feature Installation option and click Next.
  6. The Feature Selection page opens. Select all check boxes and click Next (I have excluded the Reporting services SharePoint and Distributed Replay options). 
  7. On the Installation Rules page, some validation will be done automatically.
  8. The Instance Configuration page opens. Select either the Default instance or the Named instance radio button and set the desired name for the SQL server. Click NextSQL Setup Instance Configuration
  9. On the Disk Space Requirement page, the system will validate the disk space.
  10. The Server Configuration page opens. Here, we can set up a user for the SQL server windows service. Leave the default value and click Next
  11. The Database Engine Configuration page opens. The Mixed Mode is required when you set up under a local user. If you set up under a domain user, the Windows authentication mode is enough. Add your domain user as a sever administrator (if it is not added automatically) and click Next
  12. The Analysis Services configuration page opens. Add the current domain user and click Next.
  13. The Reporting Services configuration page opens. Select the Install and configure radio button and click Next.
  14. The Error Reporting page opens, click Next.
  15. The Installation Configuration Rules step will be passed automatically.
  16. The Installation process is started. The process will take up to 1 hour. When it is finished, the Completewindow appears. Click Close.
Congratulations! The SQL server, SSAS and SSRS are successful installed. To review the results, go to the Windows services and find the SQL Server and SQL Server Reporting Services services and makes sure that they are in theStarted mode.

Configure SSRS

To complete the SSRS server configuration, do the following:
  1. Enable and configure IIS on your machine. I have also logged off and logged on after enabling the IIS.
  2. Run as administrator the Reporting Services Configuration Manager.
  3. Connect to the installed SSRS instance.
  4. Go to the Web Service URL tab, review the parameters, and click Apply.
  5. Go to the Database tab, click the Change Database The Wizard opens
    • Select the Create a new report server database option and click Next.Reporting Services Configuration Manager, Create Database
    • On the Database Server tab, specify the Server name, SQL instance name. Click the Test connection to make sure that there are no issues. Click Next.
    • On the Database tab, specify the database name. Click Next.Reporting Services Configuration Manager, Database name
    • On the Credentials tab, I leave the default setup. I.e. the Authentication mode is set to Service Credentials. Click Next.
    • On the Summary tab, click Next. On the Progress and Finish tabs, click Finish.
  6. Go to the Report Manager URL tab. Click Apply.
Let’s check the results. Restart the SSRS. Run Internet Explorer as administrator and specify the Report Manager