How to Create a Data Source for Dashboard Designer

 

Updated: May 13, 2016

Applies To: System Center 2012 SP1 - Service Manager, System Center 2012 R2 Service Manager, System Center 2012 - Service Manager

You can use the following information to create a new data source in System Center 2012 – Service Manager and save it by using Dashboard Designer.

The workspace is an XML document that defines the PerformancePoint item definitions for a particular project. The saved workspace items are stored in SharePoint lists and libraries. You can add existing stored items to a workspace, based on the project requirements.

To create a data source for Dashboard Designer

  1. Open PerformancePoint Dashboard Designer, and in the Workspace Browser, select Data Connections.

  2. Click the Create tab, and then click Data Source.

  3. In the Select a Data Source Template dialog box, select Analysis Services, and then click OK.

  4. In the New Data Source pane, ensure that the Editor tab is selected, and then type information for the connection settings for the data source using the examples in the following table.

    Property Value
    Server <YourServerName>
    Database DWASDataBase
    Cube ServiceManager WorkItems Cube
  5. To save the data source, in the Workspace Browser pane, right-click the new data source, and then click Save. As an option, you can rename the data source.

  6. To save the workspace, click Save As, and save the Dashboard Designer Workspace in the folder that you want.

See Also

Creating and Deploying Dashboards