Synthetic Key Question - on Month & Region field which i'm using as filters
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.