eXtensible Markup Language (XML) is data exchange format for representation data in Web based system. XML is used by many organizations for e-commerce and internet based applications such as online shopping, digital library, and electronic devices and so on. XML data is not sufficient to analyze on the Web. So XML is required to systematically analyze by industrial organizations to enable enhanced decision making. On the other hand, Data Warehouses are used by the most of the organizations for analyzing large data on their business. Conversion of XML schema and Data Warehouse schema has emerged as a continuous research area. This paper proposes a hierarchical design framework conversion of XML schema into the various Data Warehouse schema based on ROLAP. In this paper, we describe an automatic approach to support this conversion process. Our approach is based on the source of data that are XML schema and conforming XML document for designing Data Warehouse. We define more than one Data Warehouse schemas from the given XML schema using the Schema Graph has been proposed in the conversion process.