2012 in review

The WordPress.com stats helper monkeys prepared a 2012 annual report for this blog.

Here’s an excerpt:

600 people reached the top of Mt. Everest in 2012. This blog got about 6,900 views in 2012. If every person who reached the top of Mt. Everest viewed this blog, it would have taken 12 years to get that many views.

Click here to see the complete report.

AX2012 – Cubes

I found a interesting video about learning how to create a sample cube i.e. Sales Analysis cube in AX2012 . This contains detailed steps to create the cube after SQL Server Analysis services are installed for specific AOS instance .Things to consider while  working on cubes in AX2012  :

1. Make sure AX2012 SQL Server Analysis Services is started under Administrator –>Services .
2. Make sure that service account for SSAS is configured.

https://community.dynamics.com/product/ax/axnontechnical/b/axvideos/archive/2012/03/08/how-to-create-a-cube-in-microsoft-dynamics-ax-2012.aspx

 

 

AX2012 – SQL Back up

I found a interesting article about various types  of Back up in SQL 2008 , Incremental, Differential & Full which contains syntax as well. This is useful while setting up SQL Server Management Tasks in SSMS .:

http://sqlserverperformance.wordpress.com/2010/03/25/recovery-models-and-backup-strategies-for-sql-server-2008/

Ax2012 – Model store

I found an interesting MSDN post about importing Model store in AX . With the elimination of AOD files, it is must read for Ax2012 Projects. Happty DAXing :

http://technet.microsoft.com/en-us/library/dd362019.aspx

 

AX2012 – Version control set up

Here is link for setting up the version control set up for AX2012 .  It describes in detail the various options available for version control including step by step details for configuring the same.

http://msdn.microsoft.com/en-us/library/gg886743.aspx

AX2012 & SSRS Reports – Using the Carriage return

Here is an example on using the Carriage return for SSRS Reports to show values in Multiple lines such as Address fields Address1 and Address2  -See the VbCrLf below expression .

=Fields!CountedByShipperValue.Value + “□” + ” By Shipper” + VbCrLf + VbCrLf + Fields!CountedByDriver1Value.Value

 

AX2012 SSRS Reports – Toggle fields

I got a chance to work on SSRS in AX2012 . I found out a interesting feature in reports which looks way improved than the traditional MorphX reports. In SSRS report you can toggle the visiblility of one report to be based on value in another one .Refer Qty (with a + and – sign as result of toggle action by report user  and the field NFMC# hiding  based on Qty field.

AX2012 – Document for deploying customizations

Here is nice document for deployment options available for AX2012 .I t covers the best practices used for deployment of AX2012 customizations in detail . Happy DAXing 🙂

http://www.microsoft.com/download/en/details.aspx?id=26571

 

 

AX2012 Client performance options

Here is good link for improving  permformance developing Fact boxes used in AX Screens . This will help developers keep those points while first time  creating AX Forms .

http://blogs.msdn.com/b/axperf/archive/2011/11/07/ax2012-client-performance-options.aspx

 

AX2012 – Upgrade scripts

Here is the MSDN link for writing upgrade scripts for AX2012 :

http://msdn.microsoft.com/en-us/dynamics/ax/gg712261