Search This Blog

Monday, February 24, 2014

AX2012 Get dimension Values


To get the master Data for Dimension attributes we can use two service classes.
1. DimensionService
2. DimenisionValueService

we will see what Dimension Service class is providing
1. getActiveDimensionsFromLedger()- Gets active dimensions in current company which will return the DimensionContract class collection List.
2. getDimensions(AccountStructureContract _accountStructureContract)-Processes an incoming account structure contract and return a list of financial dimensions for a specific account structure.
3. getDimensionsAll()-Gets a list of all financial dimensions, which returns a A String list of dimension values using DimensionContract class.

we will see what DimensionValue Service class is providing
using this class we can create/Get DimensionValues for the specific dimension attribute.

Methods:
1. createDimensionValue(DimensionValueContract _dimensionValueContract)-Processes an incoming dimension value contract and creates a financial dimension value for a specific financial dimension.
2. getDimensionValues(DimensionContract _dimensionContract)- processes an incoming dimension contract and returns a list of financial dimension values for a specific financial dimension. and returns the list of the dimension values for that specific dimension attribute.

we can use this service classes and consume in any external application and call this service methods.


by using these two services we can get the dimension values easily.


static void Krishh_getDimensionValues(Args _args)
{

    List                            dimensionAttributeList;
    ListEnumerator                  listEnumerator;

    DimensionService                dimensionService;
    DimensionContract               dimensionContract;
    AccountStructureContract        accountStructureContract;

   
    dimensionService            = new dimensionService();

    accountStructureContract    = new AccountStructureContract();
    accountStructureContract.parmName("Account Structure - P&L");

    dimensionAttributeList      = dimensionService.getDimensions(accountStructureContract);

    listEnumerator  = dimensionAttributeList.getEnumerator();
    while (listEnumerator.moveNext())
    {
        dimensionContract   = listEnumerator.current();
        info(strFmt("%1, %2",dimensionAttributeList.elements(), dimensionContract.parmDimensionName()));
    }

}

Friday, December 27, 2013

PacktPub Offer for E-Books

Readers!
I have seen the fantastic offer in PacktPub to get an ebooks for just 5$.!
Packt has announced the $5 eBook Bonanza to mark the commencement of this holiday season!

You can go to this link to find out more details.

- http://bit.ly/1jdCr2W


Tuesday, December 3, 2013

AX2012 Solution for time consuming Deploy Report from Visual studio.

When Deploying the report from visual studio in some environments its taking lot of time to deploy, as it is verifying the privileges with the AD and ADServer is slow, some times I found its taking atleast 20mins to deploy a report.

So please use powershell with the following command to deploy the report with  the parameters.

Publish-axreport -reportName   <raportname>  -SkipReportServerAdminCheck

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.


Wednesday, October 16, 2013

PacktPub - Columbus Day great offer.


Packt has introduced a massive discount of 50% off on all ebooks and videos.

Customers can simply use the code COL50 to avail this massive discount, in their cart – as many times as they like until Thursday, 17th of October.

Monday, September 23, 2013

Extending Microsoft Dynamics AX 2012 Cook Book - Brief Overview

Dear Friends,


Thanks to Packt Publishing team for forwarding me this book for review.

Introduction
Extending Microsoft Dynamics AX 2012 Cookbook will show you how to use tools that you already have to extend out Dynamics AX and discover potential new directions. This book will show you how to use the system’s powerful and centralized features to streamline your work processes of your organization.
  • Easily create attractive dashboards and reports using Performance Point, PowerView and Excel
  • Improve and maximize the potential of user communication and collaboration with Outlook and Lync
  • Create and configure roles centers for your users
  • Build personal portals and document libraries within SharePoint
  • Create a streamlined organization through workflows
  • Build new help files specific to your business
  • Develop personalized and customized screens
  • Using Dynamics AX web service in InfoPath form.
  • Case management

Cover Image




















Who this book is for
This title is for business professionals, such as administrators and consultants, who want to take full advantage of the features of Dynamics AX. This book has a wide appeal and you do not need to be a SharePoint, database or programming expert. As long as you know a little about these elements, you will be able to take full advantage of the business efficiency created with Dynamics AX extensions.

Book Link

Book Authors
I know Murray Fife as fellow bloggers on Dynamics AX. He has been in Dynamics AX space for a while and has contributed immensely to Dynamics AX via from his blogs. Thank you Murray for the good work on this book.

Murray Fife

Murray Fife is a Microsoft Dynamics AX MVP, a presenter, and an author with over 18 years of experience in the software industry. Like most people he has paid his dues as a developer, as an implementation consultant, and a trainer. He has a hard-to-find blend of technical and interpersonal skills and spends his days working with companies solving their problems with the Microsoft suite of products, specializing in Dynamics AX solutions.  He can reached through the http://www.murrayfife.me/



Wednesday, May 1, 2013

Cumulative Update 5 for Microsoft Dynamics AX 2012


Guys,

Missing from long time from blogging....with loads of loads of work in AX2012 implementations for multiple customers...

Here we have an update for AX2012 released  CU5

Cumulative Update 5 (CU5) contains hotfixes for Microsoft Dynamics AX 2012 that were fixed since the release of Microsoft Dynamics AX 2012. This cumulative update is applicable to both Microsoft Dynamics AX 2012 (6.0.947.0) and Microsoft Dynamics AX 2012 Feature Pack 1 (6.0.1108.0). 

 Follow the below link of Customer sourcer/ Partnersource

AX2012 CU5 release


Enjoy AX2012 folks.....

Thursday, March 7, 2013

The Most Influential People in Microsoft Dynamics for 2013 - Need your Help


Hey all,

I am sending out a note to those of you that have taken advantage of my Blog(http://krishhdax.blogspot.com),through skype,Chat..etc, that I have been making over the past couple of years, asking for a favor.

It is that time of year 2013, and we are now announcing the nomination process for The Most Influential People in Microsoft Dynamics for 2013.  I would really like to make the list this year, and I hope that I have influenced you all in my own little way. 

If you feel inclined, you can nominate me by sending an email with a persuasive explanation for the nomination to top100@dynamicsworld.co.uk or through Twitter using the #dwtop100 tag.

You can find more on the nomination process can be found here: http://www.dynamicsworld.co.uk/top100nominationprocess/

Thanks in advance.

Krishna Reddy Modugula | CGI |AX Technical Manager | Microsoft Solutions
Lautrupvang 10, DK-2750 Ballerup | Denmark 
Phone: +45 44 78 40 00  | Mobile: +45 41 88 23 35