Search This Blog

Friday, November 8, 2013

Microsoft Dynamics AX2012 R2 CU7


What’s new in Microsoft Dynamics AX 2012 R2 CU7
In CU7 for Microsoft Dynamics AX 2012 R2, Microsoft added and changed a number of features.

The build number of this cumulative update package is 6.2.1000.4051. Before you install this cumulative update package, we recommend that you read the Microsoft Dynamics AX 2012 R2 CU7 release notes carefully.

This update can be applied only on AX2012 R2 Installation.

See the following link for the feautures Added in CU7
http://technet.microsoft.com/EN-US/library/dn527179.aspx


Thursday, November 7, 2013

Read Dimension combination values


These functions used to read the individual ledger dimension combinatio values.

private void Krishh_getDimensionValues(LedgerDimensionAccount _dimensionRecid)
{
   
    DimensionAttributeLevelValueAllView dimAttrView;
    DimensionAttribute                  dimAttr;
 

        while select DisplayValue from dimAttrView  
            where dimAttrView.ValueCombinationRecId == _dimensionRecid
            join BackingEntityType from dimAttr
                where dimAttr.RecId == dimAttrView.DimensionAttribute
        {
            switch (dimAttr.BackingEntityType)
            {
                case tableNum(DimAttributeMainAccount):
                    info(strFmt(“Main Account: %1″, dimAttrView.DisplayValue));
                    break;
             
                case tableNum(DimAttributeOMBusinessUnit):
                    info(strFmt(“Business Unit: %1″, dimAttrView.DisplayValue));
                    break;

                case tableNum(DimAttributeCustTable):
                    info(strFmt(“Customer: %1″, dimAttrView.DisplayValue));
                    break;

                case tableNum(DimAttributeOMDepartment):
                    info(strFmt(“Department: %1″, dimAttrView.DisplayValue));
                    break;

                case tableNum(DimAttributeHcmWorker):
                    info(strFmt(“Worker: %1″, dimAttrView.DisplayValue));
                    break;
            }  
        }
   
 
}

private DimensionValue krishh_getDimensionValueByName (LedgerDimensionAccount _dimensionRecid, Name _name)
{
    DimensionAttributeLevelValueAllView dimAttrView;
    DimensionAttribute                  dimAttr;

 
        Select DisplayValue from dimAttrView  
            where dimAttrView.ValueCombinationRecId == _dimensionRecid
            join BackingEntityType from dimAttr
                where dimAttr.RecId == dimAttrView.DimensionAttribute
&& dimattr.Name==_name;


return dimAttrView.DisplayValue;

}

Tuesday, November 5, 2013

Microsoft Dynamics AX 2012 Reporting Cookbook


Dear Friends,

·        Thanks to Packt Publishing team and author “Kamalakannan Elangovan” for forwarding me this book for review.
Before providing the brief introduction to this book, I am getting lot of questions from all over the world about the reporting in AX2012 like:- how to create a simple report or providerbase report and a lot of questions about debugging,designing the report, I think this book provides you all the most of answers for developing the reports in AX2012.
Ready-to-use fixes and tips for real-time reporting challenges

Introduction
Microsoft Dynamics AX2012 Reporting Cookbook
·                 Introduction to SSRS, Reporting Architecture, Installation,Configuring Reports
·                  Difference between AX2009 and AX2012 reports.
·                  Understanding and Creating simple Reports
·                  Customization of Standard AX2012 Reports.
·                  Create Reports using Report Data Provider, EnumProviders.
·                  Customizing the parameters using UIBuilder.
·                  Understanding Integration with External data sources.
·                  Design complex report like matrix, charts, Sub reports. etc.
·                  Troubleshooting.
·                  Deploying Reports.
  
Cover Image




Who this book is for
This title is for all Technical consultants, who want to take full advantage of the features of Dynamics AX 2012 Reports.

Book Link

Book Authors
I know Kamalakannan Elangovan as fellow bloggers on Dynamics AX.
Kamalakannan Elangovan has over eight years of development experience in Dynamics AX. He shares a passion for product development and has pioneered multiple ISV solutions on Dynamics AX. In the past he worked with Innovites to create the first multidimensional ISV solution for cable industries called "Innovites for cable". Building the solution from scratch, he has gained great insights into building, selling, and promoting the product among customers and partners in the Microsoft Ecosystem. You can learn more about him at http://about.me/casperkamal. He is enthusiastic about sharing his learning with the community which led him to create one of the first few blogs for AX in 2006. It is currently available at http://kamalblogs.wordpress.com. He is active through twitter and the community, popularly by his pseudonym Casperkamal.