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....