- SAP HANA
- Features of SAP HANA
- Advantages and Disadvantages of SAP HANA
- SAP HANA Architecture
- SAP HANA Use Cases
- SAP Hana Installation
- SAP Hana Studio
- SAP HANA Studio Administration Console
- How to Use SAP HANA System Monitor
- How to Use SAP HANA on Azure
- SAP HANA Modeling – Attributes, Measures, Privileges, Modeling Objects
- Data Warehousing in SAP HANA – Components, Methods, Working & Benefits
- SAP HANA Attribute View – Create Attribute View in 9 Easy Steps
- SAP HANA Analytic View
- SAP HANA Calculation View
- Tables in SAP HANA
- SAP HANA Packages
- Schema in SAP HANA
- How to Create Analytic Privileges in SAP HANA
- SAP HANA Information Composer
- Import and Export in SAP HANA
- Major Components of SAP HANA
- Reporting in SAP HANA
- SAP Bussiness Objects Reporting Tool
- create relational connection in sap hana in 8 steps/
- steps to create olap connection in sap hana/
- How to Connect SAP Lumira with SAP HANA
- Connect Dashboard Designer to SAP HANA & Create Stunning Dashboards
- How to Connect Web Intelligence to SAP HANA in 4 Ways – Seamless Process
- Replication Modes and Types in SAP HANA
- SAP HANA Sidecar Scenario
- SAP HANA Security Guide
- SAP HANA License Management
- Difference between SAP HANA vs SAP S/4 HANA
- What is SAP S/4 HANA?
- S/4HANA Editions
- SAP S/4HANA Lines of Business
- >SAP S/4HANA Deployment Options
- >SAP S/4HANA Overview
- >Introduction of SAP ABAP
- >Overview of SAP ABAP
- >SAP R3 ARCHITECTURE
- >SAP Data Dictionary
- >SAP ABAB Views
- >SAP ABAB database Tables
- >ABAP Constants & Literals
- >ABAP Constants & Literals
- >Types of Tables in SAP
- >Sap Data Object
- >Internal Tables and Work areas
- >Internal Table Operations in SAP ABAP
- >ABAP Report uses Internal tables and Work Areas
- >Select single and Select up to 1 rows
- >Modularization Techniques
- >Techniques of debugging
- >Types Subroutines
- >Reports of Sap Abap
- >Using At Selection Screen Output
- >Select Statements
- >Function Modules
- >Modularization Techniques 2/
- >Subroutines In Sap Abap/
- >Report Of Sap Abap 2
- >Using At Selection Screen Output 2
- >Interactive Reports
- >Interactive Reports Development
- >Interactive Report Using Hide Technique
- >Interactive Report Using Get Cursor Technique
- >Tree List Report
- >Abap Alv Reports/
- >Sap scripts/
- >Purchase Order SAP Script/
- >SAP Smartforms/
- >What is BDC in SAP ? Types of BDC ?/
- >BDC Call transaction for Material Master MM01/
- >SD flow with T-Codes and tables/
- >Introduction to module pool programming in SAP/
- >Functional Specification/
- >ASAP methodology SAP
- >ABAP Development end to end process in Companies
- >SAP SD Sales and Distribution
- Accounting Entries in SAP FICO
- Define Company in SAP
- Creating new companies
- Assign Company Code
- Business Area
- Functional Area
- Credit Control Area in SAP
- Financial Management in SAP
- Segments in SAP
- SAP Enterprise Structure
- General Ledger Accounting
- Fiscal Year Variant in sap
- Posting Period Variants in SAP
- Posting Period Variant to Company Code
- How to Assign company code to field status variants in SAP
- Posting Keys in SAP
- Tolerance Group for Employees in SAP
- Tolerance Groups For G/L Accounts
- Assign Users to Tolerance Groups in SAP
- Enter Global Parameters for Company Code OBY6
- Define Additional Local Currencies for Company code in SAP System
- Chart of Accounts in FICO
- Assign Company Code to Chart of Accounts in SAP
- How to Create G/L Account Group in SAP
- Define Sample Account Rule Types in SAP
- Data Transfer Rules
- Convolutional and recurrent neural network
- Assign company code to rule type in sap
- Create sample account in sap
- Accounting entries in sap fico sap accounting postings
- Financial statement versions in sap
- TAX Check Calculation Procedure in SAP
- Define New Condition types for Taxes
- How to Assign Country to Calculation Procedure
- Specify Structure for Tax jurisdiction code
- How to Create tax codes in SAP – FTXP "FI"
- Assign Tax Codes for Non-Taxable Transactions in SAP FI
- Define Tax Calculation Procedure for GST in SAP"FI"
- Assign Tax Calculation Procedure to Country in SAP for GST"FI"
- Define Access Sequence in SAP for GST"FI"
- Define Condition Types in SAP for GST"FI"
- How to create customer account groups in sap
- How to create number ranges for customer accounts
- Assign number ranges to customer account groups
- How to Assign Number Ranges to Vendor Account Groups in SAP F1
- How to Create Sundry Creditors GL Account in SAP FI
- How to Define Tolerance group for vendors /Customers
- How to Create Vendor Master Data
- Automatic Payment Program Configuration Steps SAP FI
- Create Vendor Account Groups in SAP
- How to Create Number Ranges for Vendor Accounts in SAP
- Maintain terms of payment SAP
- How to Create Customer master data by XD01
- How to Define Dunning Procedures in SAP
- Copy Reference Chart of Depreciation in SAP
- Assign Chart of Depreciation to Company code in SAP
- Specify account determination asset accountng
- How to create screen layout rules asset accounting
- SAP FI: Create Screen Layout Rules
- SAP FI: Maintain Asset Number Ranges – AS08
- Create Investment Program Types in SAP
- Investment profiles
- How to Investment Program Types to Operative objects in SAP
Data Warehousing in SAP HANA – Components, Methods, Working & Benefits
Data warehouses are efficient analytical data storage systems holding data in multi-dimensional models and schemas making it easy for users to carry out analytical and reporting operations on it.
What is Data Warehousing?
A simple answer to this is, Data warehousing is a technique or system that collects transformed data from either or both homogenous and heterogeneous data sources and transfers into a single data store.It provides the data to the analytical tools. The data warehouses are known to be the central repositories of a business intelligence system.
Both real-time and historic (pre-existing) data can set the data warehouses collected from either the enterprise’s operational sources or an external data source. As we know, the traditional databases keep transactional data which is one-dimensional data. And, it cannot be used for analytical and reporting purposes, such databases are called OLTP (Online Transactional Processing) database. But the data warehouses are OLAP type databases which provide processed data for analytical operations like data mining, OLAP analysis, reporting etc.
A data warehouse typically contains metadata, raw data and summary data which is used by analytic tools for reporting, planning, and forecasting.
Next, in the SAP HANA Data Warehousing tutorial, we will discuss the components of Data Warehouse Architecture.
Components of Data Warehouse Architecture
A typical data warehousing architecture in SAP HANA consists of four parts, data sources, staging zone for ETL processing, data types in warehouse and presentation or data access part.
- The data sources consist of the ERP system, CRM systems or financial applications, flat files, operational systems.
- The staging area is where ETL (Extract, Transform and Load) operations performs on the data taken from the various data sources. Data from all kinds of data sources are brought to a single staging area where ETL performs. In ETL, data first extracts from the data source. Then cleans and transforms as per user requirements and loads into the data warehouses so that users can use it for analysis.
- Data warehouses primarily contain metadata, which is, data about data. Whereas, the summary data is the transformed and processes data ready for analysis and reporting.
- Lastly, in the presentation layer, users can perform OLAP operations on the data taken from the data warehouses and use it for data mining, reporting, and analysis. Analytical operations perform on such data to understand the messages in raw transactional data. Understanding the data helps in making informed business decisions.
Now, in SAP HANA Data Warehousing tutorial, we will further move on to Designing Methods in Data Warehousing.
Designing Methods in Data Warehousing
Before using data in analytical tools, users need to design and create data models. It will serve as a blueprint during the execution process. Generally, the user performs three designing methods in Data Warehousing:
It is a top-down approach where the process flow is such that data is taken from the data source, undergoes ETL in the staging area, gets integrated into a normalized (3NF) data model. From here, data loads into the data warehouse. The users create data marts from the data warehouses which creates before them.
On the contrary, Kimball’s method follows the bottom-up approach. The process flow of this model is such that users take data from the operational or third-party data sources, undergoes ETL, then models into a star schema structure. After this, users create data marts in which data that models as schemas get loads. Finally, these data marts integrate to form a single enterprise data warehouse.
The hybrid design uses both the techniques together to design the data models. By doing so, a user gets the speed of the bottom-up approach and integration capabilities of the top-down approach.
Moving further in SAP HANA Data Warehousing tutorial, now, we will learn the working of Data Warehousing in SAP HANA.
Working of SAP HANA Data Warehousing
The data warehousing works in a similar fashion in SAP HANA as well. Transactional data from different SAP and non-SAP data sources comes to SAP HANA data warehouse and clients use them as per the data models and logics that the user defines.
SAP HANA has a data warehouse solution known as SAP BW/4HANA. This business warehousing solution runs on a NetWeaver based ABAP platform. It is a model-based solution where a user designs a data warehouse model and data flow on the basis of which data retrieves from the original data source. Users can create multi-dimensional data models in SAP Business Warehouse. Users mainly use it for OLAP operations.
Benefits of SAP HANA Data Warehousing
Data warehousing solution in SAP HANA has several benefits:
- Instantly access real-time or historical data from SAP or non-SAP data sources. It accesses data to carry out real-time analysis and business insights either on-premise or on-cloud.
- It offers high-volume and real-time data processing.
- Utilize the most of this tool by the virtue of a Big Data warehouse. It allows complete capitalization on your data.
- You can develop the application according to your requirements and use processed data from the data warehouse. Conduct advanced analytics and integrate with machine learning capabilities.