/* Supplier Diversity Spend — fact sample / load check (DatawarehouseNCM) Quick check that FactSupplierDiversitySpend loaded. */ DECLARE @StartDate datetime = '2026-01-01'; DECLARE @EndDate datetime = '2026-01-31'; -- Detail sample SELECT TOP 100 f.CorpCode, f.TEFileNo, f.TransactionDate, f.CompanyName, f.VendorId, f.Payee, f.Category, f.Amount, f.DiversityCertification, f.SubClassDescr, f.VendorType FROM dbo.FactSupplierDiversitySpend f WHERE f.TransactionDate BETWEEN @StartDate AND @EndDate ORDER BY f.TransactionDate DESC, f.CompanyName; -- Grand total SELECT COUNT(*) AS [RowCount], SUM(f.Amount) AS TotalSpend FROM dbo.FactSupplierDiversitySpend f WHERE f.TransactionDate BETWEEN @StartDate AND @EndDate;