topic Slowly changing dimension problem in QlikView

Slowly changing dimension problem

Wed, 22 Dec 2010 11:26:58 GMT

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.

Slowly changing dimension problem

Anonymous — Wed, 22 Dec 2010 12:52:35 GMT

Hi,

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

Cheers.

Slowly changing dimension problem

Thu, 06 Jan 2011 16:13:25 GMT

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.

Slowly changing dimension problem

Thu, 06 Jan 2011 16:16:58 GMT

Hi Cristian,

follow the steps in the example.

Good luck!

Rainer

Slowly changing dimension problem

Mon, 10 Jan 2011 10:41:54 GMT

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

Regards,

Cristian.

Re: Slowly changing dimension problem

Wed, 10 Apr 2013 21:18:13 GMT

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?