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

Sales by customer tier as at transaction date

Join each cleaned row to DimCustomerSCD on CustomerCode where TransactionDate falls between ValidFrom and ValidTo, and total Amount in SAR by Tier. Compare with the total using only the current row (IsCurrent = 1). Report the Gold total both ways.
Expected
Tier, as-at total, current total, difference · Matrix
Tables
FactDataPipelineEvents, DimCustomerSCD · columns
  • FactDataPipelineEvents
  • DimCustomerSCD
  • CustomerCode
  • TransactionDate
  • ValidFrom
  • ValidTo
  • Tier
  • IsCurrent
  • 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