/* Revenue By State — fact sample / load check (DatawarehouseNCM) Quick check that FactRevenueByState loaded. */ DECLARE @StartDate datetime = '2026-01-01'; DECLARE @EndDate datetime = '2026-01-31'; -- Detail sample SELECT TOP 100 f.CorpCode, f.TEFileNo, f.TELastName, f.DocDate, f.Amount, f.ActNumbr1, f.ActNumbr2, f.ActNumbr3, f.ActNumbr4, f.CodeId, f.City, f.State, f.Source FROM dbo.FactRevenueByState f WHERE f.DocDate BETWEEN @StartDate AND @EndDate ORDER BY f.DocDate DESC, f.CorpCode; -- Totals by source SELECT f.Source, COUNT(*) AS [RowCount], SUM(f.Amount) AS Amount FROM dbo.FactRevenueByState f WHERE f.DocDate BETWEEN @StartDate AND @EndDate GROUP BY f.Source ORDER BY f.Source;