Two relations between two tables

Fri, 09 Apr 2010 09:23:17 GMT

Hi,

I have the table Department and a Fact table. The Fact table has two foreign keys END_DEP and START_DEP to the Department's primary key.

To map them in QlikView I created two more columns of the DEP_KEY in the Department dimension, which have the same name as the ones in the Fact table. In QlikView I have:

SQL SELECT "DEP_KEY",
"DEP_KEY" AS "START_DEP",
"DEP_KEY" AS "END_DEP",
"DEP_NAME"
FROM NEWKIRK.DEPARTMENT;

SQL SELECT DAYS,
"END_DEP",
"START_DEP",
STATUS
FROM NEWKIRK.FACT;

It creates synthetic keys, but I don't know if that is really what I want. I want two different relations from the Fact to the Department table.

Any ideas?

Two relations between two tables

vidyut — Fri, 09 Apr 2010 11:53:09 GMT

Keep two Tables, One for Start_Dep, and one for End_Dep.

if the Department has just the Dep_Key and Name, Do a join and bring Name into the Fact as Start_Dep_Name and End_Dep_Name

topic Two relations between two tables in QlikView

Two relations between two tables

Two relations between two tables