Skip to Content
Author's profile photo Matthias Wild

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.


ADRM on BI Mobile for TechEd Demo


That’s it for today. Questions?


Best regards,

René and Matthias


René Wirthmann is ADRM project lead and BI solution architect at SAP Global IT

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Marc Bernard
      Marc Bernard
      Hello Matthias, René,

      We should again preface this blog with “SAP runs SAP”. What you are describing in (part of) our SAP-internal system landscape. Looks really great!

      Customers who wish to get their hands on this solution can participate in the ramp-up for SAP BW powered by SAP HANA which is planned to start in November 2011. Please contact your account executive.

      SAP Customer Solution Adoption (CSA)

      Author's profile photo Former Member
      Former Member

      Hello Matthias,

      Hope, reports must be running very fast unlike the loads..Does sap has any plan how to improvise the loading times as well when we have such a high scale hardwares.

      Thank you..


      Author's profile photo Prabaharan Asokan
      Prabaharan Asokan

      Hello Matthias,

      Very nice blog.Here are my queries ,

      In this

      Q1. Is this done using BSP technology?

      Q2. Did you use Bex query ,if so how did you consume Bex query results from BW to ECC side?


      1.I am interested in developing a custom dashboard using BSP. Is it possible to do it with pie charts and all stuffs to deploy in iPad.

      2.I opt to develop dashboard because Xcelsius dashboards cant be deployed in iPad.

      Your suggestions are always helpful and means a lot to me.