Information Governance

Clint Vosloo and Josh Fletcher got up early this weekend to spend some time talking about Information Governance, and the technologies available from SAP to help in managing your information better.

Setting up SAP BW Near-Line Storage with SAP Sybase IQ

It feels strange for me to make a post in the SAP BW section as I feel horribly un-qualified to do this.

Below is a video that Ethan Jewett and I co-created as part of the Diversified Semantic Layer video podcast series, The Visible Layer.

What we did was use the new and now native NLS functionality in BW 7.3 SP9 to archive data off into SAP Sybase IQ. This is something that I have been talking about for years (see this blog post dated 12 months ago) as I have had exposure to the PBS NLS add-on from my Sybase background.

You will be glad to know that the results were simply awesome and I feel that by implementing NLS now as part of your BW strategy could benefit customers in a few ways, namely:

  1. Get the immediate performance benefit of using SAP Sybase IQ ( ** spoiler alert ** SAP Sybase IQ was +- 300 % faster off the DSO level compared to BW running off an InfoCube)
  2. Shrink the size of the database under-lying your BW environment. This has many benefits:
    1. Smaller environment to query on = better performance
    2. Smaller environment to back up
    3. Etc etc
  3. Get customers ready for HANA and know that you have a seamless and slick archiving solution in place with no performance trade-offs. This also means that you do not have to panic about your HANA environment running away from you.

I would love to hear everyone’s thoughts/opinions on this and I hope I got all the BW terminology correct

Get the popcorn ready and enjoy the video!

Clint Vosloo

here and includes links to lots of other resources.The PDF that we referenced in the video, which includes pretty much all the (relatively minor) installation steps is here (click on the “View this document” button).

(Cross posted on SCNhere)

Example Deployment of an SAP Analytic Bundle Episode 2

I recently blogged and shared a video walkthrough of deploying an SAP Analytic Content Bundle, covering the Insurance vertical. If you haven’t had a chance to read it yet, you can take a look here. In that video, I promised to record a second episode which covered the Telco Analytic Content, which was more in-depth and based on an SAP PowerDesigner model.

Well, here for your viewing pleasure, is Episode 2 – Telco & Utilities Analytic Content.

The steps I undertook before the video were:

  • Install a trial of PowerDesigner (available here)
  • Install a trial Sybase IQ (available here)
  • Download the Telco Analytic Content (available here)

As a reminder, these Analytic Content bundles are pre-built industry content are free, and provide an excellent starting platform as a data warehouse.  Let me know what you think of the Analytic Content bundles in the comments, and any feedback on the video.

Example Deployment of an SAP Analytic Bundle

Recently the Diversified Semantic Layer crew recorded a podcast with Jayne Landry (VP for Solution Management in the Analytics Team) focusing on the newly released Analytic Bundles.  If you haven’t had a chance, head over to to listen to the podcast.  These bundles are pre-built industry content using BusinessObjects BI4, and provide an excellent starting platform as a data warehouse, universe, as well as dashboards and reports for your business.

Why else should you care?  If you are an existing BusinessObjects customer, and running (or thinking of upgrading to) BI4 – guess what?  These Analytic Bundles are provided FREE.  Even if you aren’t a good fit for one of the industries, these provide a sample set of universes and reports that showcase what is possible with the tool.  You may even be able to reach out to Jayne and discuss if there is an opportunity to develop other industry-specific bundles.

As an extension of this topic, I wanted to do a walkthrough of the process to deploy an Analytic Bundle (preview: it’s super quick and easy!!), what it looks like from a deployment model, but most importantly – how it can easily be extended.

Without further ado, here is the walkthrough video for your enjoyment.

In our next episode, we will examine the Analytics Data Model for Telco & Utility, which leverages SAP Sybase PowerDesigner.

To look at demos of each of the Analytic Bundles (and/or download them), you can do so here.

Interview with Irfan Khan

This week I had the opportunity to attend some of the Mastering SAP Technologies 2013 sessions, held in Melbourne Australia, as well as the accompanying SAP Inside Track.

You can find some great coverage of the SITMEL and SAP Tech conference by Custodio de Oliveira here and bySimon Kemp here.

As part of the conference, the keynote was presented by Irfan Khan, who is the Head of Solution Management for Database and Data Warehousing as well as the Chief Technology Officer for the SAP Database & Technologies pillar.

Irfan’s keynote focused on ‘What Is Driving Technology at SAP?’, and ranged from discussion on programming for cache misses at the hardware level 20 years ago, to alleles and genome sequencing with HANA.

Later that day, Irfan gave me some of his time to sit down for an interview about his keynote and the Real-Time Data Platform (RTDP), which you can watch below.

Here are the key points in the video:

01:15   Key messages in Mastering SAP Technologies 2013 keynote

01:55   Overview of the RTDP

03:35   Timeframe to implement the RTDP

05:30   Foundational technologies underlying the RTDP

08:10   Common unified management and governance tool for RTDP

09:10   Implications for new application development with the RTDP

11:15   Implications of the RTDP for BI and DW professionals

SAP Business Warehouse for the BusinessObjects Community Episode 6

Hi everyone,

Welcome to the sixth and final episode in our Diversified Semantic Layer podcast series about Business Warehouse for the BusinessObjects community.  Once again I’m joined by Ethan Jewett, a fellow SAP Mentor.

In this episode, we will examine the how we can extend our data mart with new data from a different source system, the methods available to do this, and what benefits it provides for Enterprise Data Warehousing.

We hope you enjoy watching.

Joshua Fletcher