Remove Synthetic Keys

stevejones1 — Fri, 23 Jun 2017 20:13:18 GMT

Someone help me in removing synthetic keys from this datamodel

Thanks!

Re: Remove Synthetic Keys

prat1507 — Sat, 24 Jun 2017 06:08:43 GMT

Hi Steve

Can you please give a brief description as to what you want exactly, and how must the data be linked to each other?

Regards
Pratyush

Re: Remove Synthetic Keys

ahaahaaha — Sat, 24 Jun 2017 07:01:46 GMT

Hi,

If I understand correctly, it is about analyzing planning and factual recruitment employee. It is difficult to express an opinion without knowing the goals and objectives of the analysis, but nevertheless I would do the following.

1) When loading tables 'Forecast' and 'Expenses', I would combine them into one by adding a flag field (for example, the value of field 0 if the entry is from table 'Forecast' and the value of field 1, if the entry is from table 'Expenses'). This will get rid of part of the synthetic key: [Level 0]-[Level 7].

2) It probably does not make sense to generate the field [Supplier] when loading tables 'Employee' and 'Forecast' . These data can be taken from the table 'Expenses' in the analysis. This will get rid of part of the synthetic key: [Supplier].

3) As I understood from the data, the qualification code is field GROUP_CD. Here everything depends on the analysis tasks. Here, either the [Date] and [GROUP_CD] fields are may be combined into a manual synthetic key, or leave the [GROUP_CD] field as is, but generate canonical dates from fields [Date] of tables 'Expenses', 'Employee' and 'Forecast'. About the canonical dates you can read here Canonical Date

These considerations are only based on the analysis of your code.

Regards,

Andrey

topic Re: Remove Synthetic Keys in QlikView

Remove Synthetic Keys

Re: Remove Synthetic Keys

Re: Remove Synthetic Keys