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

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

SAP Business Warehouse for the BusinessObjects Community Episode 3

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 create a MultiProvider on top of the Sales DSO, and then create a simple Bex query on top of the MultiProvider.  We also discuss some specific BW features that don’t exist in the BOBJ portfolio which are particularly beneficial in data warehousing.  We finish the podcast by creating an OLAP connection in the CMC, and connect SAP BusinessObjects Analysis for OLAP to our new Bex query.

Our next episode will cover connecting additional BusinessObjects tools to the Bex query.

We hope you enjoy watching.

Joshua Fletcher