0 Replies Latest reply: Jun 1, 2012 7:56 PM by Rama Shankar RSS

SAP HANA v1.0 – SPS4 – What’s New for HANA Developers?

Rama Shankar
Currently Being Moderated

SAP HANA v1.0 SPS4 was released in May, 2012. Several customers using SAP ECC and new to SAP ECC around the World have added SAP HANA & HANA DB for BW to their corporate IT strategy. Below is a list of “DO NOT MISS ” features available in SAP HANA v1.0 SPS4 for SAP HANA developers.


A – New Tool for HANA DB Information Access - (Next Generation Data mining tool):   The new SAP HANA UI for Information Access (aka INA) provides UI building blocks for developing search-based applications on SAP HANA data. Such applications can provide a gateway or enterprise search features for huge volumes of structured and unstructured text data stored in SAP HANA and other external data marts


B - Flat-file Import Tool (aka Data from local file wizard): A new tool in SAP HANA SPS4 that provides a straight forward way to load flat files into SAP HANA without having the need to create control files and scripts. The supported file types are .csv, .xls, and .xlsx.


C – SAP HANA Client for Microsoft Excel: To access the SAP HANA database from Microsoft Excel, you can now install and use the 32-bit SAP HANA client for Microsoft Excel


D – Fuzzy (aka Fault-tolerant) Search Feature: The Fuzzy search feature provides a new string comparison option that internally uses a system generated TF/IDF (term frequency / inverse document frequency) score based search. Customization to Fuzzy search with tracing performance is available within SPS4 to speed up the fuzzy search as per different business needs.


E - R Programming Language Integration:R Language” is an open source programming language available for the SAP HANA environment that can used to develop applications that require statistical computing and graphical features. The R language exploits the SAP HANA high performance features such as MPP (massive parallel processing


F – Enhanced HANA Variables & Input Parameter Options: From SPS4 variables can be assigned to an attribute, which is used for filtering in the where clause. Variables can be applied to attributes of analytic and calculation views.


G – Enhanced Hierarchy Option:  Hierarchy creation now possible between the attributes of a calculation view in addition to attribute views


Please feel free to expand on your experiences with  the above new features and/or share your experiences with other SAP HANA v1.0 - SPS4 features....