Investigate and devise a data integration solution in order to generate a certain management report. Analyze and make suitable assumptions for the transaction database (OLTP) in the selected organization which holds several tables. Choose two of these in order to consolidate data into the desired management report. Populate these tables by assuming/generating the necessary data in high orders (preferably thousands of rows). Each table must have at least 10 columns each and comprise of data types composed of integer, date, varchar2, etc. Create and use a new OLAP database instead. You are required to design and develop a data warehousing solution to integrate data from OLTP system so as to generate the desired management report.