Input parameter based on procedure of type Date

Use case: The user is asked to enter a date. If nothing is specified then it should be default to first day of the current month else user specified value should be used to filter the data, using Graphical calculation view.

If you are thinking to do by using Input parameter with “Derived from Procedure/Scalar function”
then you are almost there with just 2 hurdles to cross.

For this demonstration I’m using the below table structure for which the field
DOJ is of type DATE on which the input parameter will be used.

Upgrade your HANA, express edition to HANA 2

1. Temporarily increase memory to 23.9 GB
2. Create temporary user
3. Uninstall HANA 1
4. Install HANA 2
5. Install AFL

In order to allow for the upgrade to HANA 2, I have to temporarily increase the memory of my virtual machine to 23.9 GB as before:

Visualizing SAP HRF Rule Results in SAP Lumira – Part 2

SAP Lumira Desktop Preparation and Presentation

Data Source

The first thing to understand is that SAP Lumira cannot be directly connected to the SAP HRF column view “SAP_HRF”.“sap.demo-store.sales.resources ::Sales Analysis.VIEW”. The SAP Lumira data source must be a cube such as those created by an Analytic View or a Calculation View. I therefore need to build one of these against my rule service column view.

Visualizing SAP HRF Rule Results in SAP Lumira – Part 1

SAP HANA Rules Framework Overview

SAP HANA Rules Framework is perfect for handling complex analytical rule constructs in real-time (online) and batch (offline) scenarios and makes the best use of the power of SAP HANA in order to achieve this. The built-in Fiori user interface that is distributed as part of SAP HRF is excellent at providing rule creation and management and allows rule results to be displayed in a textual manner. SAP HRF is all about providing the ability to allow business users to control, influence and personalize decision making in highly dynamic scenarios within the organisation in the most efficient and robust manner. Outside of SAP HRF it is the calling applications responsibility to make use of the decision results and actions that SAP HRF has returned.

SAP HANA DB Installation Steps (Part 2)

Steps to follow:

1) Download the SAP HANA media file  from  service market place
2) Place the media file into the some safe directory location
3) Loginto OS level with” root user” or SIDadm
4) Go the directories which you the HANA media file cd <installation medium>/DATA_UNITS/HDB_LCM_LINUX_X86_64
5) Start the SAP HANA platform lifecycle management tool:
6) Find the file and execute “./hdblcm --compontent_root=/DVD"

Modelling: Column to Row Transpose using Matrix in HANA

Background:

In almost every project, some form of data transformation is required. Most of these transformations are some combination of Aggregation, Projection, Union or Join steps and these transformation can be easily done in the HANA models.

Where possible, It may be a good idea to push the complex transformation to the data acquisition layer using ETL tools like data services.