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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Not able to built repo...
Microsoft Dynamics AX (Archived)

Not able to built report with project dimension

(0) ShareShare
ReportReport
Posted on by Community Member

Hi community,

We recently added the project dimension of a legal entity we integrated in AX 2012.

Set up were made in project module

When I'm in mgmt reporter, I can see these project and the project field in the reporting tree definition, or the row definition.

Reporting tree

Row definition

I tried to build a report with a general row definition, and filtering by project in the tree definition - Did not work - report is empty

I tried to build a report with the project in the row definition, with identifying the lind to Financial Dimention in the tree definition - Did not work - report is empty

What is wrong?  Have I missed a set up?

Thanks for the help

*This post is locked for comments

I have the same question (0)
  • Syed Fasih Profile Picture
    Syed Fasih 2,442 on at
    RE: Not able to built report with project dimension

    Please mark the anwers as verified so that it will help other people in future.

  • Suggested answer
    Community Member Profile Picture
    Community Member on at
    RE: Not able to built report with project dimension

    Hi to all,

    The solution path you gave me lead to resolution of the issue.

    - I've udated the financial dimention set

    - Refresh data mart

    - Review all MR configuration

    Thanks for guiding me in this resolution

  • Verified answer
    Community Member Profile Picture
    Community Member on at
    RE: Not able to built report with project dimension

    Hi to all,

    So regarding the questions above:

    1. Yes, project financial dimension listed there

    2. Yes, log indicates something, but it is more warnings than errors.

    3. Checking the design I may I found something.  Still investigate what is happening.

    I will keep you posted.  I'm still testing a few things.

    Please note that I will do a datamart refresh, I may be missing some transactions.

    Mireille

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Not able to built report with project dimension

    Hello MireilleD,

    Have you made any progress with this MR issue?

    Would be great if you could keep us updated.

    Many thanks and best regards,

    Ludwig

  • Verified answer
    Syed Fasih Profile Picture
    Syed Fasih 2,442 on at
    RE: Not able to built report with project dimension

    I agree with Ludwig, you need to check in the following order:

    1. Go to General Ledger > Setup > FInancial dimensions > Financial dimensions for integration application and make sure that Project is included there.

    2. If 1 does not work, then try refreshing the data mart.

  • Verified answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Not able to built report with project dimension

    Hi MireilleD,

    It might be that there is a problem with the MR datamart.

    Can you check the following:

    1. GL-setup-financial dimensions-financial dimension configuration for integration applications

    - Is the project financial dimension listed there?

    2. MR configuration console:

    - Are the logs indicating any errors?

    - Are the MR processes running?

    3. MR Report designer

    - Can you share details that show how you setup the financial project dimension in your reports?

    - Have you tried running the Report with one of the Projects shown above (e.g. 00002, ...)?

    Best regards,

    Ludwig

  • Community Member Profile Picture
    Community Member on at
    RE: Not able to built report with project dimension

    OK thank you.  Now I'm able to confirm that I see the project dimension in my project trial balance.  See attachment.

    If I go back to my initial question, why I'm not able to generate project reporting in management reporter?

    GL-project-dimension.JPGGL-project-dimension.JPG

  • Verified answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Not able to built report with project dimension

    Hi MireilleD,

    The process is not critical but it might slow down AX for a while.

    Depending on the number of transactions that you have in your system it might be smart not running it during a peak time.

    Best regards,

    Ludwig

  • Community Member Profile Picture
    Community Member on at
    RE: Not able to built report with project dimension

    Hi again,

    I'm went into the Financial Dimension set to see if I can add the project dimension.  When I tried to run a Trial Balance based with this set the system warned me that dimensions were not initialized.  If I click on initialize dimension, is this a critical action that may break something in the other legal entities?  Attached a few print screens to illustrate what I mean.

    New-fin-dim-set-creation.JPGNew-fin-dim-set-creation.JPG

  • Community Member Profile Picture
    Community Member on at
    RE: Not able to built report with project dimension

    Hi Ludwig,

    I have attached a print screen from AR showing that a project was entered when a customer invoice was created.

    This would proof that the project dimension was included.

    Mireille

    Entering-invoice.JPG

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

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Our Community Code of Conduct has been updated!

Quick Links

Responsible AI policies

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

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

Congratulations to the August Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Community Member Profile Picture

Community Member 4

#2
Guy Terry Profile Picture

Guy Terry 2 Moderator

#2
Martin Dráb Profile Picture

Martin Dráb 2 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans