Click to Rate and Give Feedback
Collapse All/Expand All Collapse All
Microsoft Dynamics AX 4
Add Dimensions

You can add dimensions to Microsoft Dynamics AX. The product ships with three dimensions: Department, Cost center, and Purpose.

Dimensions are based on extended data types that are defined as arrays. The extended data types with dimension information are as follows:

  1. In the Application Object Tree (AOT), add a new array element for the dimension to each extended data type listed above.

    For more information, see Define Extended Data Types as Arrays.

  2. Associate the new array element with certain dimension table fields by doing the following for the Dimension and DimensionCriteria extended data types.

    1. Click the extended data type, and then click the new array element.

    2. Right-click Relations, and then click New > Normal to add a normal relation.

    3. Right-click the relation, and then click Properties.

    4. Set the Table property to Dimensions, and then set the RelatedField property to Num.

    5. Right-click Relations, and then click New > Related field fixed to add a related field fixed relation.

    6. Right-click the relation, and then click Properties.

    7. Set the RelatedField property to DimensionCode.

  3. Add a new value to the SysDimension enumeration that represents the new array element by doing the following.

    1. Click Data Dictionary > Base Enums, right-click the SysDimension, and then click New Element.

    2. Right-click the new element, click Properties, and then modify the Name property.

    3. Modify other properties, as needed.

  4. Create a relationship between the LedgerJournalTrans table and the Dimension table by doing the following.

    1. Click Data Dictionary > Tables > LedgerJournalTrans, right-click Relations, and then click New Relation.

    2. Right-click the new relation, and then click Properties.

    3. Set the Table property to Dimensions, and set the Name property to InterCoDimension<number> to distinguish it from other InterCoDimension relations on the LedgerJournalTrans table.

    4. Add a related field fixed relation and two normal relations to the InterCoDimension relation, as shown in the following example.

      LedgerJournalTrans table relations

      For more information, see Add a Relation to a Table.

  5. Modify the LedgerAllocation form to display the new dimension by doing the following.

    1. Right-click the LedgerAllocation form, and then click Compile.

    2. Locate the following group controls in the TabPage:Dimension control, set the AutoDataGroup property for each group control to No, and then save the changes.

    • Group:FromDimensionNo

    • Group:SelectionCriterion

    • Group:To

    • Group:KeepTransactionDimension

      The system automatically adds a new control to each group control that corresponds to the array element that you added to the extended data types in step 1.

      For information about form controls, see Overview of Form Control Types and Form Control Properties.

Tags What's this?: Add a tag
Community Content   What is Community Content?
Add new content RSS  Annotations
Processing
© 2012 Microsoft. All rights reserved. Terms of Use | Trademarks | Privacy Statement
Page view tracker