Skip to Content
Former Member
Apr 06, 2006 at 03:16 PM

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.