Hi friends many of the client requirement’s
to create a new financial dimension
in AX apart from the three standard dimensions "Department",
"Cost center" and "Purpose".
Here is a steps to creating a new financial dimension.
Here is a steps to creating a new financial dimension.
To create a new financial dimension modify following objects
one by one
1)Base enum "SysDimension" : Find this base enum and right click on
this base enum -> Select option "New element". In properties
window give a name to this element say "TestDim" and label as
"Test dimension". Save the base enum.
2)Extended data type "Dimension" : Find this EDT and then add a new array
element in this EDT. Name this array element as "TestDim". In
properties window specify label as "Test dimension". Now in the
"Relations" tab of this new array element add a new
"Normal" relation first. To this normal relation open
properties window and set property Table as "Dimensions" and Related
field as "Num". Now add another relation of type "Related field
fixed". To this related field fixed relation open properties
window and set Related field as "DimensionCode" and property value as
"3" (this is the value of the new enum element created in
SysDimension). Save the EDT.
3)Extended data type
"DimensionCriteria" : Repeat the process of modification as done for EDT
"Dimension" above.
4)Extended data type "XMLMapDimension" : Find this EDT in AOT and then create a
new array element for this EDT. Label this array element as "Test document
value". Save the EDT.
5)Extended data type
"MandatoryDimension" : Find this EDT in AOT and then create a new array element for
this EDT. Label this array element as "Validate test dimension". Save
the EDT.
6)Extended data type
"DimensionLedgerJournal" : Find this EDT in AOT and then create a new array element
for this EDT. Label this array element as "Test dimension". Save the
EDT.
7)Extended data type
"DimensionKeepFromTransaction" : Find this EDT in AOT and then create a new array element
for this EDT. Label this array element as "Keep transaction test
dimension". Save the EDT.
8)Extended data type
"COSAllowDimensions" : Find this EDT in AOT and then create a new array element for
this EDT. Label this array element as "Test dimension". Save the EDT.
9)Extended data type
"DimensionPriority" : Find this EDT in AOT and then create a new array element
for this EDT. Label this array element as "Test dimension". Save the
EDT.
10)Extended data type
"DimensionAllocation" : Find this EDT in AOT and then create a new array element
for this EDT. Label this array element as "Test dimension". Save the
EDT.
11)Table "LedgerJournalTrans" : Find this table in AOT and add a new
relation in the relations tab as follows. Create a new relation in relations
tab and name it as say "interCoDimension3" (You can see three more
similar relations with suffix 0, 1 and 2 for three standard dimensions). Now
set the property table of this relations as "Dimensions". Create a
new "Normal" relation under this realtion tab and set the property
"Field" = "OffsetCompany" and property
"RelatedField" = "dataAreaId". Create another
"Normal" relation under this relation tab and set the property
"Field" = "InterCoDimension[4]" and property
"RelatedField" = "Num". Now create a new "Related
field fixed" relation under this tab and set property "Value" =
3 (this is the value of the new enum element created in SysDimension) and
property "Related field" = "DimensionCode". Save the
changes.
The
new financial dimension is successfully created in AX and can be viewed in
different forms through out the AX where ever dimensions are used. After that
first do compilation and then Synchronization then it will effect.
Please
Don’t try it in Production directly …Try it in Test
No comments:
Post a Comment