In my documentation I’ll explain how to install SAP Hana SP10 on a Linux Red Hat 6.6 system in my test environment.

I will show in detail step and configuration point to achieve it.

For my setup I’ll use my own lab on Vmware Vsphere 5.1.0 and run Hana revision 101, I’ll reuse my existing environment setup in my previous documentation.

In order execution

Download Red Hat 6.6 release
Install the minimal RHEL
Configure RHEL
SAP Hana installation

Guide used

Red Hat Enterprise Linux (RHEL) 6.x Configuration Guide for SAP HANA
SAP HANA Master Guide

Note used

SAP Note 171356 - SAP Software on Linux: General information
SAP Note 2009879 - SAP HANA Guidelines for Red Hat Enterprise Linux (RHEL) Operating System
SAP Note 1496410 - Red Hat Enterprise Linux 6.x: Installation and Upgrade
SAP Note 2136965 - SAP HANA DB: Recommended OS settings for RHEL 6.6
SAP Note 2001528 - Linux: SAP HANA Database SPS 08 revision 80 (or higher) on RHEL 6 or SLES 1

Link used

Red Hat Enterprise Linux for SAP HANA: system updates and supportability
Help SAP Hana
RedHat access documentation

Overview Architecture

In my previous documentation “SAP Hana TDI setup - VMware 5.1” I have explain and setup different scenario of Hana deployment, I’ll use same proceed to create my vm and template for reuse later.

Download Red Hat 6.6 release

In order to be able to download Red Hat dvds you must first register

Once done, validate your account and download the necessary media

Now downloaded I store it in my datastore

Install the minimal RHEL

My vm ready and my dvd ready I start to install the base Red Hat system

Make sure the automatic connection to the network card is enabled

Set the time zone and system clock according your location

I choose the first option since my system is just about to be created

Choose minimal option

Installation in progress

Installation completed

Configure RHEL

The base installation is now over the system needs to be compliant to host SAP Hana, the configuration consist of the following activities:

•    Subscribe your system to Red Hat channels
•    Install the base package group and xfs tools
•    Create the /usr/sap/ storage for SAP HANA.
•    Mount the file system for SAP HANA instance
•    Install dependencies package for Hana
•    Install the SAP Java Virtual Machine or IcedTea
•    Disable SELinux in /etc/sysconfig/selinux
•    Install and configure the package tuned-profiles-sap-hana
•    Configure the profile for vmware
•    Set the parameters in /etc/sysctl.conf
•    Set the symbolic links
•    Add the kernel command line argument for crash huge page
•    Omit the application crash and core file handling of the operating system

Subscribe your system to Red Hat channels

In order to be able download patch, package and so on, the system must be register against Redhat by subscription, but in order to have SAP Hana specific package for RedHat you need to be register in “Partner center” and join as an existing partner company or apply for partnership

Once the registration fully completed and approved (it takes few days), run the subscription manager on your system

And list all the available production available for you, you must have “Red Hat Enterprise Linux for SAP Hana” listed

Attach the subscription to your pool ID (this information is system dependent)

Run the subscription release

Disable all existing repositories

And finally enable on “Hana’ repositories

Install base package group and xfs tools

Create /usr/sap storage for SAP Hana

From my ESXi host I did add another volume to my RedHat server in order to create “/usr/sap/” file system.
I check now by “lsblk –f” command of my new volume is there

Let’s create my physical volume by “pvcreate /dev/sdb” command

Now create the new volume group by “vgcreate new_volume /dev/sdb” and run the command “vgs” to check

The VG available with 50gb of space I’m creating now my logical volume with only 40gb of space in order to keep some room on my disk

And finally I create my physical file system and mount it

Result

Mount the file system for SAP HANA instance

The next phase will be to add the nfs mount point from my NAS server to RedHat for Hana by editing the fstab
Do not for forget to install nfs package by “ yum groupinstall "Network file system client"”

Once done “mount –a” and check

Install dependencies package for Hana

Like in SLES environment, RHEL needs to have specific package dependency in order to deploy Hana.

Install the SAP Java Virtual Machine or IcedTea

Disable SELinux in /etc/sysconfig/selinux

Install and configure the package tuned-profiles-sap-hana from the RHEL for SAP HANA channel to minimize latencies

For Hana running on VMware

Set the parameters in /etc/sysctl.conf

Set the symbolic link for compatibility reason

Add the kernel command line argument for crash huge page by editing /boot/grub/grub.conf file

Omit the application crash and core file handling of the operating system

This completed for the system preparation in order to install SAP Hana, I can proceed to the next section

SAP Hana installation

We are ready now to install SAP Hana and it’s like running it on SLES, so no surprise.
I’ll go by the hdblcmgui to run the install because a specific string is required as you can see in the red square below.

That’s it, Red Hat is very specific regarding package so do not missed any step.

Here is a document which will give you step by step guidance on how to load data from SAP ECC to SAP BW on HANA system and then perform reporting based on the BW BeX queries in Web Intelligence Reporting Tool

This document is basically for beginners in Business Objects , who are working in SAP Business Warehouse and have to create reports on Web I

The basic purpose of this document is to convert the Bex Reports into Web I Reports for more enhanced features and good look and feel of the reports.

I. Architecture Diagram

I. Step-By-Step Development Process

A. ECC-BW ON HANA REPLICATION (LO Extraction)

1. Login

Steps to extract data from ECC to BW on HANA system through LO Extraction

To login Start à SAP LOGON àSelect the ECC Systemà Enter the relevant username and password.

NOTE: To get the data from SAP ECC to SAP BW system , we perform Extraction Methodology

There are various types of Extraction methods as specified below:

Application Specific --BW Content FI, HR, CO, SAP CRM, LO Cockpit
Customer-Generated Extractors -LIS, FI-SL, CO-PA
Cross Application (Generic Extractors) - DB View, InfoSet, Function Module

In this document we will be using application specific method ,to extract the Sales data by using LO Extration Method.

Go to /NRSA6 ---> SAP-R/3 ---> SD

Check if the needed data sources are activated

Here we will be replicating datasource for Delivery Item Data 2LIS_12_VICTM

If the datasource is not visible in /NRSA6 (datasource is not active)

Go to /NRSA5 and activate the required data source.

Go to --> /NRSA3 --> Extraction

To check whether the extraction is done properly

Before performing extraction make sure to delete and fill the setup tables,

Please go through the below link for more details of Lo Extraction Steps

Lo Extraction step by step guide

For Replicating the data from ECC to BW system

Go to SAP LOGON ----> BW LOGIN -----> ENTER CREDENTIALS

Once the datasources are activated in ECC system , Go to BW on HANA system and type RSDS

Provide the Data Source name that needs to be replicated and the ECC system name from where it is been replicated.

Here 2LIS_12_VCITM is data source and ECW_00_800 is source system.

Click DATASOURCE ----> REPLICATE DATASOURCE

Once the replication is done successfully, a message pops up at left hand corner status bar as shown in the below screen

A. BW ON HANA DATA MODELLING

1. Data Flow

Once the replication is performed successfully

Go to /NRSA1 (Data Modeling Screen)

It displays Data Warehousing Workbench screen

INFOPROVIDER ---> INFOCUBE ---> Create dataflow for load from newly replicated Data source

INFOPROVIDER ---> Right click INFOCUBE ---> MANAGE

INFOCUBE CONTENT ---à Check for data in INFOCUBE is relevant

A. REPORTING ON BEX

To Create BeX Query

Type /NRRMX

An Excel sheet will get displayed

Go on the Add-Ins Tab

NOTE : BEx Analyzer is an analytical reporting and design tool

BeX ANAYLZER ---> TOOLS ---> CREATE NEW QUERY

BEx Designer will get opened

Click QUERY ---> NEW

NOTE : BEx Designer is used to analyze the data set of the BI system by defining queries for Info provider.

Select the Info Area where the Info Provider is prepared on which the Query has to be build.

In this case, SALES OVERVIEW is Info cube. Click OPEN

In this document we are preparing a BeX Query on Sales Data.

Drag and Drop the required dimensions and key figures from left panel to the middle panel of rows and columns respectively.

NOTE: AVG_SUB is a calculated key figure as ( (Subtotal 1+Subtotal 2)/2)

Once the columns and rows are selected.

Go to properties tab on right side panel and select the Query_Name.

Select the Extended tab and check all the check boxes under this tab

NOTE : This will create a .mdx file , which will be then used to call in the BO reporting tools. Multidimensional Expressions (MDX) is a query language for OLAP databases.

Once the Query is created and saved

Click BeX ANALYZER ---> OPEN QUERY

Select QUERY_NAME ---> OPEN

In this case, Material sales overview query is query used.

The Query output will get displayed.

A. REPORTING ON WEBI

We call the same BeX Query in Web Intelligence Tool. This tool allows analysis on BEx query.

Go to START ---> All Programs-->SAP Business Intelligence--> SAP Business Objects BI Platform 4 Client Tools --> WEB INTELLIGENCE RICH CLIENT

Go to Web Intelligence --> Login as

Provide with relevant User ID and Password --> Log On

Click on

Select BEX --> OK

Click BW7.4 --> INFOAREA

BW7.4 is the already existing connection wherein we connect to BW system.

Info area are the same which were created in BW System.

NOTE: BW 7.4 connection is already done, if the connection is not visible, please contact the administration team

Select the appropriate Query --> OK

Here we have selected Material sales overview query

Once the Query is selected, a Query panel window is popped up, where the required dimensions and the measures (key figures) can be selected from right side panel to the Result Objects window.

Drag and drop required dimensions or measures to Result object. We can also apply filters by dragging to Query Filters.

Before executing the query, we can preview the data content in the Data Preview tab by clicking on refresh button.

Once the Data is properly previewed, click on Run Query to generate a Report

eSolutions Blog

Tuesday, September 29, 2015

How to Install SAP Hana SP10 on a Linux Red Hat 6.6.