/* Revenue By State — detail (DatawarehouseNCM) Fact: dbo.FactRevenueByState PBI: "Revenue By state" (RevenueData grain) / SP RELO_ClientRevDetail_State_PBI Detail rows matching the PBI table. State/City already resolved at load (departure work location when ActNumbr3 in MVP/HBO/MAP, else destination). */ DECLARE @StartDate datetime = '2026-01-01'; DECLARE @EndDate datetime = '2026-01-31'; DECLARE @State varchar(30) = NULL; -- NULL / '' = All; e.g. 'California' SELECT f.ActNumbr1, f.ActNumbr2, f.ActNumbr3, f.ActNumbr4, f.TEFileNo AS GroupId, f.TELastName, f.DocDate, f.CodeId, f.Amount, f.City, f.State, f.CorpCode, f.ActDescr, f.Source FROM dbo.FactRevenueByState f WHERE f.DocDate BETWEEN @StartDate AND @EndDate AND (@State IS NULL OR @State = '' OR f.State = @State) ORDER BY f.DocDate DESC, f.ActNumbr1, f.ActNumbr2, f.ActNumbr3, f.ActNumbr4, f.TEFileNo, f.TELastName, f.CodeId, f.City, f.State;