Solution is to add the following to the beginning of your status expression:

CASE WHEN IsEmpty(KpiValue("MyKPI")) THEN NULL

Could someone help me pull the DayOfWeek from the ExecutionDate? I need something like:

Monday, 10/31/2005. I am having touble getting just the day of week section.

Any future readers may be interested.

Couldn't wait on the rollback so we stopped sql server, blew away the database, and restored from backup.

That watchin' and waitin' can be painful!

Thanks for the responses!

That must be our issue then....is there anyway to speed up such a rollback process? Or am I at the mercy of the DB.....Watch and wait,...

If it is rolling back, wouldn't the Command be marked as ROLLBACK instead of AWAITIN COMMAND? That would make sense though if the process is rolling back, but why...