Slowing changing dimension without using IntervalMatch

    Hi,

     

    Hope below code helps community friends in achieving the slowly changing dimensions without the use of IntervalMatch().  I have a Transaction table with Week and Value fields and I have another table which holds the Rank of a Value in a particular week.  To implement this without using IntervalMatch() we can use below code.

     

    TransactionTable:

    Load * Inline [

    Week ,Value

    10 ,1

    10 ,2

    10 ,3

    10 ,4

    11 ,1

    11 ,2

    11 ,3

    11 ,4

    ];

     

    LEFT JOIN(TransactionTable)

    LOAD

    Week,

    Rank,

    Desc,

    Start + Iterno() -1 AS Value

    WHILE Start + Iterno() -1 < End;

    Load *

    Inline [

    Week ,Start ,End ,Rank ,Desc

    10 ,0 ,2 ,1 ,0-2

    10 ,2 ,3 ,2 ,2-3

    10 ,3 ,6 ,3 ,3-6

    10 ,6 ,8 ,4 ,6-8

    11 ,0 ,3 ,1 ,0-3

    11 ,3 ,4 ,2 ,3-4

    11 ,4 ,7 ,3 ,4-7

    11 ,7 ,8 ,4 ,7-8

    ];

     

    Regards,

    Jagan.