local_phone(877) 456-7632 local_post_officeinfo@msxgroup.com
Message Boards
Sign up Latest Topics

  Author   Comment  

Posts: 1
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

Posts: 109
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
pdf DynAXDataProvInstGuide (1).pdf (512.21 KB, 2 views)

Previous Topic | Next Topic

Quick Navigation:

Easily create a Forum Website with Website Toolbox.