web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Introducing our New Video Series: Community Spotlight
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / DMF Financial Dimension
Microsoft Dynamics AX (Archived)

DMF Financial Dimension

(0) ShareShare
ReportReport
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.3535.PNG

Staging Table -DMFProjjournalTransEntity

Entity -ProjectJournal

Thanks &Regards

  Adam

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 302,654 Super User 2026 Season 1 on at

    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.

  • veera seenivasan Profile Picture
    veera seenivasan 575 on at

    Capture12334.PNGCapture12334.PNGHi 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?

  • Verified answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 302,654 Super User 2026 Season 1 on at

    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 Profile Picture
    veera seenivasan 575 on at

    Thank you Andre for the Great Reply .

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Introducing our New Video Series: Community Spotlight

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the December Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Volodya Profile Picture

Volodya 2

#2
tgudwanski Profile Picture

tgudwanski 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans