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:
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)
Shrink the size of the database under-lying your BW environment. This has many benefits:
Smaller environment to query on = better performance
Smaller environment to back up
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!
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).
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.
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
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.
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.