Skip to main content
Microsoft Dynamics GP forum
Suggested answer

Management Reporter data mart access - domain change

editSubscribe (0) ShareShare
ReportReport
Posted on by

We just migrated to a new server for GP, and as part of that, a new domain is added as well. I have been able to add the new domain users and can access management reporter, can run reports, and can access reports if they are done on the legacy adapter. However, if they are run using the datamart or any datamart database, when the report comes up, I get a message "This report can't be displayed" "Make sure that you have access to one of the following items: A unit in the reporting tree The report in the Management Reporter report library."

If I go to the report library and try and open the report, it gives me a message: "This report view can't be displayed due to unit security"

This new domain user is an administrator in management reporter and has full rights to the report library.

Any ideas? this is pretty urgent to get their reports up and running.

Kevin

Categories:
  • Suggested answer
    kjjson Profile Picture
    kjjson on at
    RE: Management Reporter data mart access - domain change

    Thanks Richard, I actually found the answer. They had setup a user security group and had assigned it in a few of the reporting trees, so those particular reports where requiring the user to be added to those security groups in order to view the reports run based off of those trees. All is well.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: Management Reporter data mart access - domain change

    Are you saying you have a new server that is a member of two domains or  this new server is a member of only the new domain?

    https://support.microsoft.com/en-us/help/3163587/after-you-make-changes-to-your-domain-you-no-longer-have-permission-to

    These tips may be of help. All the security is kept within the ManagementReporter database. The users are kept in there with their domain credentials so you will not be able to simply copy over the databases. It may be best to simply export the building blocks from the old server, install MR onto the new server and import those building blocks. You would need to add the users to the new MR instance.

Helpful resources

Quick Links

What Motivates a Super User?

We know many of you visit the Dynamics 365 Community and Power Platform…

Demystifying Copilot with Georg Glantschnig…

Industry experts answer burning questions directly from our amazing Community…

Setting Up Knowledge Sources for Copilot…

Look at how configuring a comprehensive knowledge base is crucial…

Leaderboard

#1
Andre Arnaud de Calavon Profile Picture

Andre Arnaud de Cal... 283,068 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 222,591 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,138

Product updates

Dynamics 365 release plans