New Data Warehouse Architecture Diagram

re: New Data Warehouse Architecture Diagram

JavoMejia — Thu, 18 Apr 2013 18:41:22 GMT

Hello Travis,

I´m creating some reports to take a look of the total real resolution time, when I say real I mean the time between the working hours of the SLO calendar or company calendar. There is a view called "incidentestatusdurationfactvw" that has a row named "TotalTimeMeasure" that field store the time in minutes for every incident state but the time calculated is base on 7x24 and not on the SLO calendar.

do you know if there is any table that has the total real time base on the company calendar and not on the 7x24?

as example:

Working hours = 10 per day between 8AM and 6PM Monday to Friday

New Incident Registered at 5:PM on Friday

Incident Resolved next Monday at 9AM

Real resolution time should be: 120 minutes ( Total Real Active time 1hour on Friday and 1 hour on Monday )

Time store on DWDataMart incidentestatusdurationfactvw = 3840 minutes ( Total time between Friday to Monday including non-working days Sat-Sun.)

Thanks!

re: New Data Warehouse Architecture Diagram

Travis Wright MSFT — Fri, 22 Mar 2013 21:52:37 GMT

@Marcel - I would suggest creating a support case with Microsoft to see about investigating fixing that issue.

re: New Data Warehouse Architecture Diagram

Marcel Hager — Fri, 22 Mar 2013 17:29:26 GMT

What I would like to know is what is the best way to integrate all the System Center databases like shown in the diagram when there is a MAJOR issue with the Exchange 2010 MP. I have had to rebuild my SCSM DW from scratch TWICE now because little did I realize that when you add Operations Manager to Service Manager as a datasource, it will attempt to pull in all the MPs that SCOM has and it ALWAYS fails on the Exchange 2010 MP, which causes all processing on the DW to stop. All Sync jobs, all ETL jobs, all Cube jobs.

As it stands right now, it is IMPOSSIBLE to have this level of integration in our environment, just because we happen to be using and monitoring Exchange 2010. This seems like a major problem that needs to be addressed before this data model can be used correctly.

re: New Data Warehouse Architecture Diagram

Wyatt Wong — Fri, 22 Mar 2013 06:08:00 GMT

Please provide an old version of Visio format .vsd file for download.

re: New Data Warehouse Architecture Diagram

Shailesh — Sat, 09 Mar 2013 06:39:31 GMT

very good...

but difficult to understand. Give some explanation.

re: New Data Warehouse Architecture Diagram

Joe Thompson — Fri, 08 Mar 2013 19:59:11 GMT

Backwards compatible version would be much appreciated...

Thank you!

re: New Data Warehouse Architecture Diagram

Anatoliy Pavlyuchenko — Mon, 18 Feb 2013 13:11:44 GMT

Hi, Travis

Thanks a lot for sharing.

Would it be possible to place file in any previous Visio version as well?

Thanks in advance,

Anatoliy

re: New Data Warehouse Architecture Diagram

Waqas M — Sun, 17 Feb 2013 05:20:40 GMT

Thanks for sharing