Start with computationally tractable:
Suppose we have M dimensions with N values for each dimesion. Assume all values used.
So full entries are: MN
Suppose we aggregate over 1 dimension we get MN−1 values and we can do this for N different dimensions yielding:
NMN−1
Next one we will N choose 2 (columns to aggregate over) times MN−2
Repeating we see that total number of aggregates is:
Total=∑i=1NCiNMN−i
Now let us assume that N = M, then:
Total=i=1...N∑CiNNN−i=i=1...N∑i!(N−i)!N!NN−i
Total≤i=1...N∑i!NiNN−i=i=1...N∑i!NN=NNi=1...N∑i!1
And finally:
Total≤NNi=0...N−1∑2i1≤2NN=2x Number of original entries
Seems likely that we can do worse than this in real world cases. Would be nice to get an upper bound …