Abstract: A methods and apparatuses for creating a federated multidimensional business planning model may comprise: creating, via a computing device, a first multidimensional business planning model; creating, via a computing device, a second multidimensional business planning model; integrating, via a computing device, the first multidimensional business planning model with the second multidimensional business planning model, wherein the integrating comprises mapping, via a computing device, dimensions of the first multidimensional business planning model to the second multidimensional business planning model, utilizing user input through a model map spreadsheet worksheet defining, via a computing device, at least one source dimension in the first multidimensional business planning model corresponding with at least one target dimension in the second multidimensional business planning model.

Abstract: A computing module and method for corporate performance management (CPM) is disclosed. A spreadsheet is determined for inclusion in a CPM software application. Dimensional members associated with the spreadsheet are captured, and hierarchies associated with the spreadsheet based on the captured dimensional members and formulas in the spreadsheet are determined. A spreadsheet template associated with the spreadsheet is determined and data from the spreadsheet is obtained. The spreadsheet template, dimensional members, hierarchies, and data are then published into the CPM software application.