50
Does anyone know how the MR 2012 Reports are generated, do they have SQL Queries they use to get the data together.
If so, where are the sql scripts, as I have a mini project I am looking at for myself and trying to reproduce the reports in PowerBi. Has anyone else done this and will be willing to share their experiences and knowledge
Kind regards
Brian
Hi Brian,
The MR reports are generated by the MR Process service. I don't have SQL queries that MR uses when the report is generated. You could run a SQL trace while generating a report to capture what is happening. It will vary depending on if the data mart or legacy provider are used. It will also vary from report to report, since things like dates, accounts, company could change from one report to another.
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,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
