The current mechanism discloses methods for transforming a set of heterogeneous relations into multidimensional data cubes. A syntheses process is disclosed that dynamically and with minimal user input eliminates ambiguities in a populated hypercube. Including, ambiguities reflecting dependencies between dimensions in the hypercube as well as reflecting the need for supporting points in the cube with realistic observations. The hypercubes also support complex dimension structures, complex operations and hierarchies that are not necessary regular or of aggregation type. The methods are generic and applicable to any data warehouse design. The methods enable relational OLAP for a wider variety of data and structures than possible using current relational implementation schemas.