Skip to Content

This week I’m starting a new blog post series aimed at the readers that are technically interested in SAP HANA but don’t want to spend hours each week checking every new post, article, forum discussion or sap note about this hot topic.

These regular posts will be little collections of what I found interesting, notable or important in the area of HANA.
Since I’m rather the technology guy and severely biased towards the database-backend-part of it, it shouldn’t surprise anybody that this is not going to be a comprehensive overview that covers all HANA related topics.
Instead it’ll merely be what I read on the topic – so I hope you like this ๐Ÿ™‚

If one or the other now thinks “hmm… this concept is somewhat familiar…” then you’re absolutely right. I really like Pythians “Log Buffer) a lot and HANA is just missing there.

So let’s start and look what the last week (CW 44, 29.10. – 5.11.2011) had for the HANA community:

Several SAP notes had been published

The most important to start with: Revision 18 of the SAP HANA database (and of the related client software of course) had been released and it fixes a lot of issues. On top of that, it also brings several enhancements, especially in the area of the error handling with delta index merging… at least this is mentioned twice in SAP note #1646454 SAP HANA appliance: Revision 18 of SAP HANA database

[...]
o Improved error handling for delta merge
o Improved delta merge error handling
[...]

Maybe they double-enhanced it … ๐Ÿ™‚

++++ —- ++++ —- ++++

If you’re using the segment builder from the SAP CRM solution and want to access HANA then SAP note #1577019 SAP HANA Database: Abap module for Segment Builder is for you.

++++ —- ++++ —- ++++

SAP BW on HANA is about to be published soon, so sizing is a topic that will become important. Details on this can be found in note #1637145 SAP BW on HANA: Sizing SAP In-Memory Database.

++++ —- ++++ —- ++++

HANA instances can of course be monitored via the DBACockpit like any other supported DBMS. As a security enhancement there is now a special user (DBACOCKPIT<SID>) setup available that allows the DBACockpit usage with mininmal permissions for the monitoring user account.
SAP note #1640741 Different database user for DBA Cockpit for SAP HANA has all the details.

++++ —- ++++ —- ++++

If you want to install all already published SAP BASIS corrections in one go, make sure to check SAP note #1644214 Comp. SAP Note Basis porting to SAP HANA DB, NW 7.30 SP06.
It’s a composite note that contains all HANA related corrections for SAP BASIS 7.30.

++++ —- ++++ —- ++++

In case you’re moving your SAP BW system to HANA you won’t need to export the aggregate fact tables, since these aren’t necessary anymore with HANA. The correction from SAP note #1644396 SMIGR: Kein Datenexport der Aggregate-Tabellen modifies the famous SMIGR_CREATE_DDL report accordingly.

++++ —- ++++ —- ++++

For the rare cases where you want to create a database index just for a HANA instance, you need to set this up in the ABAP dictionary. SAP note
#1644788 Datenbank-spez. Index: SAP HANA DB ist nicht in Auswahlliste now allows to actually select HDB in the GUI by adding the value ‘HDB’ to the list of values of domain DDIXDBSEL.

++++ —- ++++ —- ++++

SQL Hints will still be with us with HANA and SAP note #1645317 SQL Hint wird nicht im Datenbank Trace angezeigt makes sure that we’ll even see them in the SQL trace (ST05).

++++ —- ++++ —- ++++

By using secondary database connections it’s possible to run your reports agains several HANA instances. Unfortunately there had been a bug with the initialization of the connection information – but no more: SAP note #1646010 SAP HANA: different DB connections are not handled correctly fixes this!

++++ —- ++++ —- ++++

Altough HANA database provides many different client technologies SAP provides support just for a defined set of them.
Make sure to check SAP note #1577128 Supported clients for SAP HANA 1.0 to figure out, which combination of HANA database and clients are actually supported.

++++ —- ++++ —- ++++

Finally two SAP notes for the trigger based data replication solution for HANA (LTR for Landscape TRansformation, not for L-language TRigger, or License To Rage … ) provide fixes for bugs:
#1647648 HANA LTR – corrections for DMIS 2010 SP4 111031 (stop repl) #1648783 HANA LTR – corr for DMIS 2010 SP4 11/11/03 (pool 16+keys)

Other releases

In Siri + HANA Sina Moatamed discusses future use cases of HANA and interface technology like Apples Siri.

++++ —- ++++ —- ++++

SAP BW on HANA will surely be the next big thing and a lot of people have a lot of different guessing about this. In How BW-on-HANA Combines With Native HANA Thomas Zurek explains how it’s actually going to work. Definitively worth the time to read!

++++ —- ++++ —- ++++

In Why SAP HANA 1.0 SP03 – Project Orange – will be a runaway success John Appleby explains why BW on HANA really will turn out great.

++++ —- ++++ —- ++++

Test driving HANA is what many customers and partners ask for and Jeff Word lays out the current options in his blog SAP HANA Test Drive in Madrid.

++++ —- ++++ —- ++++

If you’re now really interested in becoming involved with HANA you may check Paul Desmonds Experienced HANA? How to Educate Yourself about SAP HANA blog post.

Et fini!

That’s it for this week and for the first issue of this little back trace of my HANA readings. Hope you liked it.

A nice weekend to everyone!

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply