Case is like this: I have (actually two big fact tables)
Map table for location names
Problem is: How to match statistical data to fact table by date and location although statistical table has more location than fact table. And connect it all to location map to analyze facts by time and location and statisitcs by time and location.
I attach xls and qvf files.
sum of Stat_value should be same for each month obiously and has value ot only for months and location existing in fact table but for all months and locations existing in stat table.
Hope I explained it enough to solve it for some pro.