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.
- 8148
Guids showing in place of list values for custom list properties
James Mastro Thursday, May 02, 2013 8:10 PM - 156
Unregister a Service Manager Data Warehouse.
DonDraper60 Tuesday, May 14, 2013 10:54 PM - 6103
One SQL Server for all SCSM databases
Marc Lopez Monday, May 06, 2013 7:41 AM - 12542
Microsoft.SystemCenter.Datawarehouse.OLAP.Base MP in MPSyncJob stuck in Pending Association
drnewo Thursday, March 14, 2013 6:24 PM - 1101
Service Manager 2012 Data Warehouse Cubes permissions
Herb Winhoven Friday, May 03, 2013 6:49 PM - 1116
How do you add Outrigger (Enumeration lists) into SCSM 2010 Data Warehouse?
EdShep Thursday, May 02, 2013 4:08 PM - 197
Report column does not report list
雷龙 Friday, May 03, 2013 12:47 AM - 3145
Reports and Dashboard Update latency upto 24 hours not acceptable
Shahid Roofi Thursday, April 25, 2013 8:59 PM - 4304
Service Manager Dashboards and Time Intelligence
ButtyT Monday, April 15, 2013 2:41 PM - 4914
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 - 1145
Orphan Reporting Management Pack in Datawarehouse
drnewo Saturday, April 20, 2013 2:51 PM - 4638
Management Pack list not in sync between DWStagingAndConfig and DWRepository/DWDataMart
Gabriel.Taylor Thursday, March 07, 2013 3:20 PM - 4201
User and Anlyst Comment reports Per Ticket
RommelD Wednesday, April 10, 2013 1:03 PM - 132180
Error in transform.common ETL job
Patchoeli Monday, July 23, 2012 2:09 PM - 41677
extending teh DW to accept incident file attachments
EdShep Wednesday, July 18, 2012 3:41 PM - 31454
We have extended our DW to include all ActionLogs - It is only extracting new logs added since the MP was imported
EdShep Wednesday, July 18, 2012 11:00 AM - 42529
Data Warehouse registration failed
SirKoon Monday, March 05, 2012 7:14 PM - 2229
Creating A Custom Cube - When I try and seal a management pack with custom cube creation code in it, the Authoring Tool strips out the code
Mickey Gousset Friday, March 29, 2013 7:30 PM - 2218
Management Pack association warnings in Event Log on DataWarehouse server
Marcel Hager Tuesday, March 19, 2013 6:06 PM - 1191
Any one seen this after upgrading to SP1 and using the latest console?
needhelp..... _ Sunday, March 17, 2013 10:50 PM
.png)
