Consolidating Multiple Database Outlines
Summary
Consolidating Multiple Database OutlinesContent
Summary: I currently have 3 ASO cubes that house 4,000,000 individual sales transactions per cube. The cubes are segregated by our fiscal year (FY16, FY17, FY18). Each transaction has a unique identifier and the dimensions are exactly the same in all 3 cubes. The only varying member is the transaction # and the various attributes.
Issue: I'm trying to merge all of the data into one singular cube; however, the outline grew too large and the cube became unusable.
Question: Is there a way (through partitions or other various methods) to have all 3 cubes link to one singular target cube? The main issue would be outline size as I can't combine the three cubes into one because of the size of the combined data. The solution would have to be something that appears to the user that all three cubes are in one singular cube.