Regarding IntervalMatch function for slowly changing dimensions

Tue, 24 Jun 2014 03:13:55 GMT

Hello Friends,

Kindly let me know the solutions for the interval match issue below. Actually I have 4 tables,

SalesOrderHeader:

SQL SELECT

OrderDate,

TerritoryID,

SalesOrderID

FROM SalesOrderHeader;

SalesTerritoryHistory:

SQL SELECT BusinessEntityID as EmployeeBusinessEntityID,

EndDate,

StartDate,

TerritoryID

FROM SalesTerritoryHistory;

Employee:

SQL SELECT

EmployeeBusinessEntityID,

EndDate as Employee_EndDate,

FirstName,

StartDate as Employee_StartDate

FROM Employee;

SalesOrderDetail:--This is my transaction table

SQL SELECT

OrderQty,

ProductID,

SalesOrderDetailID,

SalesOrderID,

UnitPrice,

UnitPriceDiscount

FROM SalesOrderDetail;

I tried creating interval match function to link the Orderdate in SalesOrderHeader with intervals in SalesTerritoryHistory but it is not working as expected, I need to show the Sales metrics of employees, kindly let me know your solutions.I have attached the datamodel for your reference.

Thanks so much!

Best,

Kiru

Re: Regarding IntervalMatch function for slowly changing dimensions

Tue, 24 Jun 2014 03:45:23 GMT

Hi,

Please check the article that HIC wrote about this.

IntervalMatch and Slowly Changing Dimensions

Cheers

Prasan

topic Regarding IntervalMatch function for slowly changing dimensions in QlikView

Regarding IntervalMatch function for slowly changing dimensions

Re: Regarding IntervalMatch function for slowly changing dimensions