MR - Report Library Security to match Company Access

Message Boards

MSX Group > Categories > Management Reporter Users > MR - Report Library Security to match Company Access

Note: Your browser does not have JavaScript enabled. Many features may not work properly without it. Please enable JavaScript in your browser settings.

Author

Comment

zsjn

Registered:1521140176
Posts: 1

Posted 1521143206	Reply with quote #1

We are an organization that has 45-50 different legal entities. Our GL team splits responsibility amongst the legal entities and should only ever see MR reports for the entities they were granted access to. We use Dynamics AX2012 R3 as our ERP solution and have set up security so that any MR report a GL user selects only allows them to generate the report for those entities. > We have all our reports using Report Viewer to view (and print or export to Excel) the reports. What we are finding is that all version of the reports from all users are sitting in the Report Viewer under the default Library folder and any given user can go to any of these reports and open it and view the content even though they do not have access to that entity. > An example would be our Balance Sheet. We have 1 Balance Sheet MR report with a tree associated with it (no security on the units). We designed our security with Organization access in AX. A user selects the Balance Sheet and then when they generate, they only can get results for the entities they were granted access to. However, if they look in the Report Library, they see all the other versions of the Balance Sheet and can open these and see data for entities they do not have access to. > Does anyone have a similar set up in place? If so, how did you structure the folder permissions and the report output and distribution settings to accommodate? > Any information is greatly appreciated. Thank you Sharon

Derek.Krebs

Moderator
Registered:1277751639
Posts: 105

Posted 1521150694	Reply with quote #2

Hi Sharon, I will be glad to quickly and complimentary dial in with you using GoToMeeting next week if you like to further illustrate or help. Please see the attached file (DynAXDataProvInstGuide.pdf, page ) as we can first review the User types and roles in AX and Mgt Rpt. I wish Mgt Reporter had better, centralized security like MSX Prospero does but Mgt Rpt has “decentralized” security by individual FOLDER and individual TREE and TREE unit. Therefore, I would leverage the security within the TREE probably to meet your needs. Glad to help with any other questions on Microsoft Mgt Rpt (reporting), Microsoft Forecaster (budgeting, both included with AX) and MSX Prospero (single product which replaces those two). Have a good day….. Derek Krebs Sr Consultant, MSX Group Phone: 760.274.6670 Email: Derek.Krebs@msxgroup.com Website: http://www.msxgroup.com MSX Group: Your expert resources for Management Reporter, Forecaster, FRx and MSX Prospero and other Reporting & Budgeting software (100% of our company focus the past 18+ years) Looking to replace FRx, Forecaster and Management Reporter? Check out MSX Prospero with many new features ALL in ONE easy to use application!!! LIVE demonstration of Prospero “8 Great Reasons to Switch to Prospero” Attached Files DynAXDataProvInstGuide (1).pdf (512.21 KB, 2 views)

Previous Topic | Next Topic

Easily create a Forum Website with Website Toolbox.

Modal title

Insert Code

Please paste your code into the box below: