Microsoft Dynamics AX (Archived)

DMF Financial Dimension

(0) Share

Report

Posted on by veera seenivasan

575

Hi Experts,

I am migrating Fee type journal from Project module ax 2009 to ax 2012 Using DMF. WhileMigrating

my financial dimension value is Null and i am not sure where to map that financial Dimension .OR I need to make fix in the code .Please advice.

Staging Table -DMFProjjournalTransEntity

Entity -ProjectJournal

Thanks &Regards

Adam

*This post is locked for comments

All responses (4)

Answers (1)

veera seenivasan 575 on at

Like (0)

Report

RE: DMF Financial Dimension

Thank you Andre for the Great Reply .
Verified answer

André Arnaud de Cal... 291,391 Super User 2024 Season 2 on at

Like (0)

Report

RE: DMF Financial Dimension

Hi Adam,

In the source data format you need to select the dimensions Department, Cost center and Purpose (this latest dimension seems to be not setup in AX2012). If you have done that it would probably mention CostCenter-Department-Purpose as it will order alphabetically.

Then you need to concatenate the values from AX2009 into one column. For the example you provided it will be:

"0201-030-". (This is in the order AX expects it according to the source data format setup.

During the staging to target step, AX will translate it to the new dimension tables.
veera seenivasan 575 on at

Like (0)

Report

RE: DMF Financial Dimension

Hi Andre Thanks for your Reply.Actually My problem is in Source data format ax 2009 I have three fields 1.ProjOnAccTrans).Dimension[1] 2.ProjOnAccTrans).Dimension[2], 3.ProjOnAccTrans).Dimension[3] but in Staging i have only one field default dimension.Here my question arises which field i need to map?
Suggested answer

André Arnaud de Cal... 291,391 Super User 2024 Season 2 on at

Like (0)

Report

RE: DMF Financial Dimension

Hi Adam,

If you don't have a source value for the default dimension field, you can just leave it as it is now (unmapped).

If you need to import dimensions as well, you need to define this in the Source data format and include one new column in the soure containing the value(s) in order it is mentioned in the Source data format.