I was at a client and needed to make a copy of their 50 gig production cube onto their test system to do some work with it. I exported the data, copied the outline over to test and re-imported the data. I looked at the file system during the load to see how far along and was surprise when the cube stopped loading the .Dat file was only 9 gig. I ran the materialization of aggregations using a saved aggregation from query tracking and the cube grew to 25 gig. About half of the size of the production cube.
There are a couple of things to know.
- During the year, the client deletes some data out of the cube by deleting the members (old years)
- The cube contains no slices
- The cube gets an incremental update multiple times a month by clearing out the current Month/Year and reloading the data
- The cube has been in production for about a year and the outline gets new members added on a regular basis.