Followers

4 January 2016

Today Am exploring the new aspect related to financial dimensions in ax2012


Earlier version AX2009, 4.0 :

  • In  older version system used to create the limited dimensions.
  • By default system is available 3 dimensions such as  cost center,Department and purpose. These dimensions are referred as dimension[0],dimension[1],dimension[2]..
New version AX2012, 6.0 :

  •   In new version ,their is no limit to create the dimensions. Create N no.of  dimensions as   per the organization requirements.
  •  Financial dimensions master table dimension is replaced with DimensionAttribute and DimensionValueDetails. 
  • To store these dimensions on customized table insted of  EDT should add DimensionDefault EDT.
How to access the Financial dimensions values in AX2012:

             access the dimensions values in ax2009,  for example

               SalesTable.dimension[0] == Department  value
               SalesTable.dimension[1] == Costcenter  value
               SalesTable.dimension[2] == purpose value
               

        
                             
 code:

    public DimensionValue getDefaultDimensionValue(DimensionDefault _dimensionDefault,Name        _dimensionName)
{
   DimensionAttributeValueSetItemView    dimAttrsetView;
   DimensionAttribute                                   dimensionattr;
   ;
       

  select dimAttrsetView where dimAttrsetView.DimensionAttributeValueSet
          == _dimensionDefault   
    
       join dimensionattr where dimensionattr.RecId == dimAttrsetView.DimensionAttribute
                                && dimensionattr.Name == _dimensionName;
  
                           return dimAttrsetView.DisplayValue;

       }