Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have an issue,
I have several big tables that can't be concatenated (because they are too big):
Table1
RegionA
YearA
MonthA
DimA
DimB
DimC
Table2
RegionB
YearB
MonthB
DimD
DimE
DimF
I want to create a common filter to be able to select the region, the year, the month for both of the tables.
If I use a Third table (inline) like this to create a link between the tables it works:
MasterFilterYear:
MasterYear, YearA, YearB
2015, 2015, 2015
2016, 2016, 2016
But if I do an other one for Region it creates a loop in the structure:
MasterFilterRegion:
MasterRegion, RegionA, RegionB
Asia, Asia, Asia,
America, America, America
Can you help me to create this "Master Filter" please ? Thanks
I just made an outer join between my main filter tables:
MasterFilterYear
MasterFilterRegion
MasterFilterMonth
It works. But is it a good practice ?