Joshua Fletcher has worked with Business Intelligence applications for over eleven years, focusing on both the SAP BusinessObjects toolset at a deep technical level, as well as broader BI solutions from a strategy and roadmap perspective. He started with Crystal Reports v8 at the beginning of his career, and is now fully certified in SAP BusinessObjects. He also has extensive experience in business analysis, data governance, business intelligence strategy and solution architecture, as well as a passion for data warehouse and ETL design and development.
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).
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:
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: