topic Synthetic Key Question - on Month & Region field which i'm using as filters in App Development

Synthetic Key Question - on Month & Region field which i'm using as filters

nandhaadjame200 — Sat, 16 Nov 2024 06:54:00 GMT

Hi There

Synthetic Key Question - on Month & Region field which i'm using as filters:

I'm having multiple tables with same set of fields which is really required for filters. If i rename or concatenate those fields, then i will not have separate fields for filter's. Also those filters were common for all dashboards which i created.

Also I've attached my Data Model screenshot for reference.

Please check and advise if can continue with those synthetic keys or i should really worry about my data model.

Thanks

Nandhakumar

Re: Synthetic Key Question - on Month & Region field which i'm using as filters

jyothish8807 — Wed, 09 Jan 2019 06:16:46 GMT

Hi Nandha,

Try like this:

Make a new key "Month &'|'& Region" in all the tables which have month and Region field and drop this filed from all the tables except the one which have all the month and region data (Master Table).

Table A:

Load

Month,

Region,

Month &'|'& Region as %Key

from Table A;

Load

//Month,

//Region,

Month &'|'& Region as %Key

from Table B;

Do this for other tables as well. It will help in eliminating the synthetic keys and result in star schema.

Hope it helps.

Re: Synthetic Key Question - on Month & Region field which i'm using as filters

nandhaadjame200 — Mon, 28 Jan 2019 06:35:53 GMT

HiJyothish

Apologies for the delayed response.

Actually, your solution worked for me. Thanks a lot.

Thanks

Nandhakumar