Microsoft System Center DPM integrates into SQL Server Reporting Services to create custom reports. In the Reporting task area of the Administration Console, you can generate and view custom reports, schedule report generation, manage report settings, and subscribe to reports.
DPM includes a number of SQL Server views that can be used to create custom reports. SQL Server views provide a much simpler way to query SQL tables directly, by populating columns of data collected from multiple tables stored in the SQL database. Here, you don't need in-depth knowledge about the entire SQL Server database or the underlying relationship between tables and keys.
The use of SQL Server views can degrade the overall performance if used frequently and this is because the view is dynamically generating the data each time the view is queried.