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

[nandhaadjame200]

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

[jyothish8807 · Accepted solution]

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;

B:

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.

[nandhaadjame200]

HiJyothish

Apologies for the delayed response.

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

Thanks

Nandhakumar