Service Manager - Data Warehouse, Reporting and Dashboards
This forum covers topics related to the data warehouse, ETL, MP Sync, reporting infrastructure, reports, creating custom reports, and the dashboard.
Announcements
- Link
Service Manager Data Warehouse schema is now available
In my recent blog post I've attached a schema as well as some guidance as to how to navigate through the DW, what the type of tables are and more.
Filtering and SortingUse these options to narrow down the question and discussion list.
- 4530

Error when attempting to access Analysis Library Folders
Marcel Hager Monday, January 28, 2013 7:36 PM - 026

How to get the user friendly name in place of an Enumaration ID (list value) in the Data Warehouse cubes
James Mastro Thursday, May 23, 2013 8:29 PM - 5954

Outriggers do not show List item values (Display names) in DB, but enumeration Id`s instead.
Egils Zonde Monday, January 07, 2013 8:20 AM - 028

'Snapshot' reporting from the Data Warehouse.
Shaun Laughton__ Thursday, May 23, 2013 10:44 AM - 172

Reporting of Incident resolution
gillem Friday, May 17, 2013 2:43 AM - 046

A Management Group with the Same Name is already Registered
Ergo Support Wednesday, May 22, 2013 1:43 PM - 032

Service Manager 2012 Cube Reporting, Start Date and End Date
Herb Winhoven Wednesday, May 22, 2013 12:16 PM - 1116

Finding the correct target end date for incidents
Sebastian Nyberg Tuesday, April 30, 2013 8:03 AM - 140

How to link IncidentDimvw with ActionLogDimvw (Report Incidents with Analyst comments)
Aleksey Ozerov Wednesday, May 22, 2013 5:51 AM - 034

Recognized my software as Virus
VanessaDT Wednesday, May 22, 2013 6:57 AM - 143

Console reporting access only, SCSM 2012
Trana010 Monday, May 20, 2013 11:18 PM - 037

Service Manager 2012 Date Rollup in DW Cubes
Herb Winhoven Tuesday, May 21, 2013 9:09 PM - 281

McAfee EPO Custom Connector
James Mastro Friday, May 17, 2013 1:08 PM - 9175

Guids showing in place of list values for custom list properties
James Mastro Thursday, May 02, 2013 8:10 PM - 252

create outrigger with Etended CR Form
Fletcher Kelly Monday, May 20, 2013 1:03 PM - 4109

Service Manager 2012 aging report
Herb Winhoven Friday, May 10, 2013 2:38 AM - 61233

service manager 2012 data warehouse high Watermark monitor
Fletcher Kelly Wednesday, October 31, 2012 6:58 AM - 17433

Where to place the outrigger section
WTCBrummi Friday, April 19, 2013 9:50 AM - 7106

Service Manager 2012 Data Warehouse cleanup questions
Herb Winhoven Friday, May 10, 2013 6:49 PM - 162

Service Manager 2012 Service Request Fulfillment reporting
Herb Winhoven Friday, May 17, 2013 1:13 AM

