Measure Backfill Status

Measure Backfill data is stored in the Model.MeasureBackfill in the BI Gateway datastore. When you deploy a measure, a record is created in the table with the execution plan in the measure backfill and it also records the current execution plan and time slice.

You can get current status of the measure from the data store using the following SQL statement.

SELECT 'Model.Measurebackfill'

, da.Name

, CASE m.Status

WHEN 0

THEN 'Processing'

WHEN 1

THEN 'Completed'

WHEN 2

THEN 'Suspended'

END as Status

FROM Model.MeasureBackfill m

left join Model.DataItems da

on m.DataItemGuid = da.DataItemGuid

order by da.Name