How to Create the Incidents by Analyst Report
Updated: May 13, 2016
Applies To: System Center 2012 SP1 - Service Manager, System Center 2012 R2 Service Manager, System Center 2012 - Service Manager
Use the following procedure to create an Analytic Grid report named Incidents by Analyst.
To create the Incidents by Analyst report
Open Dashboard Designer, connect to the server that hosts the DWASDataBase, and then click Service Manager WorkItems Cube. Or, if you have previously saved a designer workspace file that contains the connection information, open that file.
In the Workspace Browser, right-click the PerformancePoint Content list, select New, and then click Report.
In the Select a Report Template dialog box, select the Analytic Grid template, and then click OK.
In the Create an Analytic Grid Report wizard, on the Select a Data Source page, select the SystemCenterWorkItems data source, and then click Finish.
In the Workspace Browser, modify the name of the report to Incidents by Analyst, and then press Enter.
To configure the report, in the Details pane, expand Dimensions, expand the AssignedToUserDim dimension, and then drag the User Name attribute into the Rows drop zone.
To configure the hierarchy member selection, in the Rows drop zone, click the down arrow to the right of the AssignedToUserDim hierarchy to open the Select Members dialog box.
In the Select Members dialog box, right-click All members member, point to Autoselect Members, click Select “User Name”, and then click OK.
In the Details pane, expand Measures, and then drag the IncidentDimCount and Incidents Resolved Count measures into the Columns drop zone.
Right-click the Incidents Resolved Count column heading, point to Sort, and then click Smallest to Largest.
Right-click anywhere in table, point to Filter, and then click Filter Empty Rows.
In the Details pane, expand Dimensions, expand the IncidentDim_IncidentClassification dimension, and then drag IncidentClassificationValue into the Background drop zone.
On the Edit ribbon tab, in the View group, click Settings.
In the View Settings window, click Show Information Bar, and then click OK.
In the design pane, click the Query tab, and then review the MDX expression that was created automatically to support the report design.
To save the report, in the Workspace Browser, right-click the Incidents by Analyst report, and then click Save.
See Also