1. A method for the calculation and back-solving of complex relationships in a sub-cube of a multidimensional database system comprising the steps of: inputting from a user the required values of specified cells and any constraints; creating one or more parent/child tables giving the relationships and dependencies between target cells and other cells in the sub-cube; determining from the one or more parent/child tables the one or more target cells requiring one or more calculations to be performed; for each target cell requiring calculations: performing the one or more calculations and recording that a change has taken place; remembering the one or more parent cells of the target cell to ensure they are recalculated; recalculating the values for each remembered parent cell and recording that a change has taken place; repeating the performing, remembering, and recalculating steps until all changes to the target cells and their parent cells are complete; repeating the performing, remembering, recalculating, and first repeating steps until no changes are recorded; and reporting the results of the foregoing steps to the user.