SAP BW/4HANA, the Next Generation real-time data warehouse was launched in September 2016. This article gives an overview of the solution, the key benefits and the migration paths to BW/4HANA, as opposed to the previous SAP BW releases. It will also demonstrate that Data Structures, Data Integration and User Interface are significantly simplified. The article will also elaborate on the SAP BW/4HANA High Performance capabilities.
You are here
DW - Data Warehousing & Modeling
Supporting the BI Analyst in further developing the DWH environment using SSIS and SQL Server 2016. The ultimate goal is to accelerate the delivery of reporting to the business (Crew, Finance, Ship Management, ...). In addition, there is a migration process that links existing ETL, which is now directly linked to the source systems, to a central database system that is considered to be the "single source of truth".
The project consisted of building a data warehouse/reporting solution in SQL Server/SSIS and Cognos BI.
The goal of the project was to have standard management report on functional level, with drill-down/drill through functionality to a number of predefined reports/dimensions.
In addition, a self-service query model was made available which allows controllers to easily and quickly do their functional cost analysis. The data needed to be available at the lowest level grain (BPCS journal line level). Hyperion budget data (and non-BPCS actuals) was added to the level of BPCS CostCenter.
Analysis/Design and Build of data warehouse and reporting environment of all Sales related reporting/analysis requirements. Project was executed with a mixed team of element61 resources and ASI resources (both local and near shore in UK and Poland), managed by element61 project management. All development was done in a coaching and co-development model between element61 and ASI resources. During this phase of the project the existing non-sales legacy environment was uplifted from Cognos 8 to 10 (Cognos datamanager and Cognos BI). Main source system for this was BPCS