System and method for federated member-based data integration and reporting

摘要

Method and system for integrating data between source data and a target application processing target data. A declarative data integration specification including a lineage information linking a source dimensional member of the source data and a target dimensional member of the target data is defined. A data movement specification using the data integration specification including the lineage information, a source reference to a source data model, a target reference to a target data model and a query specification for extracting source data for the target application is generated and the source data to the target application using the data movement specification is provided. A federated member-based metadata model including a source metadata model, a target metadata model, the lineage information mapping the source dimensional member and the target dimensional member; and a link connecting the source package layer and the target package layer, is also provided.