synthetic key issue

Thu, 11 Apr 2013 06:44:20 GMT

AOA

I have loading qlikview from datawarehouse....

which has 4 fact table

1) ITEM PURCHASE

2) ITEM CURRENT_ISSUANCE

3) ITEM ISSUANCE_HISTORY

4) ITEM RETURN_HISTORY

5) ITEM IN STOCK

ITEM PURCHASE;

LOAD

SUPPLIER_ID

TIME_ID,

PART_NO,

PURCHASE_TYPE_ID,

STOCKIST_ID,

PURCHASED_QTY

PURCHASED_COST

FROM

(QVD);

ITEM CURRENT ISSUANCE;

LOAD

DIVISION_CODE,

EMPLOYEE_ID,

TIME_ID, //TIME ID Has no impact because its current issuance. we can delete time_id from here"

PART_NO,

STOCKIST_ID,

CURRENT_ISSUE_QTY

FROM

(QVD);

ITEM ISSUANCE_HISTORY;

LOAD

DIVISION_CODE,

EMPLOYEE_ID,

TIME_ID,

PART_NO,

STOCKIST_ID,

ISSUE_QTY

FROM

(QVD);

ITEM_RETURN_HISTORY;

LOAD

DIVISION_CODE,

EMPLOYEE_ID,

TIME_ID,

PART_NO,

STOCKIST_ID,

RETURN_QTY

FROM

(QVD);

ITEM IN STOCK;

load

LOCATION_ID

PART_NO,

STOCKIST_ID,

STORE_ID,

INSTOCK_QTY

FROM

(QVD);

when i show data in stright/pivot table on pushase sheet its show correct figures mean no issue with ITEM PURCHASE.

but on issue and stock sheet only those data is displaying which is availble in these 3 table. ITEM ISSUANCE_HISTORY, ITEM RETURN_HISTORY

and ITEM IN STOCK

note: when i comment these two laoding TABLES and reload then correct data show in stock sheet

ITEM ISSUANCE_HISTORY

ITEM RETURN_HISTORY

any advice???

(e.g suppose

I have purchased"computers" so as per our records for ITEM PURCHASE is

partno of computer is 111111

stock who order computer is"IT STOCK"

purchasing type is "ORDER"

purchase on time_id is 599

purchase from supplier_id is 45

purchase_qty is 10 unit

purchase_cost is 100000 unit

ITEM CURRENT_ISSUANCE

issue to wich division is "IT"

partno of computer is 111111

stock who order computer is"IT STOCK"

current item issue to employee_id "6123"

current issued qty to that employee is "2"

ITEM ISSUANCE HISTORY

issue to wich division is "IT"

partno of computer is 111111

time in which computer issued "600"

stock who order computer is"IT STOCK"

employee_id to whom computer issue is "6123"

item issue so far is ISSUE_QTY="3"

ITEM RETURN HISTORY

recived from to wich division is "IT"

partno of computer is 111111

time in which computer returm "605"

stock who order computer is"IT STOCK"

employee_id to whom computer issue is "6123"

item issue so far is RETURN_QTY="1"

ITEM IN STOCK

item is at location"a"

stock having item in sotck is "IT STOCK"

store under sotck is "IT HARDWARE"

partno is 111111

qty present in stock is 8

as u can se record present in 3 of above table so it will display record in stock sheet.....

if let say employee has not return any item yet so no record availbe in ITEM RETURN HISTORY

so no record also found in stock sheet)

hope u understnd the senerio

topic synthetic key issue in QlikView

synthetic key issue