Data Ware Housing, Sap BW, BO, Sap Hana

German Football Team Red Bull Kolkata Knight Riders Formula1 using Sap HANA Predictive Analysis Customer Success Stories By Choosing SAP HANA Kolkata Knight Riders have won IPL and Germany Football team as well

Ø   Simplicity - Fewer layers, lower cost Ø   Faster data loads - Faster data activation in DSOs and faster data loads to Info Cubes Ø   In Memory planning - In-Memory planning engine enables faster planning cycles Ø   Agility - Faster structural changes- agility for business users Ø   Query performance - Excellent query performance on all DB objects without additional efforts Ø   Data volume reduction - Smart compression logic of data leads to significant reduction of space required to store data Ø   Analysis - Unlock new insights with predictive, complex analysis Ø   Manage massive data volume at high speed               Response times with 40 million records in hana optimized infocube: 45 seconds with 25 times             faster Compared to leagacyDBMS

Skills required to become an SAP HANA Developer?    Ø   Database knowledge(OLTP /OLAP) and good knowledge on SQL.    Ø   Designing Data Models- prior ETL experience will be added advantage.    Ø   Knowledge of SAP ERP & Analytics .    Ø   Apart from above skills learn SQL Script, Stored Procedures, Triggers.             If you are interested in programming OR Coding then learn Java script, HTML 5. Following are the skills required to bag a HANA Modeller Job                   Attribute Views, Analytical Views, Calculation Views, Scripted procedures                   Design and Implement security models based on ECC requirements            HANA Modeller must have an prior experience on data modelling concepts      ...

Native and Non-Native SAP HANA Application Architecture Non-native SAP HANA Application Architecture

SAP HANA DATABASE ARCHITECTURE Ø   It is more than a DB-it's a true platform Ø   Converged OLTP + OLAP Ø   It supports Transactions, analytics, predictive, spatial processing transformed for real-time business operations, etc. Ø   It supports any application, I mean .Net, java, ABAP, PHP developers can make hana as their db by replacing their existing db Ø   It is http-based UI, no External app server Ø   UI rendering is completely in the client side Ø   Server-side procedural logic in JavaScript Ø   60% of SAP HANA use cases are outside the SAP landscape

E.g.: If you want to select country as JP and product is Alpha then traditional db with row store will read all the rows  one by one and reach our query what we want. but with column store it won't read all the rows in sequence manner instead it selects the particular column. by this way we will get our result faster with in less time. Why data comes faster from RAM?    Take an example if you play songs from your hard drive it takes less time instead of playing songs from DVD drive , external disks or pen drive, because it takes time to read from disk . If data present in RAM then we will access to reports within seconds by columnar hana db and calculations can be done on fly.

It is the Combination of Multi-Core Parallelism ,  Data locality in memory & Columnar Structures Columnar database has unique advantages: Improves Analytic Performance Multicore Processing Larger availability of DRAM Hana supports both Row and Column stores                Hana is not completely a new technology.Rethought and Re factored everything on Hana platform,when i first heard about hana i thought it is a database like oracle, microsoft sql server...but it is more than a database.It becomes a Platform which makes me surprising because when i know about hana people used to talk about memory and Sql, now programmers can write code, data warehousing and modelling consultants can model and run reports faster and the people who has knowledge on sql can learn easily, etc.There are so many things which can be done in HANA PLATFORM...Decide Yourself and move on different paths in HANA.. only limitation is our IMAGINATION...    ...

              SAP HANA is an in-memory data platform that is deployable as an on-premise appliance, or in the cloud. It is a revolutionary platform that's best suited for performing real-time analytics, and developing and deploying real-time applications.               HANA also includes a programming component that allows a company's IT department to create and run customized application programs on top of HANA, as well as a suite of predictive, spatial and text analytics libraries across multiple data sources. Because HANA can run in parallel to a source SAP ERP application, analysts can access real-time operational and transactional data and not have to wait for a daily or weekly report to run. All databases stores and retrieves the data from DISK..but HANA Database stores and retrieves the data faster from RAM instead of Disk..so execution and retrieved time is more faster than other databases