Patent ID: 7720803

Claim:
An article comprising one or more machine-readable media storing instructions operable to cause one or more machines to perform operations comprising: receiving a transactional data model and a view that comprises a plurality of view fields, each view field referencing a transactional object of a plurality of transactional objects in the transactional data model, the transactional data model being tailored to facilitate modification of the plurality of transactional objects, the view comprising at least a subset of the plurality of transaction objects assembled into a flat data structure; mapping one or more view fields of the plurality of view fields to one or more of a plurality of data warehouse objects stored in a data warehouse comprising a star schema that comprises a plurality of measure objects assembled into a fact table and a plurality of dimension objects joined to the fact table as a dimension table, the mapping one or more of the plurality of view fields comprising mapping the one or more of the plurality of view fields based on existing references to objects in the transactional data model, the mapping one or more of the plurality of view fields further comprising one or more of: creating, upon determining that first data content of a first view field of the plurality of view fields comprises a numeric value, a first new measure object in the transactional data model, the first new measure object storing one or more of: a first measurement, a first metric, and a first key figure, the creating comprising providing the first new measure object with a first reference to a first transactional object of the plurality of transactional objects in the transactional data model that is referenced by the first view field; mapping the first view field to the first new measure object; and adding the first new measure object to the fact table; and creating, upon determining that second data content of a second view field comprises a non-numeric value and that a second transactional object associated with the second view field in the transactional data model is referenced by at least one of the plurality of data warehouse objects, a second new dimension object, the second new dimension object referencing the at least one of the plurality of data warehouse objects and describing the second new measure object, the creating comprising providing the second new dimension object with a second reference to a second transactional object of the plurality of transactional objects in the transactional data model that is referenced by the second view field; mapping the second view field to the second new dimension object; and joining the second new dimension object to the fact table; the method further comprising: grouping the data warehouse objects to which the one or more of the plurality of view fields, including the first or second new measure object and first or second new dimension object, are mapped into a reporting data model that facilitates analysis and/or reporting of data in the data warehouse.