Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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.

Former Member

Helpful Answer

Not what you were looking for? View more on this topic or Ask a question