Abstract: A computer system and method is disclosed that transforms data for use in other applications. Several client workstations and servers are coupled together over a network. A client computer contains a user interface for performing the mapping and transformation. Data elements are mapped from a data source to a multi-dimensional cube. The multi-dimensional cube is transformed into a test recordset to determine if the data elements are mapped correctly. The mapping information is saved to a template. A server includes business logic for using the saved template to create a final recordset from the data source using the template. The server sends at least part of the recordset to a browser user interface on a client computer for display.

Abstract: A computer system and method is disclosed that transforms data for use in other applications. Several client workstations and servers are coupled together over a network. A client computer contains a user interface for performing the mapping and transformation. Data elements are mapped from a data source to a multi-dimensional cube. The multi-dimensional cube is transformed into a test recordset to determine if the data elements are mapped correctly. The mapping information is saved to a template. A server includes business logic for using the saved template to create a final recordset from the data source using the template. The server sends at least part of the recordset to a browser user interface on a client computer for display.