topic Re: How to do simple Slowly Changing Dimension? in QlikView

How to do simple Slowly Changing Dimension?

Tue, 19 Mar 2013 07:36:14 GMT

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 Description	Agreed Cover
A	Apple	3
B	Blackberry	2
C	Chico	3

And as of 6/4/2012

Item No.	Item Description	Agreed Cover
A	Apple	2.5
B	Blackberry	2
C	Chico	3

As of 8/1/2012

Item No.	Item Description	Agreed Cover
A	Apple	3
B	Blackberry	2.6
C	Chico	2

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

Re: How to do simple Slowly Changing Dimension?

kaushiknsolanki — Tue, 19 Mar 2013 07:52:20 GMT

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

Re: How to do simple Slowly Changing Dimension?

Tue, 19 Mar 2013 07:56:45 GMT

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?

kaushiknsolanki — Tue, 19 Mar 2013 08:00:46 GMT

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

Re: How to do simple Slowly Changing Dimension?

Tue, 19 Mar 2013 08:07:55 GMT

How to do incremental load logic?

Re: How to do simple Slowly Changing Dimension?

kaushiknsolanki — Tue, 19 Mar 2013 08:12:04 GMT

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