Friday, March 4, 2011

Undoing the Financial Dimension Wizard

During the initial setup of AX, I've seen where dimensions in one environment don't match the other environment. One place will have one called "Brand" and another will say "Brands", or "Event/Place" vs "Place/Event", for example. This can cause big issues, and be a bit of a pain.

To fix this, what I recommend doing is deciding which environment is the good one, and dropping the dimension code down to the bad one. You'll then need to drop the good database down to the bad environment too...otherwise data will look screwy all over the place.

Fixing data is another discussion, and just reloading/replacing the database is the easiest.

Replacing the code is easy. This screenshot should give you all the information you need to fix the dimensions in the AOT:

  • Tables\LedgerJournalTrans
  • EDT\COSAllowDimensions
  • EDT\Dimension
  • EDT\DimensionAllocation
  • EDT\DimensionCriteria
  • EDT\DimensionKeepFromTransaction
  • EDT\DimensionLedgerAllocCriteria
  • EDT\DimensionLedgerJournal
  • EDT\DimensionPriority
  • EDT\MandatoryDimension
  • EDT\XMLMapDimension
  • BaseEnums\SysDimension
  • Forms\LedgerAllocation
Labels need to be fixed.  The dimension wizard creates labels for these items, I believe in the DPA label file.  Just check on the objects and see what their labels are.  You can open the axDPAen-us.ald file in notepad (US English) and take a look there too.

1 comment:

  1. Hi Alex,

    The label file is something you choose while executing the wizard, so it can be anything.