Technical Tutorials on MS Dynamics Axapta 2012,D365 FnO

There are some Index Tips for Performance improvement in Axapta. You need to take care on index creation. 1. To create Index on table you can go to particular table from AOT then go Index then right click then create new Index. You should apply naming convention for index as per column added in to index. 2. You need to maintain sequence of column in index as suggested through sql performance tuning adviser. There is include column option available in Ax 2012 but in Ax 2009 include column option is not available. 3. If there is recid field inclusion in index then please avoid this column to include in index because its unique filed and system maintain auto index creation if you select property createrecidx on table to yes . 4. Do not include dataareaid in index column because system take this column by default on all index. 5.After index creation synchronize table from AOT and re-index the table.

To Define dimension values to container in ax 2012 you can try below code same way you can do for other dimension values like department,region ,store etc. DimensionDefault defaultDimension; str costcenter; Container con,defDimension,ledgerDimension; costcenter="0122"; if(costcenter) { defDimension = ["COSTCENTRE",costcenter]; } defDimension = [1] + defDimension; You can use defDimension value to AxdDimensionUtil::getDimensionAttributeValueSetId method to get default dimension recid as per provided values.