Creating a dynamic financial dimension lookup

The attached project demonstrates how to build a dynamic financial dimension lookup in AX2012.
Once the dimension attribute is selected, then the dimension value lookup will display the correct values based on the selected dimension attribute.
This could be used, for example to build for security policy by dimension value where you could set which dimensions that users should be able to see.

Microsoft white paper on securing data by dimension value using XDS

Download the xpo project here

AX 2012 - Changing ledger/default dimensions lookup

If you ever want to change the lookup on AX 2012 ledger/default dimensions, these are 2 places that you will need to change:

• Form DimensionDefaultingLookup for default dimension lookup
• Class LedgerDimensionController.restrictQueryDimensionAttributeValues for ledger dimension lookup