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
Well now that would've been great information to have at the start, but in any event you can surely limit the data to fit into an Excel workbook...or us multiple workbooks etc.