You should be able to extract the cube data to Excel, and use the Excel file as source for your table. An SSIS package can be developed to import the data.
That being said, you're just putting a band-aid on the real problem of not storing your historical data in the first place.
Hi, Excel goes to 1 million records, I'm around 1.5+B rows. Thanks