How to use SCD in qlikview.

[Naps_230]

Hi ALL,

I have some question.

1.Please let me explain, how to use SCD in Qlikview.

2.How to konw what license provide to user in QMC.

Regards

Jasobanta

[Vegar]

Hi Jasobanta,

Take a look at my colleague Tim Little's blog post on the topic.

http://bi-effekten.se/2015/05/19/managing-scd1-logic-in-qlikview/

Cheers,

Vegar Lie Arntsen 

[jonathandienst]

I assume you mean a type 2 slowly changing dimension (see here Slowly changing dimension - Wikipedia‌ and http://www.kimballgroup.com/2008/08/slowly-changing-dimensions/)

This is fairly straightforward in Qlikview using an extended interval match - this is an interval match with one or more key values in addition to the from and to dates.Assuming your fact load includes a date field, like this

Fact:

LOAD

    TransID,

    TransDate,

    ...

And your SCD table looks something like:

Dimension:

LOAD

    From,

    To,

    Key,

    Attribute1,

    Attribute2,

    Attribute3

     ....

You can incorporate this using an interval match join:

IntervalMatch(TransDate, Key)

Left Join(Fact)

LOAD From, To, Key Resident Dimension;

This will add Key, From and To to your Fact table (null if the key and/or dates do not match)