Service Manager Data Warehouse schema now available

re: Service Manager Data Warehouse schema now available

Wyatt Wong — Fri, 21 Sep 2012 04:37:29 GMT

Is there a data warehouse schema for Service Manager 2012 ?

re: Service Manager Data Warehouse schema now available

shumail — Tue, 29 May 2012 08:27:02 GMT

why Assigned to user not showing for the incidents which are in DW but not in Service manager DB

re: Service Manager Data Warehouse schema now available

Peter De Coninck — Thu, 24 Mar 2011 15:15:41 GMT

So I should create a few synonyms(in this case for incident_log) and make my queries on that synonym. And after the procedure ran, the data is transferred to DWDataMart?

Do I insert data on views or on tables?(if I recall correctly, StatusDuration inserts on views..)

Greetings,

Peter

re: Service Manager Data Warehouse schema now available

Chris Lauren [MSFT] — Thu, 24 Mar 2011 13:11:48 GMT

To write a custom transform, you need to pull the data from DWStagingandConfig. The transform stored procedure will reside in the Repository database, so for examples you could script out the transform stored procedures we ship out of the box. TransformIncidentStatusDuration is a good example of a custom stored proc we wrote (as oposed to automatically generated).

The data get extracted and stored in the DWStagingandConfig database regardless of whether there are any facts, dimensions or outriggers which use them. After the transforms have run, the data which has been processed or which was not used by any transforms is marked as eligible for grooming.

re: Service Manager Data Warehouse schema now available

Peter De Coninck — Thu, 24 Mar 2011 10:08:30 GMT

[Quote]

For custom fact tables, the Service Manager Data Warehouse infrastructure will automatically generate the code required to extract the data from Service Manager into the warehouse, and to load the data mart from the Repository database, but the transform code must be provided by the developer creating the custom fact table.

[/Quote]

Where does the data stop when there is no transform-code supplied by the developer? In other words, are the queries to populate tables made on Repository or on StagingAndConfig?

Greetings