Data explosion in quantity and diversified sources of data in variety pose certain problems in data storage on heterogeneous repositories for online analytical processing (OLAP). Over the years, Extensible Markup Language (XML) is emerged as a standard language for integrating and exchanging structural and semi-structured data from heterogeneous and miscellaneous data sources. In this paper we presented a multi-layered model for resolving the complexity of heterogeneous resources as well as multi formatted data. Specifically, the model amalgamates data from an assortment of resources by using XML and transforms them in to data cubes namely X-cubes. Likewise, XML is incorporated into OLAP for generating multidimensional cube called XOLAP. To support this new data cubes, a query translator as a user interface is implemented. A significant contribution of this model is that it facilitates gathering data from heterogeneous data sources and provides a unified format for handling OLAP queries in order to construct multidimensional cubes. © 2009 IEEE.