When you build a table from an extract (*.ivx) sometimes you may experience an "Out of memory" error. This happens because tables from extracts are built completely in memory so that these tables build fast.


Extracts are intended for fast ad hoc analysis, not for general cube building. Consequently they are designed for speed, not for large tables. In most cases, small cubes can be constructed to answer your questions in seconds. The utility of large cubes becomes more limited as the size of the tables and the number of dimensions increase in size and the data in the cubes becomes very sparse.


For an approximation of how much RAM is needed multiply the number of items in all dimensions together and then multiply that by 16. This will tell you approximately how much memory is needed to build the table from the extract. 


If this number is over 1.5 Gb then adding more RAM to the computer will not help. The Beyond 20/20 Browser is a 32-bit application and has a workspace memory limit of 1.5-2 Gb and cannot build tables that require more memory than this. 

To build the table you will need to make the table smaller.


Note: Even if the number falls below this limit, there may be other factors that affect the available memory which will result in Memory Errors.