In our previous post, we introduced you to the SCSM 2012 Dashboards by Signature Consultancy. In this post we will walk through the Requirements, and the Installation procedure.


Following along with the Deployment and Configuration Guide provided by the Vendor, the use of these Dashboards has the following requirements.

  1. System Center 2012 Service Manager (SCSM) Data Warehouse feature installed/configured
  2. System Center 2012 Service Manager (SCSM) Data Warehouse Cubes that have completed processing and are ready for use
  3. Microsoft SharePoint 2010 (version Foundation, Standard, or Enterprise)

Installation Procedure

Data Warehouse Side -­ Import Files

Log into the System Center Data Warehouse, launch a browser, navigate to to http://<SSRSServerName>/Reports, and login with an account that is a Report Administrator. In my lab example, because I have a Named SQL Instance, my URL is http://scsm-dw/Reports_SCSMDW.

Report Manager

Under SQL Server Reporting Services, click New Folder, use “SCSM Dashboard” for the name, then click OK.

New Folder

New Folder - SCSM Dashboard

Click on the newly created folder.

Newly Created Folder

Select Upload File from the Main Menu.

Upload File

Select Browse, and locate the Signature SCSM Dashboard folder where you downloaded the report files to.


Select and Upload each .RDL report file.

Upload Report Files

Now that the report files are uploaded, we need to create a New Data Source for the reports to use. Select ‘New Data Source‘ from the menu.

New Data Source

On the New Data Source screen, enter the following information.

  • Name: “SCSMDashboardDataSource”
  • Data Source Type: “Microsoft SQL Server Analysis Services”
  • Connection String: “DataSource=;Initial Catalog=DWASDataBase”
  • Connect Using: “Windows Integrated Security”

NOTE: In my lab example, I am using a Named SQL Instance. Therefore, my Connection String is as follows: “DataSource=SCSM-DWSCSMDW;Initial Catalog=DWASDataBase”

New Data Source - Details

Once you have enter all the appropriate information / selections, click the ‘Test Connection‘ button. Ensure that the connection results show “Connection created successfully“, then click OK to save the settings.

Test Connection

From the browser, in the SCSM Dashboard folder, perform the following for each .RDL report file.

Select Options (the down arrow) and choose Manage.

Report - ManageIn the menu on the left, choose Data Sources, and click the Browse button.

Data Sources - Browse

In the folder explorer, browse to the Data Source that we previous created, select it, then press OK.

Browse - Data Source - SCSMDashboardDataSource

Back on the Data Sources screen, ensure that the Shared Data Source is completed, then click Apply.

Data Sources - Apply

Navigate back to the SCSM Dashboard folder, then repeat the same steps for the other Report (.RDL) files.

After you have applied the Data Source for all the Reports, navigate back to the SCSM Dashboard folder (that contains the .RDL files), and click on one of the reports. This will launch the report, which should populate with your data.

NOTE: In my lab example, I didn’t have any data to display.

Launch Report

In the last post of this series, we will cover Publishing the Dashboards in the SharePoint Portal.


As always, if this post helped you in any way, and you would like to show your appreciation, please rate it and comment on it. Also, feel free to contact me with requests for future articles.