MR 2012 Data Locations

(0) Share

Report

Posted on by Community Member

I would like to create some SSRS reports against Management Reporter data, but I am unclear on where the content is stored. Can someone help me find the location for the following:

1. Tree security - I would like to know where the Unit Security information is stored. If I am able to query this data, I could create a report that shows a user all of the accounts they have access to.

2. Balance information. I would like to create a query to pull the "Available Balance" for a particular account. It is calculated on the report and displayed as a total already. Does MR store that value in a table, and if so, which one?

We are using the legacy integration, MR 2012, and GP 2013.

Thanks,

Brian

*This post is locked for comments

I have the same question (0)

All responses (1)

Answers (0)

sueconrod 337 on at

Like (0)

Report
Copy link

Link copied!

All of the Data is coming from Great Plains:

GL20000 Open Year trx, GL30000 History Year GL Trx

GL00105 Account index master since everything above is stored in as an index

GL10110 current Summary Master

GL10111 history Summary Master

GL00201 Budget Summary Master

I've looked in the MR2012 tables and not finding anything that links to the reports, anyone find anything different? Possibly in the DDM

Was this reply helpful? Yes No