Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

How to do simple Slowly Changing Dimension?

Hi,

In my client, it was being requested to the slowly changing dimension, because they will only updathe the excel file once there's a change to any of the records, specifically to its numeric value.

Say for example:

As of 4/1/2012

Item No.Item DescriptionAgreed Cover
AApple3
BBlackberry2
CChico3

And as of 6/4/2012

Item No.Item DescriptionAgreed Cover
AApple2.5
BBlackberry2
CChico3

As of 8/1/2012

Item No.Item DescriptionAgreed Cover
AApple3
BBlackberry2.6
CChico2

Note that, this is only one file (excel file)... And excel file will only be overwritten once there's change.

Please help me on this. Your help is much appreciated.

Thanks,

Bill

5 Replies

Re: How to do simple Slowly Changing Dimension?

Dear Bill,

     What do you want to achieve.

     Do you want to keep the old data with new changed records?

     Or you want to only keep new records?

Regards,

Kaushik Solanki

Not applicable

Re: How to do simple Slowly Changing Dimension?

Hi Kaushik,

There will be traces, when did the data change its value. So the old must be keep so that I may have historical data.

Thanks,

Bill

Re: How to do simple Slowly Changing Dimension?

Hi,

     See one way is you put the Update Date as one of the column, which will be updated once the data is updated.

     and then you can use the incremental load logic to get only the changed records.

Regards,

Kaushik Solanki

Not applicable

Re: How to do simple Slowly Changing Dimension?

How to do incremental load logic?

Re: How to do simple Slowly Changing Dimension?

Hi,

     Incremental logic means, you load only those data or records which are updated.

     Have a look at the link below for more info on Incremental logic.

     http://community.qlik.com/docs/DOC-1870

Regards,

Kaushik Solanki    

Community Browser