topic Re: Synthetic Key Problem in QlikView

Synthetic Key Problem

Fri, 10 May 2013 11:53:06 GMT

Hi All,

We are facing problem in removing synthetic key from our datamodel.

I am attaching snapshot of it.

Kindly help to resolve the problem.

Thanx

Gauraw

Re: Synthetic Key Problem

narender123 — Fri, 10 May 2013 12:00:49 GMT

Hi,

Isvn_Account_Rx_Mthly_Fact

%Issp_Sales_Hoerarchy_Id,

%Isvn_Account_Dim_Id as Key,

\\means make one column name alias

Thanks.

Re: Synthetic Key Problem

Fri, 10 May 2013 12:27:00 GMT

Hi Narender ........ Thanx for Response..........

We renamed %Isvn_Account_Dim_Id to %Isvn_Account_Dim_Id1 but the numbers in two fact tables are not matching. Both the fact tables numbers match when synthetic key is there in the datamodel.

Is there any other way to remove it?

Thanx

Gauraw

Re: Synthetic Key Problem

calvindk — Fri, 10 May 2013 12:33:04 GMT

Qualify *;

Unqualify FieldLink, SameFieldLinkDifferentName;

Load

*, FieldLink, SameFieldLinkDifferentName

from Dim;

Load

*, FieldLink

from fact;

Load

*, SameFieldLinkDifferentName

from aggrfact;

Re: Synthetic Key Problem

narender123 — Fri, 10 May 2013 12:40:50 GMT

Hi,

You can also make them syntatic key

%Issp_Sales_Hoerarchy_Id & '-' & %Isvn_Account_Dim_Id as Key,

.With this key can either repeat %Issp_Sales_Hoerarchy_Id or %Isvn_Account_Dim_Id this column means only one column in 1 table according to situation of join.

Table1:

%Issp_Sales_Hoerarchy_Id,

%Issp_Sales_Hoerarchy_Id & '-' & %Isvn_Account_Dim_Id as Key,

Note:dont use %Isvn_Account_Dim_Id as Key in Table1 .

Thanks.