The formation of the overall structure starts by building a DW at only location of top most level of hierarchal structure. Presently, this DW acts as a centralized DW and stores all the records (i.e. data local to all the location and overall data related to Common table) related to all the levels until any other DW is formed at some other location of any other level. Any DW in the structure stores three types of data: first, is the data that uniquely identify the user in the system; second is the data local to the location; and third is the Meta data. A Common table is used in each DW for storing first type of data while the Other tables are used for storing second type of data. The Common table is also used for the incorporation of any new DW build at some other location of the structure arranged in star schema in each DW. It does so by transferring of the data (records) in the Common table of newly build DW from the DW available at next higher level in its hierarchy. The content of Common table is made so in such a way so it is able to perform all the desired tasks.