Patent ID: 7599909

Claim:
A method comprising: identifying an unstructured data source; receiving from the user at least one user-defined data dimension indicated by a plurality of data elements within the unstructured data source; mapping a plurality of data elements from the data source to a multi-dimensional cube based upon said at least one user-defined dimension, wherein the mapping step includes: creating at least one level for a user-defined dimension; adding a first set of values to a selected one of the at least one level for each user-defined dimension; creating at least one measure representing a type of data within the at least one data source; and adding a second set of values selected from the data source to the at least one measure; wherein at least one value in the second set is associated with at least one value selected from the first set; transforming the multi-dimensional cube into a test recordset to determine if the plurality of data elements are mapped correctly; saving the mapping information to a template; and generating a final recordset from the data source using the template.