How to have Predictive Analytics functions [PAL] embedded in sql scripted views and applied on data in HANA Modeling

Here we are going through how we can use the Predictive Analytics functions provided via PAL in HANA in the Scripted Calculated views .

We are following the SAP provided SAP HANA Predictive Analytics Library ( PAL ) guide to do this.

PAL provides a vast business opportunity and immense business value to cater the needs of Analytics domain in projects implemented on SAP HANA platform.

Internet of things in Manufacturing using SAP Hana

How Internet of things ( IoT ) are relevant to manufacturing space is a widely debated topic. As a goal of IoT  tries to deploy vast network of sensors, actuators and connect them with wire or wirelessly leveraging internet protocol. If you look at this basic goal or need then its obvious that there is major scope in manufacturing IT domain. Looking at the trends in manufacturing for two decades or so there is tremendous increase in usage of automation technologies or robotics. At larger context primarily all these IP enabled equipment’s and systems need to be integrated interms of data and hardware with larger SAP system. Its a interesting way to utilize SAP Hana in a cost effective way for real time manufacturing data.  I am proposing to utilize SAP Hana for collection and analysis of real time manufacturing data  and integrate the same with enterprise level SAP platform. I am sure seasoned enterprise architects  in manufacturing environment can put more light from technical perspective to make this solution work.

Core Data Services – Standard Utilities / Reports

Introduction:

CDS Views can be created and viewed only from ABAP Development Tools (ADT) .The objective of this blog is to list down some standard utilities related to CDS Views which would allow us to gain information on these views from SAP GUI.

These reports will be useful for users who are not having access to ADT tools or not able to access the system from ADT due to missing authorization.

SAP HANA Authorization Tracing

This document will deal with issues regarding analytical privileges with SAP HANA.

So what are Privileges some might ask?

System Privilege:

System privileges control general system activities. They are mainly used for administrative purposes, such as creating schemas, creating and changing users and roles, performing data backups, managing licenses, and so on.

How to Prepare for C_HANAIMP_12 Certification on SAP HANAIMP 12

All that you need to know about SAP C_HANAIMP_12

SAP launched HANAIMP 12 primarily based on in-memory expertise with which customers can analyze giant volumes of informations and data in flip of seconds. This post is about the certifications which can be obtained with on SAP HANAIMP 12. SAP certification builds on the fundamental knowledge gained through related SAP C_HANAIMP 12 coaching and ideally refined by practical experience within an SAP HANA project team, whereby the consultant applies the acquired knowledge practically in projects. SAP has made available only one Associate Consultant certification with code: C_HANAIMP_12. This exam primarily verifies that the candidate possesses the knowledge in the area of the SAP HANAIMP 12 for the profile of an SAP HANAIMP 12 consultant. Make sure you are able to gain complete understanding and firm knowledge on SAP HANAIMP 12 certification syllabus. That includes SyllabusTopic for excellence in certification exam. Learn and explore everything about the SAP HANAIMP 12 for the profile of an SAP HANAIMP 12 consultant Things that you should be aware of for C_HANAIMP_12

• Exam details
• Duration of the exam
• Passing score on C_HANAIMP_12 exam
• Sample Questions that are available
• Topics of the subjects
• Format of the exam
• Areas of the subject
• Required training for the same

Get complete detail on The "SAP Certified Application Associate - SAP HANA (Edition 2016 - SPS12)" certification exam certification syllabus Below I have gathered all the data accessible to the very best of my knowledge related to the certification exam:

1. How many questions are there in the exam?

      A: 80

2. What is the duration of exam?

SAP HANA Tools-Modeler and Web IDE (New and Changed) – SAP HANA Platform 2.0 SP00

As of SAP HANA Platform 2.0 SP00, the following new features and changes are available in SAP Web IDE and integrated SAP HANA tools.

SAP Web IDE for SAP HANA is a browser-based integrated development environment (IDE) for the development of SAP HANA-based applications comprised of web-based or mobile UIs, business logic, and extensive SAP HANA data models. SAP Web IDE works in conjunction with the SAP HANA deployment infrastructure (HDI), the Application Lifecycle Management tools (ALM), the XS Advanced runtime platform, and various SAP HANA tools.

C_HANATEC_11 Certification Guide

All that you need to know about SAP C_HANATEC_11

SAP launched HANA Technology primarily based on in-memory expertise with which customers can analyze huge volumes of information and data in flip of seconds. This post is about the certifications which can be obtained with on SAP HANA Technology. SAP certification builds on the fundamental knowledge gained through related SAP HANA Technology coaching and ideally refined by practical experience within an SAP HANA project team, whereby the consultant applies the acquired knowledge practically in projects.

SAP has made available only one Associate Consultant certification with code: C_HANATEC_11. This exam primarily verifies that the candidate possesses the knowledge in the area of the SAP HANA Technology for the profile of an SAP HANA Technology consultant.

Make sure you are able to gain complete understanding and firm knowledge on SAP HANA Technology certification syllabus. That includes topics like System Architecture, Users and Authorization, Security etc.

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.