web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / CRM 2016 On-Prem Repor...
Microsoft Dynamics CRM (Archived)

CRM 2016 On-Prem Reports - Data Mart

(0) ShareShare
ReportReport
Posted on by ChrysDW

We have a team that is working on building reports. That team is planning on pulling data from CRM into a data mart to use strictly for CRM reporting using SSRS.  Their concern for running reports in CRM is a performance hit. My concern with the data mart is the security/privileges that the data mart will not offer that CRM has for each user.  I also have the concerns about the reports being built using tables and not the FilteredViews.  I'm trying to push back on the data mart but I would like more documentation or direction from other more experienced users. We have discussed replicating the database but this idea didn't seem to go over so well either. Do I have a legitimate concern with this?

Any insight, opinions, articles or documentation would be greatly appreciated.

Thanks,
Chrys

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Aric Levin - MVP Profile Picture
    Aric Levin - MVP 30,190 Moderator on at

    Hi Chrys,

    Not sure what type of reports you are running, but most reports should not be a cause of a major performance hit on CRM. If they are, then something is not optimized  (either the reports or SQL Server).

    I think the major concern that you should have here, as you already mentioned is the fact that users might see data that they are not supposed to see, since the report builders are not using Filtered Views, and accessing the data that is accessible at all security levels of the organization. I believe this should be the primary concern of the business owners.

    If this is not a concern for them, and access to data is not an issue, they can go ahead with Data Mart.

    Hope this helps.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans