INTRODUCTION Summary ConSol customers require the facility to extract key information from the application system so that they can report on it in own BI environment. This approach will provide the following advantages: Greater flexibility and agility in delivery of reports. Ability to report across whole of business using in-house data integration approaches. Protection from future technology changes in Yarris. The extracted data, referred to as the Datamart, will be the single reporting entity that will be utilised by customers. This document details the scope and structure of the Datamart. Scope The extracts included within the Datamart correspond, to some extent, with the main ConSol entities. This presents a rationalised, business-oriented view of the application data. Three types of extract files are created: Master Extracts information/code sets: Removed Orders, Attributes, WIP Events, Compliance – Docs, Work Type and Milestone Type Detail Extracts detail relating to the core reporting entities: Projects, Orders, Items, Invoices, – Contracts, Rates, Documents, Attributes and Milestones History Extracts changes that have occurred within the processing window relating to core – reporting entities Data Master Extracts: Attribute Master ∙ Attribute List Master ∙ WIP Master ∙ . Work Type Master . Milestone Type Master Compliance Documents Master ∙ Removed Orders Master ∙ Entity Detail Extracts: Summary ∙ Project Details Delta ∙ Details Delta ∙ Order Item Details Delta ∙ Attribute Details ∙ Invoice Details Delta ∙ Invoice Item Details Delta ∙ . Item Variation Delta Contract Details Delta ∙ . Milestone Details Delta . Metadata Details Delta . App Survey Details
INTRODUCTION Summary ConSol customers require the facility to extract key information from the application system so that they can report on it in own BI environment. This approach will provide the following advantages: Greater flexibility and agility in delivery of reports. Ability to report across whole of business using in-house data integration approaches. Protection from future technology changes in Yarris. The extracted data, referred to as the Datamart, will be the single reporting entity that will be utilised by customers. This document details the scope and structure of the Datamart. Scope The extracts included within the Datamart correspond, to some extent, with the main ConSol entities. This presents a rationalised, business-oriented view of the application data. Three types of extract files are created: Master Extracts – information/code sets: Removed Orders, Attributes, WIP Events, Compliance Docs, Work Type and Milestone Type Detail Extracts – detail relating to the core reporting entities: Projects, Orders, Items, Invoices, Contracts, Rates, Documents, Attributes and Milestones History Extracts – changes that have occurred within the processing window relating to core reporting entities Data Master Extracts: ∙ Attribute Master ∙ Attribute List Master ∙ WIP Master . Work Type Master . Milestone Type Master ∙ Compliance Documents Master ∙ Removed Orders Master Entity Detail Extracts: ∙ Summary ∙ Project Details Delta ∙ Details Delta ∙ Order Item Details Delta ∙ Attribute Details ∙ Invoice Details Delta ∙ Invoice Item Details Delta . Item Variation Delta ∙ Contract Details Delta . Milestone Details Delta . Metadata Details Delta . App Survey Details
ConSol_Datamart_Specification_v6.0.docx