itechmaticsLogo

Call +1.800.379.6552
18101 Von Karman Ave. 3rd Floor, Irvine CA-92612

Business Intelligence and Business Analytics

Business Intelligence Vs. Business Analytics

Business Intelligence is needed to run the business while Business Analytics are needed to change the business.

BI is focused on creating operational efficiency through access to the real time data that enable individuals to most effectively perform their job functions. BI also includes the analysis of historical data from multiple sources that enable informed decision making as well as problem identification and resolution.

Business Analytics relates to the exploration of historical data from many source systems through statistical analysis, quantitative analysis, data mining, predictive modelling and other technologies and techniques to identify trends and understand the information that can drive business change and support sustained successful business practices.

Enterprise data processing challenges and SAP HANA

The rapidly growing volume of data within organizations presents a great opportunity for companies to grow their business from robust data. Yet people, process and technology challenges often block the way the enterprises are computing Key performance Indicators. Barriers such as poor BI reporting performance, lack of adequate tools, limited platform capabilities to bring the information together and inaccurate or redundant data get in the way.

We offer deep experience in assessing and enabling organizations to leverage people, process and technology for gaining new insights from their data. To achieve more effective and efficient barrier removal, we offer expertise with in-memory computing from SAP, called HANA.

HANA is best suited for performing real-time analytics, and developing and deploying real-time applications. HANA’s architecture is designed to handle both high transaction rates and complex query processing on the same platform. This enables organizations to have better insights to drive more business and reduce costs.

The overall speed and performance of reporting was becoming problematic. A proof-of-concept project is underway with one business unit to validate the strategic roadmap that Itechmatics created and demonstrate business value via HANA.



SAP HANA on AWS


SAP HANA is an in-memory relational database management system that supports both OLTP and OLAP workloads simultaneously on the same platform.

The AWS cloud provides a suite of infrastructure services that enable you to deploy SAP HANA in a highly available, fault-tolerant, and affordable way.

By deploying this solution on the AWS cloud, you can take advantage of the functionality of SAP HANA along with the flexibility and security of AWS.

This Quick Start helps you rapidly deploy fully functional SAP HANA systems on the AWS cloud, following best practices from AWS and SAP.

The Quick Start ensures that Amazon Elastic Compute Cloud (Amazon EC2), Amazon Elastic Block Store (Amazon EBS), and the operating system (SUSE Linux Enterprise Server or Red Hat Enterprise Linux) are optimally configured to achieve the best performance for your SAP HANA system right out of the box.

SAP HANA High Availability on AWS

HANA Service Auto-Restart

HANA Service Auto-Restart is a fault recovery solution provided out of the box by SAP. SAP HANA has many configured services running all the time for various activities.

When any of these services is disabled due to a software failure or human error, the service is automatically restarted with the HANA Service Auto Restart watchdog function.

When the service is restarted, it loads all the necessary data back into memory and resumes its operation. Use on AWS – HANA Service Auto-Restart works the same way on AWS as it does on any other platform.

Host Auto-Failover

SAP HANA Host Auto-Failover is a fault recovery solution provided by SAP. To achieve high availability within a data center, you can add and configure standby nodes to take over in case one or more SAP HANA nodes become impaired or unavailable.

When an existing node fails, a standby node can automatically take over by gaining access to the persistent layer (data and log volumes) of the failed host. It does this either by using shared networked storage (NFS) or with any storage connector API.



Are you ready for SAP HANA ?
we’re here to help

Understanding the past(Business Intelligence) Vs the future(Business Analytics)

Business Intelligence is similar to looking in the rearview mirror and using historical data that is anywhere from one minute to many years old. Business Analytics is like looking into the future to see what is likely to happen. This is a very important distinction as both will provide you with different insights.

Business Drivers

- Customer Satisfaction, New Capabilities, Operational Efficiency, Cost Reduction and Revenue Generation.

Mapping business drivers to SAP HANA Value Drivers.

- Improved service efficiency through enterprise HANA platform

- New capabilities through predictive analysis on HANA.

- Operational efficiency through EPM/BPC on HANA

- Operational process cost reduction through BW on HANA

- Revenue generation through accelerated TPM.


Call us today to discover more about Business Analytics with SAP HANA.

SAP HANA Sizing


The most critical sizing, integration, and performance factors you must address when adopting SAP HANA.

Trends amongst hardware vendors for virtualization, cloud and hosted systems, including options, requirements, and costs associated with network, backup, and application servers.

How the SAP HANA database uses persistent storage to provide a fallback, and how fault tolerance, disaster recovery and high-availability can be set up for your SAP HANA implementation.



SAP HANA on IBM 3850 X6

SAP has introduced the idea of “production verified revisions” to provide in-depth testing of all service packs for SAP HANA.

SAP HANA Sizing options

There are several sizing options depending on the software components:

BW system for HANA

QuickSizer – New implementation only, not migrations

BW Automated Sizing Tool in the Migration Cockpit

Rule of Thumb

T-Shirt Sizing

Business Suite system for HANA

QuickSizer for Business Suite on HANA

Automated Sizing Tool

Vendor Tools

Standalone HANA System

Disk Sizing for HANA

Disk for persistence layer = 4 Memory

Disk for the log = 1 Memory

You need 4 memory x 710GB disk for the persistence layer and about 1 memory x 710GB for the logs.This equals around 3.5TB.

The persistence layer is the disk that keeps the system secure and provides for redundancy if there are any memory failures.

CPU Sizing for BW on HANA

The CPUs are based on the number of cores that you include.

CPU = 0.2 CPU cores per active user.If you have a single node with 8 x 18 cores, you will have 144 cores and can handle 720 active BW users on that hardware node, and quite a larger number of named users.

HANA Scenarios - Backup, Recovery and Monitoring


Supports synchronous backup between production system and backup storage Alerts can be setup to monitor whether backups are being done as expected.

Two primary methods of backing up:

Traditional File

BACKINT API for third-party vendors


There are 4 basepath options for traditional file backups in HANA

Basepath data backup – Standard backups to external mount point

Basepath data volumes – Permanent location for data volumes

Basepath log backup – External mount point for logs segment to be copied

Basepath log volumes – Permanent location for log volumes


IBM offers a backup management solution called Tivoli Storage Manager.

SAP provides a script in SAP Note 1651055 to help clean up log files.

Many backup features are now automated including removal of log segments after backup.

HANA Data and Files Backup

Monitoring SAP HANA

SAP HANA Monitoring tools

1. SAP HANA Studio- Administrator console : System Monitor and Administration

- Memory overview

- Resource Utilization

- Memory Allocation Statistics

2. SAP Solutions Manager

3. SAP Partners IBM Tivoli