Patent ID: 7302421

Claim:
A method comprising: identifying a plurality of unstructured electronic data sources; mapping a plurality of undefined data elements from each data source to an OLAP cube based upon at least one user-defined dimension of the plurality of data elements identified from at least one of the data sources; wherein the mapping step includes: creating at least one level for each 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; adding a second set of values selected from the data source to the at least one measure, wherein each value in the second set is associated with at least one value selected from the first set; and specifying at least one rule that is applied to the data elements to generate the OLAP cube; transforming the OLAP 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.