The present invention automatically generates a dimensional model from an object model. The relationships in the object model are used to infer foreign key relationships in the dimensional model.