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)

SAP Information Steward Episode 1 – Interview with Product Manager Michael Briles

Welcome to a new series that we will be running, all about SAP Information Steward.

Our video series will focus on understanding the various components of Information Steward in detail.

To kick us off, we interviewed Michael Briles, the SAP Product Manager for SAP Information Steward.

Here are the key questions we asked Michael:

00:40 Introducing Michael Briles

01:48 Business opportunities & key capabilities in Information Steward

11:34 Which industries are seeing high value with Information Steward?

13:42 Do you need SAP or BusinessObjects to use Information Steward?

15:34 What further user enablement is planned by SAP for Information Steward? (hint- attend SAP TechEd if you can!)

17:50 Self-guided demo of Information Steward 4.2

18:32 What is next for the SAP Information Steward product? (Safe harbour statement applies)

22:20 Josh’s laptop bluescreens but we recover successfully!

As a bonus, check out Ina Felsheim‘s recent blog on giving product feedback to the Enterprise Information Management product team – definitely worth checking out.

(Cross posted on SCNhere)

Using Dynamic DNS with HANA Development Edition

I’ve used Dynamic DNS with my Windows instances on Amazon EC2 for a while.

With the introduction of the HANA Development Edition, I was keen to also be able to use one common DNS name for any IP of my HANA instance on startup. Especially when creating demo clustered environments of 2-3 EC2 instances (HANA, BusinessObjects BI4, and Data Services), if all the instances can talk to each other straight away on startup (and your client tools on your laptop as well), it cuts down config time whether you presenting to a customer or wanting to start developing straight away.

Some of you may use Elastic IPs, I have found these to be a little tedious in creation and application, and apparently you are also charged for them when your instances aren’t running (which is most of the time for most devs). The solution presented in the video is an alternative to this approach. Please also note that this solution really applies to any Linux system, not just Amazon EC2 and/or HANA.

The detail presented in the video (available in HD so you can see the command line!) below will follow. Enjoy:

Here is the complete script:

  1. #!/bin/sh  
  3. ### BEGIN INIT INFO  
  4. # Provides:       dyndns  
  5. # Required-Start: $network $remote_fs $syslog  
  6. # Required-Stop:  $null  
  7. # Default-Start:  3 4 5  
  8. # Default-Stop:   0 1 6  
  9. # Description:    Update Dyndns  
  10. # Short-Description: Update Dyndns  
  11. ### END INIT INFO  
  13. . /etc/rc.status  
  14. rc_reset  
  17. USER=””  
  18. PASS=””  
  19. DOMAIN=””  
  22. case “$1” in  
  23.      start)  
  24.           wget -O /dev/null http://$USER:$$DOMAIN$$DOMAIN  
  25.           rc_status -v  
  26.           ;;  
  27. esac  
  28. rc_exit  

The commands I executed in the video above:

  1. cd /etc/init.d/
  2. vi dyndns (paste script in here)
  3. chmod u+x dyndns
  4. chkconfig -a dyndns
  5. service service dyndns start
  6. sudo ln -s /etc/init.d/dyndns /etc/init.d/rc5.d/S99dyndns

Lastly, if you aren’t familiar with opening an SSH connection to your HANA Development Edition, the steps to do so are posted in this SCN post (refer to Step 5).

I hope you enjoy this video, and welcome any feedback or questions.

(Cross posted on SCN here)

Predictive Analysis in New Zealand

At the end of May 2013 I was in New Zealand delivering some BusinessObjects training for SAP.  As luck would have it, the New Zealand SAP Business Intelligence User Group was meeting the morning of my layover through Auckland – very timely!  Fellow Mentor Corey Adams let me know and I was able to deliver a presentation on Predictive Analysis.  I showed several walk-through videos during my presentation, and was asked to post them up on-line.

Even though it is 2 months on, here is a summary of my presentation and the walkthrough demonstrations of Predictive Analysis for your viewing pleasure.

As mentioned in the video, here are the Useful Links: