topic Slowly Changing Dimension example (using IntervalMatch) in QlikView

Slowly Changing Dimension example (using IntervalMatch)

Thu, 22 Oct 2009 18:13:00 GMT

HI,

Thanks for all the help with IntervalMatch. I managed to put together this example of a slowly changing dimension. (The product Code remains the Same but the Product Name changes and we need to retain and report on History.)

Hope this helps others ...

ColinR

Slowly Changing Dimension example (using IntervalMatch)

Fri, 23 Jul 2010 11:19:34 GMT

Hi ColinR,

First at all, thanks for the example.

I try to reproduce this example in my project and it doesn't work exactly like your example. The double relationship that the script creates in your example convert in a 'syn' relation in my example. I tried to copy-paste your script code in my script and create a 'syn' table too with exactly the same script code than yours.

It exists any flag to check this property?

Thanks in advance.

Xerx

Slowly Changing Dimension example (using IntervalMatch)

Mon, 25 Oct 2010 18:09:09 GMT

I have the same question as Xerx has there been any resolution/response ?

Slowly Changing Dimension example (using IntervalMatch)

Mon, 25 Oct 2010 18:14:05 GMT

Colin,

I have the same question as Xerx has there been any resolution/response about the syn key? ?

Slowly Changing Dimension example (using IntervalMatch)

Miguel_Angel_Baeyens — Mon, 25 Oct 2010 20:26:18 GMT

Hello,

You may use this example just in case.

Hope that helps!

Slowly Changing Dimension example (using IntervalMatch)

Mon, 25 Oct 2010 21:02:04 GMT

Miguel, after I looked closer I realized I was using the internal table view as opposed to the source table the syn is still there I just didn't see it at first and I couldnt see where it had been dropped in the code proper (because it was not). Thank you so much for your time I will review this example as well and see what I learn 🙂

Slowly Changing Dimension example (using IntervalMatch)

Miguel_Angel_Baeyens — Mon, 25 Oct 2010 21:08:06 GMT

You're welcome. For what is worth, synthetic keys are not so bad when they are done on purpose, and intervalmatch may be (may be not) one clear example for this. At the end of the day, what a synthetic key does is to create a composite key. I'm using some working datamodels where synthetic keys are wanted and performing fine, instead of renaming fields and create new fields.

Slowly Changing Dimension example (using IntervalMatch)

tseebach — Wed, 26 Jan 2011 22:11:38 GMT

Hey ColinR,

I've posted a solution to the shortcomings of your good example. Without any synthetic keys and support for multiple products 🙂

Have a look: http://guerrillabi.com/Slowly_Changing_Dimensions_QlikView