Skip to Content
Author's profile photo Ren Silva

Considering migrating BW to HANA? Why not?

Whilst the rest of the world seems to be taken by storm by the possibilities of HANA-powered BW systems, the adoption rate in Australia has been fairly modest. Why is that so?

The talk of the town is: “Why would I invest time and money just to make my BW reports run faster? My users are OK with the current performance. Why bother?”

Administration

First, there are hidden costs in making the current BW queries run as fast as they run now. Creating aggregates, pre-calculating queries, caching, etc. are all mechanisms that we all use to keep the performance of the existing analysis acceptable – and we lock our users into certain navigation states just to make sure that they get the response they need within acceptable time.

Getting in the way of progress

Not only there is an incredible overhead in making this all happen (disk, IT resources, you name it), we are also not giving our users the flexibility they  need – and they may well not be getting the benefit they need from the solution, because they cannot analyse data the way they really need to. They are simply not given the chance because this could result in unrunnable queries, that would just take ages to produce a result, or that could even crash the database. 

Projects

Another (not so hidden) cost: it is not uncommon for Analytics projects to include a major performance tuning component – it is no use delivering a solution that does not run fast enough for the users. This is a project cost that comes directly from the fact that our current databases are not capable of dealing with the required data volume fast enough.

We spend a lot of time analysing data loads, extractors, creating secondary indexes, analysing query performance, creating aggregates, including them in process chains, etc.

Furthermore, our BW team has been involved in several projects that have the sole purpose of making something run faster. Not long ago, I was involved in a major overhaul of HR data load to make sure that load ran within the nightly window (yes, the previous process could only be ran once a week) just to, at the end, hear a user say: “the reports are OK, but they only give me yesterday’s truth – I really need real-time information to make valid decisions”.

 
The Business Case

It is not hard to imagine how better performance translates to tangible benefits:

Reducing Cost of Administration

With HANA there is no aggregates, no indexing – so there is no need to maintain them. Administration is much simpler and the technical team can spend more time delivering new solutions, instead of maintaining the status quo.

This results in reduced Total Cost of Ownership.

Reducing Project Costs

The performance tuning component of the project reduces significantly. There is no need to spend time building aggregates. Many of the design options that we use today to improve performance become redundant.

The model becomes simpler too: it is possible to report straight out of DSOs, InfoCubes become smaller and simpler – and a lot of the work to reduce query runtime becomes unnecessary.

In my experience, Analytics projects on BW on HANA have been completed 10-20% faster, and used 10-20% less resources overall.

Software Licensing Costs

As absurd as this may sound, I have heard (and seen) more than once that, when the organisation puts pen to paper and compares the cost of their current Database License (and maintenance), BWA license (which is 100% redeemable on the purchase of HANA) and hardware with the cost of running a HANA database on a certified appliance, they have found that their overall bill will be reduced.

Why is that? HANA licensing is per database size (a set amount per 64GB units of productive system), whilst other databases are per seat. Furthermore, the size of a HANA database is normally 1/5 of the existing database. Moreover, hardware is getting cheaper by the day.

It pays to do the numbers – you will be surprised.

New Possibilities

We no longer have to find out the typical navigation state of queries and optimise the system for them. The user is free to navigate, interrogate, and truly slice and dice data, in ways that were not practical before. This creates new possibilities – not only users are able to gain more and better insights from the information they already have, but they are also able to get a larger number of different results from their existing projects.

You get more bang for your buck. Less projects are required to achieve the same results – this reduces the organisation’s overall cost of IT.

 
Self Service

In many organisations, IT managers have been reluctant to let users create their own analysis, as this could cause the servers to slow down or even crash – this fear is well funded. With HANA’s performance and ability to deal with large amounts of data, this fear no longer exists – and the user can explore data using BusinessObjects  tools such as: Explorer, Lumira (Visual Intelligence), Analysis, or even BEx.

This too reduces the overall cost of IT, as users require lessproject work to get the results they need.

Recycle abandoned solutions

Every organisation has Analytics solutions that are no longer used (or rarely used) because their performance became too poor. I know, I have seen and fixed many of them. Sometimes there is no fix: they have to admit defeat and simply stop using such solutions.

A faster database will breathe new life into these solutions and deliver the benefits that were intended when these solutions were first created.

Pervasive Solutions

Faster data load processes means data load can run more frequently, Virtual Providers become feasible and real-time data can be incorporated into Analytics solutions (obviously, the performance of the extraction still depends on the performance of the source system).

A new type of Analytical solution is now possible: solutions that enable the user to combine historical and real-time data. 

A Word on Migration

Migrating BW to HANA is a relatively small and highly non-disruptive project. It is essentially a system copy with some preparation either side to make sure the system shuts and starts in a stable manner (and unnecessary objects are removed) – provided the BW system is already at the required patch level.

There is a lot of literature about the subject, there is an RDS (Rapid Deployment Solution) path, and there are several options to reduce risk, resulting in a low-risk exercise.

Training requirements are minimum too (of course, HANA administration needs to be learned).

Concluding

Whilst the visible effect of migrating BW to HANA is a faster system, there is a lot more to it.

The impact of a faster system will be felt in: reduced administration costs, reduced project costs, reduced licensing costs and a plethora of new possibilities.

End users may not be clamouring for it yet, but they don’t know what they are missing.

Assigned Tags

      3 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Vivek Singh Bhoj
      Vivek Singh Bhoj

      Hi Renato!

      Nice Blog

      As you already mentioned for migration to HANA, Companies have to consider lot of things - Cost being the main one, then they might also have to upgrade their BW to at least 7.3 - many companies are still using BW 7.0 - will have to think which migration option to choose from.

      Then there are so many activities that need to be performed for Migration.

      I guess may be that's why they are not going for BW on HANA - though they would be getting lots of benefits if they switch to BW on HANA

      Author's profile photo Former Member
      Former Member

      Hey,

      some downturns:

      • Licence-costs - you do pay for Data-usage.
      • A little more instabile than an actual Oracle instance.
      • you are forced to update often...
      Author's profile photo Henrique Pinto
      Henrique Pinto

      Hi Renato,

      good insights.

      A couple of comments:

      • BW license model varies: there is the per-GB of RAM model, as you explained, but there is also the %-on-top-of-SAP-licenses model (a percentage on top of the current company's SAP maintenance base, 5% to 8% depending on the locale). One grows when the DB grows (auditing will take that), the other is fixed but will impact any future SAP purchases as well (e.g. 5% on top of all your future SAP acquisitions);
      • BWA licenses are not always redeemable (it's a case-by-case analysis).

      Anyways, nice analysis.

      One thing that pops to my mind: is it possible that Australian companies just don't have such large BW installations? What has been the largest you've seen? Maybe, with a 23 Mio population, they just never needed to get that big (apart of huge multinationals, such as BHP, of course). In Brazil and the US (the markets I know), it's rather common to see cases where even after all possible tuning measures were taken, the performance is still not enough. In such cases, staying still is simply not an option: they need to move to something new (be it HANA, or Exadata, or something else). When comparing solutions, then it's easier to justify HANA. It's harder when the alternative is just not doing anything (HANA _is_ expensive, that is a fact).

      Best,

      Henrique.