Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Management Reporter Da...
Finance | Project Operations, Human Resources, ...
Suggested answer

Management Reporter Datamart issue with user defined fields

(0) ShareShare
ReportReport
Posted on by Martin Haramburu 187

I have a problem regarding the row modifier, I try to filter by Attributes (user defined 2 of accounts) and the list is not populating right.

I have rebuilded the datamar a coumple of times. and the list increased by it is not showning all the information that it should dispplay.

pastedimage1646927881884v1.png

e.g. the queqy:

select * from GL20000 a inner join gl00100 b on a.ACTINDX = b.ACTINDX
where USERDEF2 = '4'

shows transactions

but management reportrs is not getting data  right:

pastedimage1646928019940v2.png

I have to use datamart in order to filter by posting LedgerBook. (on legacy the filter works fine, and i see everything ok in dimension filtering)

Legacy:

pastedimage1646928208764v3.png

Perhaps someone came accross this issue.?

Thanks

Categories:
Microsoft Dynamics GP
  • Martin Haramburu Profile Picture
    Martin Haramburu 187 on at
    RE: Management Reporter Datamart issue with user defined fields

    Hi Greg:

    ok, I suspected it. Is there any way of filtering (selecting) the general ledger book code, in Legacy?

    regards

  • Greg Byer Profile Picture
    Greg Byer 2,586 on at
    RE: Management Reporter Datamart issue with user defined fields

    That is correct.  The user defined field will apply to the main segment that was set up first.  All accounts after that with the same main segment will use those user defined fields.  The data mart does not read the full account string.  Instead, it reads the segments (dimensions).  Because of this, the UDF is tied to the segment (dimension) and not the full account number.  

    The workaround would be to use the Legacy provider.

  • Martin Haramburu Profile Picture
    Martin Haramburu 187 on at
    RE: Management Reporter Datamart issue with user defined fields

    Yes, a couple of times. I have just seen another post, the same issue, it seems that if two or more different main segment account have different value of user defined fields, the datamart can't support this. Can anyone confirm if this is so? I am with the latest patch.

    Is there a workaround?

    Regards

  • Suggested answer
    Lisa at AonC.com Profile Picture
    Lisa at AonC.com 604 on at
    RE: Management Reporter Datamart issue with user defined fields

    Step 1 with troubleshooting data inconsistencies with Management Reporter Data Mart is to recreate/rebuild the Data Mart.  Have you done that step?  (There are lots of documents on the process.  Here is a link to one:  community.dynamics.com/.../rebuilding-your-management-reporter-data-mart )

  • Martin Haramburu Profile Picture
    Martin Haramburu 187 on at
    RE: Management Reporter Datamart issue with user defined fields

    More info:

    I profiled and see the dropdown list values comes from the query:

    SELECT DISTINCT AttributeValue6 FROM [Datamart].DimensionValueAttributeValue WHERE AttributeValue6 IS NOT NULL ORDER BY AttributeValue6

    go

    but I do not how to get MR to refresh that table and if it will find the correct accounts?

    I could not find any table documentation of MR.

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

Quick Links

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,399 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans