I have number of facts and dimensions that would be part of my model and have the dimension fact matrix. Is it possible to approximate the number of cubes that would be built
eh?
you could put all your facts dimensions in one cube if coming from the same schema
performance (build time etc.) will be determined by many different parameters, the number of records on the DB being one