topic syntheic key issue in QlikView

syntheic key issue

Tue, 21 Feb 2012 06:08:43 GMT

can any one help me to genrate script for link table to resolve the issue in the attatched file.

i have two dimension partno and stockist and two fact purchase and recipt.

how to genrate the script for link table while my dimension and fact is loading from qvd how to tackel residence command.

syntheic key issue

CELAMBARASAN — Tue, 21 Feb 2012 06:41:13 GMT

Hi,

I cann't open your file because of personal edition user.

I assume that your problem is synthetic key.

To eliminate synthetic key Join the 2 fields and make that as key bet 2 tables.

Then use qualify for that 2 fields.

For example

qualify product,billno;

Table1:

Load

product & billno as Key,

product,

billno

From..

Table2:

Load

product & billno as Key,

product,

billno

From..

Celambarasan

syntheic key issue

jagan — Tue, 21 Feb 2012 07:52:05 GMT

Hi,

Just paste the script or attach the screenshot of the mapping diagram, it helps in understanding the problem.

Regards,

Jagan.

Re: syntheic key issue

Tue, 21 Feb 2012 08:16:49 GMT

See the attached file. You have to reload it first. Think it should work like this.

Best regards,

William

syntheic key issue

Tue, 28 Feb 2012 09:28:09 GMT

absulutly perfect William..

thnks alot.

Re: syntheic key issue

Tue, 03 Jul 2012 05:46:54 GMT

wht if i have

three same column but one filed is differnet say:

1st cube:

employee_id

location

item

supplier_id

purchase_Cost

2nd cube:

employee_id

location

item

customer_id

sold_Cost

how to manage this.............

Re: syntheic key issue

CELAMBARASAN — Thu, 12 Jul 2012 19:40:42 GMT

If my understanding is correct then both the tables meaning is different

1st is about purchase

2nd is about sold then u can ve it has separate

1st cube:

employee_id

location AS PurchaseLoc

item AS PurchaseItm

supplier_id

purchase_Cost

2nd cube:

employee_id

location AS SaleLoc

item AS SaleItm

customer_id

sold_Cost

If i'm wrong let me know

Celambarasan