Removing invalid and non-printable characters in HANA based BW transformation

SAP BW/4HANA, HANA SQLScript

Most customers know the problem that invalid characters can be found in data records. Data load or DSO activation for char type InfoObjects can fail due to permitted or non-printable characters in BW. There exist several solutions for this problem. Some customer uses function module calls in ABAP transformations for example RSKC_CHAVL_OF_IOBJ_CHECK or RSKC_ALLOWED_CHAR_GET. Other […]

Continue reading


Playing with HANA parameters

The purpose of this blog was to share two end to end examples of passing parameters within HANA and using placeholders in SELECT statements. I have created two scenarios: HANA Table –> Table Function (with parameters) –> Calculation View (with parameters) HANA Table –> Calculation View (with parameters) –> Procedure (with parameters) The biggest lesson […]

Continue reading


Introduction to the SAP HANA smart data access linked database feature

SAP HANA, SAP QM, SAP MM, SAP, SAP BI, SAP CRM

Introduction to the SAP HANA smart data access linked database feature The linked database feature was introduced with SAP HANA 2.0 SPS 01, and greatly simplifies the workflow for accessing remote data sources. With the new linked database feature users can directly access remote tables and views without having to manually define virtual tables. The […]

Continue reading


Configuring Multiple SparkControllers in Ambari for HANA DLM, Hive and Vora Access

SAP HANA, SAP HR, SAP Tutorials, SAP Guide, SAP All Guide Tips

The default installation of the SparkController for HANA in a Hadoop cluster allows the archiving of data using DLM (Data Lifecycle Management) to HDFS and the accessing of Hive and DLM’d data with HANA. OR Access Vora data with HANA. but not both with the same SparkController instance. Currently the SparkController can be configured to […]

Continue reading


SAP Agile Data Preparation / SAP HANA / SAP BO Lumira in SCM (S&OP / Marketing vision)

sap hana sap bi, sap scm, sap bo lumira

Companies improve planning and control through the implementation of such processes as Sales and Operations Planning (S&OP) or as FCS, DPS, SCP, ERP and new known trends, where the key driver is realize from integrating ALL company processes with which the executive team uses to manage the business, improving financial performance and integration, including strategic […]

Continue reading