Did the Enterprise Manager Load Fail?

In the day to day operations, it is sometimes difficult to stop and check on the status of the enterprise manager data. You've got development requirements and business needs to focus on. Still, having the usage data from enterprise manager can be critical.

Troubleshooting the cause of an Enterprise Manager failure is for another day/post. Here I'll share how I stay up to date on the status of my enterprise manager data load.

The process is fairly simple. I have a query I use to find the most recent data loads for both documents and reports pulled from the Enterprise Manager fact tables. Within the query I define a threshold (24 hours in my case) and setup a MicroStrategy subscription using the query.

In my sample code below, if the CompareDate = 1, then there is a problem in the Enterprise Manager load.

SELECT

Type

, MaxDate

, CASE

when Maxdate < dateadd(hh,-24,Getdate())

THEN 1

ELSE 0

end AS CompareDate

FROM

(SELECT 'Document/Dossier' AS Type, Max(EM_Load_TS) AS MaxDate

FROM Is_Doc_Fact with (readuncommitted)

Union All

SELECT 'Report' AS Type, Max(EM_Load_TS) AS MaxDate

FROM Is_REP_Fact with (readuncommitted)) AS a

And that's it! Sometimes, it's best not to over complicate things.

---

Thanks for checking out this blog post. If you found this post helpful please consider donating. Any contribution is appreciated! Just click the PayPal icon at the bottom of this page.