Synthetic Keys

[MK_QSL]

Can someone help me to remove synthetic keys in attached application?

I have enclosed both Data file and QVW.

I don't want to use Qualify or Rename any field, as it will not fulfill my purpose as data need to be as it is.

[Gysbert_Wassenaar · Accepted solution]

Personally I would rename some fields. But if you think you know best you can try forcefully concatenating the fact tables and duplicate the supplier fields with an alternative name. The result looks like

See attached qvw for the script.

Edit: if Part Number is supposed to be the same as Item then this model is wrong too. You will have to rename fields or suffer the consequences, i.e. duplicate counts/sums etc. Or your original synthetic key.

[MK_QSL]

Thanks for your reply. Let me clarify my needs so that you can suggest me better answer if is there any possible.

In my project, I have been asked to create a table which will give me Total QTY sold, Total QTY lost sale and TOTAL QTY in Inventory (i.e.TOTAL Stock) for Product Group and Supplier ID (Prime Supplier) as Dimension......

Let me know if is there any better solution...

Thanks in advance for your help....