In today's highly competitive business, data became strategic resources. Business companies dealing with a huge and growing amounts of data in different database formats. Whether these companies need to understand the effectiveness of their marketing efforts and quickly maintain the large volumes of data created each day. These challenges require a well-defined database system and data warehouse that can bring together disparate data with different dimensionality and granularity. This paper is to design distributed data warehouse based on relational OLAP with materialize views for the purposes of analysis.