The 30 day filtering is done using the control.tblTransactionSummaryReloadDates table. This has 30 date key values loaded into it in a previous step of the ETL and so the inner...

Unfortunately everything I do for this client is 'too many rows' - they are a large international retail chain and have enormous data quantities coming into their DW on a...

Sorry I'd forgotten I'd used views. The vfactSalesSummary view is:
SELECT  StoreKey
     , EmployeeKey
     , EmployeeClassKey
     , TillKey
     , DateKey