How does analytics look like on BW powered by HANA
Don’t miss the first blog: Corporate scale SAP Business Warehouse powered by SAP HANA
What has happened since the last blog: The setup of the SAP NetWeaver BW powered by HANA system landscape is progressing. Two BW 7.30 SP5 systems are now running on a HANA SP3 database and we are preparing the migration for the 3rd and last system in the 3-tier landscape. The focus until now was very much to successfully migrate the systems and to establish first reporting solutions. In the next four weeks we will also establish monitoring, support and operations processes for the business usage. Business go-live is not far away.
At the end we need to have an end-to-end operations framework to manage the BusinessObjects Intelligence 4.0 platform with mobile capabilities, the SAP Business Warehouse powered by HANA and HANA by-side sources in a holistic way. The business expectations on stability and performance will be very high and High Availability and Disaster Recovery capabilities are a must. It is too early to speak about the details, but I will share the concept in another blog in some weeks.
One thing I can tell already today: We are running the HANA on a certified single server as of today. We used one of the largest machines you could order at that point in time, but it will not be sufficient for our future needs. Not in terms of memory, not in terms of scalability and not in terms of failover capabilities. At least not in the production environment. Very soon we will move to a certified distributed server scenario. I can’t share hardware details yet, but you should speak to your preferred hardware vendor to learn more about the next generation.
Now let me introduce one of the new reporting solutions, which has been build (yes, it is ‘has been’, not ‘will be’) in this environment, the ‘Automated Deal Roadmap’. This is the business description: The Automated Deal Roadmap (ADRM) provides a single authoritative source for all sales forecasting for sales executives at all levels. ADRM provides full transparency of both actual recognized revenue combined with Sales pipeline to provide a consolidated view of the sales goal and potential to simplify managing and achieving sales revenue targets in an efficient and cost effective manner.
High-level source and data model picture for ADRM solution
ADRM is using the entire environment: Sales pipeline data are read out of the HANA by-side CRM (from BW application stack via 2nd connection directly from HANA DB), financial COPA data are read out of the HANA by-side ECC, master data are staged in BW powered by HANA and joined together within BW in a new type of virtual infoprovider. BW provides also some other features on-the-fly: Currency conversion and analysis authorizations. The reporting is available via BICS connection in BusinessObjects 4.0 solutions on desktop or mobile. This the perfect proof point to demonstrate a complete new generation of analytics solutions, but also to design new processes and concepts on IT side to manage those. This is truly changing the game.
That’s it for today. Questions?
René and Matthias
René Wirthmann is ADRM project lead and BI solution architect at SAP Global IT