Hello, with my question, I'm looking for a way to extract a block of historical data from a cube to a table, and this is an idea i want to know is feasible.
I have two very large cubes, one hold subs data back 13 months, it loads daily, and is a 2014 formatted Tabular cube, and all of it's data is stored in one month data partitions. Same story for a Revenue tab cube formatted in 2014 living in a 2016 formatted instance with 38 months, each month in a data partition.
Can I navigae to the cube in the SSAS instance, right click it, go to Browse, and write or design a query that can extract out certain columns across a year or multiple years of data and pipe that out to a table in a database?
The issue, for either of the cubes, I take in one or two months at a time to a trunc and load table, where it then gets processed into the appropriate data partition of the cube. So I do not have a table of historical data, the cube hold the historical data in an aggregated format. I need that historical data in table format (or flat file maybe) so a sister team can make use of it to stop back hauling the same several years of data every other day and hammering the system so.
I'm open to any and all ideas to efficiently accomplish this task.