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
Service Manager Data Warehouse schema is now available
Chris Lauren [MSFT]Microsoft EmployeeThursday, March 17, 2011 5:47 AMIn 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.
- 03

Is my Data Warehouse installed correctly ?
Jente V 14 minutes ago - 030

List re-categorized Incidents in a report
MMüller Monday, May 21, 2012 9:47 AM - 92248

SCSM 2012 Cubes Fail to Process
D. Elliott Friday, December 09, 2011 12:46 PM - 61385

Incident Analyst Report Details
Zaid Umer Farooqui Tuesday, January 10, 2012 4:45 AM - 1267

SCSM 2012 Dashboard
Parag_M Saturday, May 12, 2012 6:46 PM - 2675

Date Filter in an Excel report in SCSM 2012
Stefan Allansson Wednesday, April 04, 2012 2:01 PM - 2293

Data Warehouse management packs failed
Patrick Zhang Monday, May 07, 2012 7:54 PM - 4438

Data warehouse connection to main SCSM DB fails when a new field is added to incident class
YSobhdel Monday, April 30, 2012 6:01 AM - 1245

Data Warehouse Registration Issues
Chris Akeroyd Monday, May 07, 2012 9:56 PM - 0220

ETL Module Execution failed
Jake Daryl Tuesday, May 08, 2012 8:15 AM - 2766

DW 2012 event viewer error 33410
newtoscsm Monday, March 05, 2012 2:18 PM - 3893

Unregistering a Data Warehouse from SCSM 2012 after having it uninstalled first
Scott K. Jones Friday, March 16, 2012 10:56 PM - 2451

All Cube Processing jobs have a status of Failed (new SCSM 2012 RTM deployment)
Bryan Wilson - bmwilson1978 Monday, April 23, 2012 12:02 AM - 1375

Rule "Windows 2003 IA64 Check" failed
jamicon Wednesday, April 18, 2012 4:45 PM - 1405

I have problem with DW Extract_XXX Job
maikarim Friday, April 13, 2012 8:19 PM - 6553

Report Parameters
JPFG Monday, April 02, 2012 11:59 AM - 3477

How to make History get replicated to DataWarehouse?
Dan_MS Wednesday, April 11, 2012 12:55 PM - 81777

Reporting workspace disappeared!
Mearsma Monday, October 31, 2011 8:30 PM - 2601

Multiple data warehouses on same SQL instance
NextToNothing Thursday, April 05, 2012 4:26 PM - 4607

how to get Analyst Comments of Problems in Problem Management using Sql Server
dalopez.flores Thursday, March 29, 2012 6:48 PM

