Skip to Content
Author's profile photo Former Member

BIOnDemand: It’s free…. Why aren’t you using it ?

Since the YouTube video below got released last week I have had many people ask me “what’s your secret” and “how did I spot that in the data” ?

As I am sure you are all aware I am certainly no clairvoyant and do not possess the skills that Dustin Hoffman’s character had in Rain Man.

What I do every time I see a new data set or a whack of information is to try and apply the “I” in Business Intelligence that is truly lacking these days. My thought process usually goes something like this when seeing the new information:

  1. How can we represent this data in a different way to change the way people look at this information ?
  2. What disparate/external data source can I bring into this report to enrich the value of the information and add another dimension to the decision making ?

In the case mentioned in the YouTube video above it was very much a 1. situation as the customer had been staring at the same report for well over a decade and it was clear they never fully grasped the effect of the data that was being presented to them. They do say that no presentation is complete without a pie chart and suddenly, when the data that was always buried in a long winded auditors reports was presented in our trusty pie chart did their outlook change on the data.

The beauty about BIOndemand, besides the fact that it is free, is that in a very short space of time you can be slicing and dicing your static data and getting new insights into your data. As you can judge by the tone of this post, I LOVE this product, and use it as my “secret weapon” when ever I am going to see a new customer. How do I do that? Simple!

Most customers we deal with are listed companies and have audited financials/reports posted all over the internet. Before the meeting I always extract some of that information and then, on my iPad, during an introductory meeting show the customer the “art of the possible” with their own data which really is a powerful message. It really can be as simple as taking their balance sheet and showing them visually where the bulk of their liabilities lie… the permutations are endless ! 

To me you can never underestimate the power of customers seeing the information that they can relate to – the world has moved past the stage of the “How many green T-shirts were sold in California ?” demos.

So what I decided to do, and I limited myself to an hour to prove a point, was to get some random data off the internet and put it in a BIOnDemand instance and see how/where I could add value to give you an idea of my thought process….

As I know a lot of us consultants spend our time bouncing between airports I managed to find this site which has all the data based on how and why flights are on time through out the US.

The graphing looks like this:


I then downloaded their raw data which came in this format:


If you look closely in the “airport_name” column there is a lot of information there, namely:

  1. Town
  2. State
  3. Airport Name

Other enhancements I made to the file were as follows:

  1. Split the above 3 items out ( this way we can analyze which is the most reliable airport by State/Town)
  2. Added a column for Season ( Winter/Summ/Fall/Spring) as this may affect reliability in certain areas
  3. Added a total column aggregating all the flight information. from my world it really does not help that 100 flights are late. If that was in relation to 110 then you not going to fly out of there but on the other side of the coin if that was based on 100 000 flights you would be less concerned.

Below are a few screen shots that I have taken in BIOnDemand to get an idea of the new added functionality and the multitude of ways that you can now analyze your information:


Pic 1: The warmer it is the more people fly


Pic 2: Planning for TechEd in Vegas – SouthWest have the most flights into Vegas – but also the most delays !


Pic 3: The top 10 most reliable airlines flying into Vegas in October for two years (2010,2011)


Pic 4: Weather delays, which I “think” are peoples biggest fear of flying, cause less than 1 % of delays

Pretty cool stuff… well I believe so … I could go on forever – but you will be glad to know I won’t 😉

Yes there are some negatives about the free BIOnDemand service if you have to take a closer look, such as:

  1. It does not handle negative values very well
  2. Size limit (but as I said it’s free so stop being cheap)
  3. Dates are a bit of a nightmare to work with for sorting etc etc

There are 2 main points that I want to stress before people get carried away with BIOnDemand and go replacing their Enterprise Data warehouse (EDW) with BIOnDemand – there is a product that begins with a Q that already tries to achieve this:

  1. BIOnDemand is an amazing POC tool that can be used to get business buy in and give them insight/vision into what is possible with their information. When I present this to customers I always show a picture of an iceberg with this being the very tip of it ! Garbage in = Garbage out so the correct infrastructure/architeture and governance need to be in place to ensure quality information. ( As a “challenge” to the detail orientated folk I have purposely had some “finger trouble” in the Excel sheet which skews numbers a lot and could have cost someone their job – coffee with me at TechEd for the first person who spots it 😎 “Terms and Conditions Apply and Excludes Travel and Jamie Oswald”)
  2. Running under BIOnDemand is HANA. I am one of the front runners in making sure my customers buy HANA for the right reason and use case and not buy it due to market hype. In this instance HANA really performs amazingly behind the scenes and really gives the BIOnDemand the real time feeling for the end user. At the end of the day I want my end users to not care/know about where the information lies and I have to admit that SAP have it spot on here with HANA powering BIOnDemand. ** UPDATE ** Thanks to Ethan Jewett for pointing out that the free version on BIOnDemand does NOT run on HANA which really questions why SAP brand the the OnDemand site with “powered by HANA”. His full write up on this can be found here.

Please feel free to contact me if you would like to play around with this dataset on BIOnDemand as I will happily share it with you. If you would like access to the data directly then click here

Really keen on your thoughts on this technology and I feel if you ensure that you pitch this tool at the right level and carefully explain where it fits in then it will become an awesome part of your arsenal


Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Susan Keohan
      Susan Keohan


      Very nice blog - makes me wonder if I could use BI OnDemand too.  Thanks for taking the time to show us how you worked your magic.

      Author's profile photo Former Member
      Former Member

      Thanks Sue !

      As nerdy as this sounds I actually integrate our companies timesheet system with rates/margins etc etc into BIOnDemand.

      The first month I did this I got a shock as ( I forget the exact numbers) but 63 % of our time was getting spent at customers contributing 34 % towards the bottom line which made me change things up quickly !

      I am still not yet brave enough to put the family expenses is there yet 😛

      Author's profile photo Sascha Wenninger
      Sascha Wenninger

      Wow - very very cool stuff Clint!

      What a great way of showing people the "I" in BI is about so much more than a few canned reports you look at once a month, if that.


      Author's profile photo Former Member
      Former Member

      Thanks mate... !

      Author's profile photo Jason Scott
      Jason Scott

      Excellent blog. I had no idea BI OnDemand even existed until now - there's just too much going on.  😉

      I've already logged in and loaded a data set from excel to try it. Great that there is an iOS app so I can play with the data on the iPad.

      Now just need to work out how to get reports in the iPad looking cool like all the ones in the recent SAP videos...

      Author's profile photo Former Member
      Former Member

      Thanks Jason. Be warned that the latest video's that I think you are referring to are probably the Visual Intelligence ones. My take on that is that it is an extension on the Explorer product and is GA only on HANA now - if I have my facts correct ? 😉

      Author's profile photo Jason Scott
      Jason Scott

      ok thanks Clint. I'll wait a bit longer for the fancy ipad screens then... Just noticed your update that it does not use Hana (from @esjewett) - very interesting. Unfortunately the news that it "does" run on Hana has already spread like wildfire.

      According to this wiki:

      we can get nicer looking reports on the iPad by using web intelligence documents... I've only looked at this "very" briefly. It seems that you use the Web Intelligence client to play with your data and generate the report (.wid file), then you load this report into BI OnDemand.

      So not quite as nice as being able to play with the raw data in BI OnDemand - yet.  Thx.  😎

      Author's profile photo Former Member
      Former Member


      Fascinating to see the detail behind the story. It makes a very compelling case for BIOnDemand. We will do all we can to spread the word. You've joined the SAP Mentor group with a bang!

      Author's profile photo Former Member
      Former Member

      Thanks for the kind words Gail. Would not have been possible if you had not taken the time to connect with us and set up the interview so HUGE thanks to you. Hopefully have a few more stories for TechEd in Vegas ! Thanks again !

      Author's profile photo Vineet Gupta
      Vineet Gupta

      I have used BI Ondemand to demo Business Objects Explorer as well as BI on IPAD and Iphone. Works really well and is impressive. Great blog.

      Author's profile photo Former Member
      Former Member

      Thanks Vineet... and as I am sure you know I agree with the fact that it is a great tool. Busy prepping now for a meeting next week with another large corporate who are driving their business on Excel and cannot wait to BiOneDemand them 😉

      Author's profile photo Former Member
      Former Member

      Brilliant video and blog; amazing story. This is going viral... 😎

      Author's profile photo Former Member
      Former Member

      Hay Mark - thanks for the kind words and for also spreading the work 😉

      Author's profile photo Former Member
      Former Member

      that was meant to be word and not work !

      Author's profile photo Former Member
      Former Member

      Great story Clint, well done!  I used to use BI OnDemand in a similar way, but now I run an Amazon AWS instance in the cloud that runs the latest BI4 FP3

      With the release of HANA in AWS as well, you can actually build a HANA and BI4 FP3 environment that is extremely high-powered and which you have complete control over.

      I now use this method for all my POCs and demos, as I can stay on the latest version, and still use my iPad to access Explorer and Mobile Webi.

      Perhaps an alternative for those happy to invest some time in building their own environment - but with the bonus of actually being able to say it runs on HANA 😉

      Cheers, Josh

      Author's profile photo Former Member
      Former Member

      Thanks Josh. As we discussed earlier today I am busy setting up my HANA AWS Instance now and will definitely plug Explorer from the BI4 stack on top of it... Thanks for the idea ! 😎

      Author's profile photo Former Member
      Former Member

      Hi Clint -

      Very nice article..

      I did a presentation last year, and include a BI on demand solution in my deck, and actually had someone ask me whether this was on HANA, due to the 'Powered by HANA'...

      Your concept of taking the client's data, and showing it to them in a different manner is fantastic - and not done enough.

      PS - based on the tweets this amn, you sound like you're close to Cape Town International. My hometown for 18 years was Paarl.



      Author's profile photo Former Member
      Former Member

      Thanks Johannes  !

      Yip based in Cape Town - where you based now ?

      Author's profile photo Former Member
      Former Member

      Now out of Raleigh, NC...came to US in '98....