I am looking for some help and a possible solution to a problem I have encountered when linking Qlickview to our internal support system.
The main Fact table (Support_Hd) holds a number of fields which just contain internal references (values) which are populated during the entry or update to a log, the internal references are obtained from a Lookup table and the description for these values are also held within the lookup table.
Table 1 (Support_Hd)
Log_Ref (Primary Key)
Log_Stat (Log Status) (Int Ref Value - Decode_ref)
Cont_Meth (Contact Method) (Int Ref Value - Decode_ref)
Prod_lkp (Product Lookup) (Int Ref Value - Decode_ref)
Dept_lkp (Department Lookup) (Int Ref Value - Decode_ref)
Table 2 (Lookup)
Decode_ref (Int Ref Value)
I am currently having to link the Lookup Table (Table 2) to the Support_Hd Table (Table 1) 4x times to allow me to lookup against the mulitple fields
otherwise the model generate Synthetic Keys.
// Load Support_Hd Table
'Log_Stat' AS LKP_Link1,
'Cont_meth' AS LKP_Link2,
'Prod_lkp' AS LKP_Link3,
'Dept_lkp' AS LKP_Link4
SQL Select *
// Load Lookup Table (1st Loop)
'decode_ref' AS LKP_Link1,
SQL Select *
Repeat 4 times for each lookup which makes the Model very messy and I am not sure it helps with the optimisation of the QVW.
I have attempted to use a Mapping Load but this fails because the two comparison fields are not the same even though they contain the same values.