Hello, my company has business in many countries, each of them have their own BI system, now, I want to setup a global BI system in our headquarter.
eg. to setup a global Sales cube, it should contain both the information of Country A and Country B Sales cubes.
Of course, I can duplicate another set of information from both countries and then create a new cube : Global Sales cube.
Other than it, are there any efficient or smart methods to handle my case ?