Multi-dimensional data bases

What are your views on Multidimensional databases? Can't we consider relational DBs as a special instance of MDDs. If so, is there a way in which we van determine the optimum number of dimensions for a given data set? Wouldn't this concept really be nifty if we had at-least 3-D physical memory?