topic Re: How to remove slowing changing dimension in QlikView

How to remove slowing changing dimension

muhammadraza — Tue, 06 Jan 2015 09:18:20 GMT

Hi Guys,

I have a slowly changing dimension table as you can see, I want to remove this table want to make it a single table joined with sales table (so that I have a direct connection between employees and Sales table)

I have seen different techniques but I am not able to get how it will fit in my scenario.

PFA is my document and QVD files.

Regards,

Raza

Re: How to remove slowing changing dimension

Anonymous — Tue, 06 Jan 2015 09:41:01 GMT

Left join the SalesTerritoryHistory table & Territory table to Sales Table

now u can see only 2 table

1.Employess 2.Sales

both the tables are linked with EmployeeID Field

Re: How to remove slowing changing dimension

tyagishaila — Tue, 06 Jan 2015 11:12:08 GMT

To connect employee and sales table there must be a common field to associate tables..

Rename EmployeeID in SalesTeritoryHistory Table

Re: How to remove slowing changing dimension

marcus_malinow — Tue, 06 Jan 2015 11:29:46 GMT

Muhammad,

see the attached.

Looks like you were close, intervalmatch looks like the correct way to go here, but with a few changes from what you were doing.

Marcus