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)

The Universe Dreams are Made of

Weeeeee’re Baaaaaaaack.  While you may be wondering how no one noticed that we were actually off the air a bit, we forgive you.  We are quite excited to be back on the recording deck to punch out a long awaited episode.  In this show, the gang all takes a swag with our guest Ethan Jewett and telling SAP just what we’d love to see in a single semantic layer for SAP BI.

You may be wondering what that echo is during part of the recording.  It was an unusual show with Eric hanging out with Greg in Philly and Josh bringing “down under stereo” to the show.

To that point, when you do hit that part about the tweet up, don’t tell our moms, but do comment on whether you’d like to tweetup again at SAPPHIRE.

Enjoy the show, we did.

Feel free to stop by iTunes to subscribe, or go for a direct download.

Play it now:

Panelist
Ethan Jewett Ethan Jewett
Jamie Oswald
Greg Myers
Eric Vallo Eric Vallo
Joshua Fletcher

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

SAP Business Warehouse for the BusinessObjects Community Episode 5

Hi everyone,

Welcome to the next 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 improvements made to the Bex query in Episode 4, such as navigational attributes, hierarchies and units of measure.

Our next episode will see us bringing in a second data source to recreate the requirements of an Enterprise Data Warehouse.

We hope you enjoy watching.

Joshua Fletcher

SAP Business Warehouse for the BusinessObjects Community Episode 4

Hi everyone,

Welcome to the next 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 connect to our new Bex query using many of the BusinessObjects tools, including Web Intelligence, Crystal Reports and Dashboard Designer (Xcelsius).  We finish up by walking through creating a multi-source universe on top of the Multiprovider, which will allow us to query BW from Visual Intelligence and Explorer.

Our next episode will continue on optimising and explaining different features of BW.

We hope you enjoy watching.

Joshua Fletcher