Slowly changing dimension problem

[#1]

Hi.

I have a problem regarding slowly changing dimension.

I have a Sales table that contains

OrderDate

StoreID

The second table (is a historical sales table)

SalesPersonID

StoreID

StartDate

EndDate.

My problem is the fact that i have to figure what sales person had an order connected to it by linking it with the history sales table.

I am clueless.

[Anonymous]

Hi,

To solve this you will need to use the INTERVALMATCH function. There are some good examples in the reference manual.

Cheers.

Ad

[#3]

Hi. I have resolved the slowly changing dimension problem but i have a synthetic key now. How can i remove a synthetic hey from a slowly changing dimension?

code:

Sales:

load

OrderDate,

TerritoryID,

OrderNumber

resident tSales;

inner join intervalmatch (OrderDate,TerritoryID) load StartDate,EndDate,TerritoryID from history.

I have a synthetic key regarding StartDate,EndDate, TerritoryID. How can i remove that ?

Regards

Cristian.

[#4 · Accepted solution]

Hi Cristian,

follow the steps in the example.

Good luck!

Rainer

[#5]

Thank you very much for the solution. It is what i was looking for.

Regards,

Cristian.

[#6]

Ad,

What reference manual are you referring to?  The one I have for QV 11, has two mentions of the Interval Match, and 0 examples.

Can you help?