Virtual tables and not enough memory

[mrothschild]

Is there a more efficient way to program the following?  I'm getting error messages about not enough memory.

Table = 

VAR N = 100
VAR _Parent_Table = 
    ADDCOLUMNS (
        GENERATE(
            GENERATE(
                SELECTCOLUMNS ( GENERATESERIES ( 0, N , 1), "Equities", [Value] ),
                SELECTCOLUMNS ( GENERATESERIES ( 0, [Equities] , 1 ), "Public", [Value] )  
                ),             
            SELECTCOLUMNS( GENERATESERIES( 0, [Equities], 1 ) , "Private", [Value] )
        )
        ,
        "% Equity - Total",  [Equities] / N ,
            "% Equity - Public",  [Public] / N,  
            "% Equity - Private",  [Private] / N
    )

VAR _Child_Public_Table = 
    ADDCOLUMNS (
        GENERATE(
                     GENERATE(
                        _Parent_Table,
                        SELECTCOLUMNS( GENERATESERIES( 0, [Public], 1 ) , "S&P500", [Value] )
                    ),
                    SELECTCOLUMNS( GENERATESERIES( 0, [Public], 1 ) , "MSCI World", [Value] )
                )
        
        ,
        
            "% Equity - Public - S&P500",  [S&P500] / N,  
            "% Equity - Public - MSCI World",  [MSCI World] / N
 

    )

VAR _Child_Private_Table = 
    ADDCOLUMNS (
        GENERATE(
                     GENERATE(
                        _Child_Public_Table,
                        SELECTCOLUMNS( GENERATESERIES( 0, [Private], 1 ) , "Cambridge", [Value] )
                    ),
                    SELECTCOLUMNS( GENERATESERIES( 0, [Private], 1 ) , "TRPIEX", [Value] )
                )
        
        ,
        
            "% Equity - Private - Cambridge PE",  [Cambridge] / N,  
            "% Equity - Private - TRPIEX",  [TRPIEX] / N
 

    )

RETURN
_Child_Private_Table

The intended output is a new calculated table with 14 columns:

% Equity - Private

% Equity - Private - Cambridge PE

% Equity - Private - TRPIEX

% Equity - Public

% Equity - Public - MSCI World

% Equity - Public - S&P500

% Equity - Total 

Equities

Cambridge

MSCI World

Private

Public

S&P500

TRPIEX

[lbendlin]

Not sure what you expect - you are raising 100 to the power of 7 (roughly, since you have some shorter runs).  That means  you ask to generate 100 trillion rows. Even one trillion rows would still be too much.

What's the goal behind this exercise?