Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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)