Skip to main content
DD-TRF-004 Enterprise Data Transformation and Performance Lab Get the data →
DD-TRF-004-Q044 Very Hard Time series

Sales re-tiered by the SCD change

For customers whose tier changed, total the Amount in SAR of rows dated before the change (old tier as at the date) that the current-tier view would assign to the new tier.
Expected
Amount re-tiered and the customers affected · Matrix
Tables
FactDataPipelineEvents, DimCustomerSCD · columns
  • FactDataPipelineEvents
  • DimCustomerSCD
  • CustomerCode
  • TransactionDate
  • ValidFrom
  • ValidTo
  • Tier
  • Amount

Discussion

No one has posted here yet. Ask something, compare your result, or share how you solved it.

A free account takes a minute. Your draft is kept while you sign in.

Create a free account Sign in