I have an olap cube with a table which contains the geographical information of France (areas, departments...) and represents the dimension 'Geography'.
This table is connected to the facts table thanks to an identifier.
The problem is that my dimension geography contains only the cities whose identifier are in the facts table , the others are not present but I need these infos.
Any ideas?