...building hybrid clouds that can support any device from anywhere
In the two previous blog posts, we showed how Service Manager and PerformancePoint should be configured as well as discuss the background behind Reporting and how Service Manager can makes use of this.
To recap this is a tutorial of three blog posts:
Blog Post 1: Discuss the background behind Reporting and how Service Manager can makes use of this. (Previous blog post)
Blog Post 2: Show how Service Manager and SharePoint PerformancePoint can be integrated to show analytics' data in SharePoint. (Previous blog post)
Blog Post 3: Generating a dashboard based on data in Service Manager Data Warehouse. (This blog post)
In this blog post we will create the actual dashboard inside SharePoint PerformancePoint based on the connection we created to the Service Manager Chargeback cube in the Previous blog post.
In order to create the Dashboards the following should be done
Generating a dashboard based on data in Service Manager Data Warehouse
In SharePoint, we need to create the following items to create SharePoint PerformancePoint Dashboard using System Center Data Warehouse
Let’s get started
Create an analytic chart in Dashboard Designer
1. Start a browser on the SharePoint Server and go to the new PerformancePoint site created earlier
2. Click on “Create Dashboards” in the lower right side of the page and select “Start using PerformancePoint Services”
3. Click Run Dashboard Designer
4. In Dashboard Designer console select “PerformancePoint Content”
5. Right Click on “PerformancePoint Content” and select “New Report”
6. In the “Report Template” select “Analytic Chart”
7. Select the Data source that was created in the Previous blog post and Click “Finish”
8. Give the Report a name e.g. “VM Day to Day Spending”
9. Select “VM Day to Day Spending” in the Workspace Browser
7. In the Details Pane Select “Measures”
8. Expand “Measures” and scroll down until “VM Total costs” shows in the list
9. Select VM Total Cost and Drag and Drop it over to the “Series” Box in the lower central pane
10. Go back to the details view and Extend Dimensions > ServiceManagerInfraChargebackDataDim > Calendar Date
11. Drag and drop this into the “Bottom Axis”
12. You should now see Data in the central window showing VM Cost and Dates at the bottom of the Report.
12. Right Click in the central view and select “Filter” > “Filter Empty Axis Items”
13. Repeat step 4-12 using the following details:
Name of Report Series value (Measures) Bottom Axis (Dimensions) VM Price by Cloud VM Total Cost PrivateCloudDim > DisplayName VM Price by Roles VM Total Cost UserRoleDim > Display Name VM Price by Price Sheet VM Total Cost PricesheetDim > Display Name
14. There should now be 4 reports in the Performance Content View
Create a Dashboard to show Analytics charts in SharePoint
In the same Dashboard Designer used when making the Reports do the following:
1. In Dashboard Designer console select “PerformancePoint Content”
2. Right Click on “PerformancePoint Content” and select “New > Dashboard”
3. In the “Select a Dashboard Page Template” select “2 Columns” and click “Ok”
4. Give the Dashboard a name E.g. Chargeback Dashboard under “Workspace Browser windows”
5. Click on Name (Page 1) and Rename it to Chargeback Dashboard.
6. In the Details pane extend “Reports” > “PerformancePoint Content”
7. Select “VM Day to Day Spending” and drag and drop it into “Dashboard Content” > “Left Column”
8. Do the same for “VM Price sheet” and drag & drop this below the “VM Day to Day Spending” in the “Left Column”
9. Drag and drop “VM Price by Cloud” and VM Price by Role” to the “Right Column”
Publish a Dashboard to PerformancePoint & Drill Down
In order to publish the dashboard in SharePoint, do the following
1. Right Click on the dashboard just created and select Deploy to SharePoint
2. If prompted Select SharePoint Server and Version and Click “Ok”
3. A browser windows will open and show the Dashboard inside PerformancePoint
The Dashboard should look similar to the following
Drill Down on data in a Dashboard
In order to do drill down on data shown in the dashboard do the following
1. Right Click on pillar inside the “VM Price by Price sheet
2. Select “Drill Down to” > “VirtualMachineDim” > “Display Name”
3. Another report will show, where a drilldown of VM inside the Price by Price sheet pillar is shown
I hope this introduction to Service Manager and SharePoint PerformancePoint will help you better utilize these functions to show Dashboards in your organization.
Please let me know if you have any feedback on this series!
Thanks again for all this useful posts !