Global DataWarehousing Model
My client wants a Global Data Warehouse(Americas,Europe,Asia etc). with the capability of reporting at the global level and drilling down to the regional and sub-regional levels.
What would be the advantages and disadvantages of the following two approaches:
1.Approach 1:Build the warehouse with one InfoArea, One InfoCube etc. per area with all the users from Europe,Asia and America accessing a single InfoCube.
2.Approach 2:Build separate Infoarea for Europe,Asia and America with users accessing the reports at their regional level and create a multiprovider for users who want to access the global reports.
Any insight and experience would be helpful.
Thanks in advance.