You’re offline. This is a read only version of the page.
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
Thank you Andre for the Great Reply .
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.
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?
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,232
Super User 2024 Season 2
#2
Martin Dráb
230,064
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (