SCSM 2012 Dashboard by Signature Consultancy – Part 2: Requirements and Installation

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.

Requirements

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 SCSM 2012 Dashboard by Signature Consultancy - Part 2: Requirements and Installation

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

report-manager SCSM 2012 Dashboard by Signature Consultancy - Part 2: Requirements and Installation

report-manager SCSM 2012 Dashboard by Signature Consultancy - Part 2: Requirements and Installation

Click on the newly created folder.

report-manager SCSM 2012 Dashboard by Signature Consultancy - Part 2: Requirements and Installation

Select Upload File from the Main Menu.

report-manager SCSM 2012 Dashboard by Signature Consultancy - Part 2: Requirements and Installation

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

report-manager SCSM 2012 Dashboard by Signature Consultancy - Part 2: Requirements and Installation

Select and Upload each .RDL report file.

report-manager SCSM 2012 Dashboard by Signature Consultancy - Part 2: Requirements and Installation

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.

report-manager SCSM 2012 Dashboard by Signature Consultancy - Part 2: Requirements and Installation

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”

report-manager SCSM 2012 Dashboard by Signature Consultancy - Part 2: Requirements and Installation

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.

report-manager SCSM 2012 Dashboard by Signature Consultancy - Part 2: Requirements and Installation

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-manager SCSM 2012 Dashboard by Signature Consultancy - Part 2: Requirements and InstallationIn the menu on the left, choose Data Sources, and click the Browse button.

report-manager SCSM 2012 Dashboard by Signature Consultancy - Part 2: Requirements and Installation

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

report-manager SCSM 2012 Dashboard by Signature Consultancy - Part 2: Requirements and Installation

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

report-manager SCSM 2012 Dashboard by Signature Consultancy - Part 2: Requirements and Installation

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.

report-manager SCSM 2012 Dashboard by Signature Consultancy - Part 2: Requirements and Installation

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.

%d bloggers like this: