Share
ReportHi All ,
We did reset MR reporter and imported all building blocks . But no data is captured in report .Please advise .
You’re offline. This is a read only version of the page.
25
Hi All ,
We did reset MR reporter and imported all building blocks . But no data is captured in report .Please advise .
Good Morning SYH,
Just wanted to follow up on this one and ask whether you have made some progress here?
Would be great if you could keep us informed about how things are going and whether you need some additional information/help from the community.
Many thanks and best regards,
Ludwig
Hello SYH,
My name is Erik and I am with Microsoft.
You can run the below SQL script, against the MRdb to see what roles each users have in MR. If the user doesn't exist then make sure they have the correct roles in AX to allow them access to MR.
SELECT A.UserName,
B.Name,
CASE A.ROLETYPE
WHEN 2 THEN 'VIEWER'
WHEN 3 THEN 'GENERATOR'
WHEN 4 THEN 'DESIGNER'
WHEN 5 THEN 'ADMINISTRATOR'
END AS SecurityRole,
A.WindowsSecurityIdentifier,
A.UserID,
CASE A. AccountDisabled
When 0 Then 'Enabled'
When 1 Then 'Disabled'
End AS AccountStatus
FROM Reporting.SecurityUser A
JOIN Reporting.SecurityPrincipal B
ON A.USERID = B.ID
ORDER BY A.UserName
Hi SYH,
Can you check with your system admins that you have the correct role in AX2012 assigned?
That is, that you are not e.g. a system user only but have the proper roles assigned that allow you generating financial reports?
If you set this up, then system admin and security admin roles should do the job.
Best regards,
Ludwig
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,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (