SAP Course Overview
JOYATRES Online Training Institute is one of the best training institute in leading IT online training. We provide best SAP BW on Hana online training with our highly professional real time trainers. SAP BW on HANA is the next wave of SAP’s in-memory technology vision that enables SAP NetWeaver BW to use SAP Hana as a fully functioning in-memory database. Running SAP BW on Hana results in dramatically improved performance, simplified administration and streamlined IT landscape resulting in lowering total cost of ownership. KITS also do corporate training and help them to train their employees. We also provide other related courses.
NEW ENHANCEMENTS OF SAP BW 7.3, 7.4
UNIT 1: Hybrid provider
UNIT 2: Generic delta functionalities for further types of Data Sources
UNIT 3: Hierarchies
UNIT 4:Data Transfer Process (DTP)
UNIT 5: Open Hub Service
UNIT 6: Transformation
UNIT 7: SAP BODS (New ETL Tool of SAP) Integration
Topics Covered MODELING
Unit 1: The Multi-dimensional Model in SAP BW
- The SAP BW Star Schema Concept
- Data warehousing Workbench (DWB)
- Info Objects
- Info Cubes
Unit2:DataExtractionand DataFlowwithinSAPBW7.4 NW 2004S
- x Dataflow
- Overview of BW 4 Dataflow
- Comparison of x and BW 7.34 Data flows
- Loading Master Data(Attributes, Texts, Hierarchies)
- Loading Transaction Data
Unit 3: New Data source Concept of BW 7.4
- Overview of new Datasource
- Emulation of Data source in BW 4
- Datasource Lifecycle with In BW 4 NW 2004S
- Migration of x data source to BW 7.4 data source
Unit 4: Transformation in BW 7.4(ETL)
- Transformation
Unit 5: DTP (Data Transfer Process)
- Overview of DTPS
- Trouble shooting techniques in DTPS
- Debugging ABAP routines Using DTPS
Unit 6: UPGRADING DATAFLOWS FROM 3.X TO BW 7.4
Unit 7: Business Content
- Business Content (BCT)
Unit 8: Administration of InfoCubes and Aggregates
- Managing Basic Cubes
- Aggregates
Unit 9: DSO (DATA STORE OBJECTS)
- Data Store Objects concept
Unit 10: Virtual Cubes and Multi Providers
- Virtual Cubes
- Multi Providers
- DATA EXTRACTIONS (ETL)
- ECC extractions using BW 4 Data flows
Unit 1: Overview of ECC6.0 Extractions
- Types of ECC extractions
Unit 2: Generic Extractions.
- Generic Extraction using
- Database Table
- View
- Classical Info
- Functional
Unit 3: Business Content Extractions
- Overview of Business Content
- Examples from Financial, Logistics, HRMS
Unit 4: CO-PA Extractions (COST PROFITABLE ANALYSIS)
Unit 5: LO-COCK PIT Extractions (LOGISTICS)
Unit 7: Delta Management
Unit 8: Extracting Master Data from CC (Attributes, Text, Hierarchies)
Unit 9: Datasource Enhancement
Unit 10: Process Chains in Detail covering all process Types
- Realtimeexamplesonprocess Chains(Meta Chains)
- REPORTING
Unit 1: Introduction to BI Enterprise Reporting.
- The SAP BIOverview
Unit 2: Navigating in Reports
Unit 3: First Steps in Query Designer
- Query Designer
- Info providers in query Designer
Unit 4: Key Figures
- Restricted Key Figures
- Calculated Key Figures
- Properties of Key Figures
Unit 5: CHARACTERSTICS
- Properties and Attributes of Characteristics
Unit 6: Exceptions and Conditions
- Exceptions
- Conditions
Unit 7: Bex Analyzer
Unit 8: Transporting Objects (CTO)
NEW ENHANCEMENTS OF SAP BW 7.4
UNIT 1: Hybrid provider
UNIT 2: New monitors in BW Administration cockpit
UNIT 3: Generic delta functionalities for further types of Data Sources
UNIT 4: Hierarchies
- Integration of hierarchies into process flow (DTP, Transformation)
- Remote hierarchies for direct access to hierarchies in the source system
- Loading hierarchies from flat file using the new Data Source and Transformation technology
UNIT 5: Data Transfer Process (DTP)
- Data Transfer Process supports data extraction from Multi Providers
- Optiontoonlyloadthelastrequestfromagiven source (available for full load DTPs)
- Data Transfer Process supports referential integrity checkstor navigational attributes of the target
- Enhanced load performance by possibility to Re- package small data packages within a request to bigger packages
UNIT 6: Open Hub Service
- SAP Net Weaver BW data can be exported in XML format
- Possibility to change the format and length of BW data forexport even intoanon-SAPspecificformat
- Hierarchy extraction supported by Open Hub
UNIT7: SAPBODS(NewETLToolof SAP) Integration
Highlights of SAP BW HANA Online training:-
* Very in depth course material with Real Time Scenarios for each topic with its Solutions for SAP BW HANA Online Trainings.
* We Also provide Case studies for SAP BW HANA Online Training.
* We do Schedule the sessions based upon your comfort by our Highly Qualified Trainers and Real time Experts.
* We provide you with your recorded session for further Reference.
* We also provide Normal Track, Fast Track and Weekend Batches also for SAP BW HANA Online Training.
* We also provide Cost Effective and Flexible Payment Schemes.
What is SAP BW on HANA?
SAP BW on HANA is nothing but SAP’s existing NetWeaver BW data
warehouse, running on SAP HANA.
SAP now supports SAP HANA as the underlying database for the NetWeaver BW Data
Warehouse.

Because SAP HANA is much faster than regular relational databases
like Oracle or Microsoft SQL Server, the data warehouse performs much faster.
The purpose of SAP BW on HANA is to combine the power of both.

What are the drawbacks of SAP BW on a RDBMS like Oracle?
Time to change:
Any change in structure or report takes too much time. Normally it takes 3-12 months to get a change in structure or report.
Flexibility:
It lacks the granular level details. In SAP BW data is aggregated and materialized so users can’t get the way they need or at the granularity they require.
Performance:
Every report has to be tuned for acceptable performance.
Real time data not available:
Real time data are not available for analysis. Data is moved to SAP BW in batches and takes time.
SAP BW on HANA Benefits:
SAP BW on HANA is smarter, simpler and more efficient.

Customer value of SAP BW on HANA:
- Excellent query performance for improved decision making
- Performance boost for Data Load processes for decreased data latency
- Accelerated In-Memory planning capabilities for faster planning scenarios
- Flexible – combine EDW with HANA-native data for real-time insights and decision making
- Data persistency layers are cut off and reduced administration efforts
- Simplified data modeling and remodeling

Faster decision-making – Having the right information when you need it
In today’s business world, fast access and manipulation is required on top of massive data stores. This is beyond the capabilities of traditional disk-based systems.
SAP HANA helps your SAP NetWeaver Business Warehouse run better than ever. HANA enables you to analyze large amounts of data, from virtually any source, in near real time, making it possible to access reports with up-to-the-minute information. As an example, having the most current order and logistics information makes it possible to manage your inventory more efficiently, and to predict Available to Promise (ATP) more accurately.
Lower Total Cost of Ownership (TCO):
When you take into account the cost of hardware, software licenses, maintenance, performance tuning and project development, SAP BW is always cheaper in terms of TCO when running on HANA.
Whether HANA also is cheaper in terms of Total Cost of Acquisition (TCA) depends on where you are in your procurement lifecycle. Do you have to replace hardware anyhow? Can you free up resources on expensive UNIX equipment? Can you reuse the Oracle or DB2 licenses elsewhere or save on maintenance revenue? Do you have to complete a SAP system upgrade as well? Do you save substantially on storage costs? Many times, the answer is yes! Simplified configuration and operational management:
Non-disruptive innovation and advanced administrative tools.
The current business processes inside BW can stay as they are and will mesh perfectly with HANA. System operation stays as it is, and process chains do not need to be remodeled.
With HANA there is no need to retrain end users familiar with BW. There is still the same BW application process but, with BW on SAP HANA, it is now possible to run queries, updates and reports much faster than before. Expert users do not need to get retrained because they can continue to use their current BI or other frontend tools.
In addition, HANA supports the BW Analysis Authorization Concept, and can be integrated with NetWeaver Identity Management to ensure security remains intact.
What Are The Prerequisites To Learn SAP BW on Hana?
1. Candidates should have basic knowledge of data warehousing concepts
along with
excellent business knowledge on different application areas.
2. Experience in the ABAP language will be an added advantage.
Scheduling Demo With Trainer:
If you would like to take the online demo for sap bw on hana trainer can you please make an inquiry or fill the form for demo registration, one of our executives will arrange a meeting with the expert trainer.
Course Finished Certificate :
After finish, the course we provide sap bw on hana course finished certificate of kits technologies looks like
SAP Course Curriculum
- Evolution of HANA Landscape
- SAP HANA Basics
- SAP NetWeaver BW 4
- Identifying Transformational Opportunities
- Understanding Your Needs, Enterprise Needs, Data Needs
- Working with Existing Solutions: SAP HANA versus SAP NetWeaver BWA
- Does SAP HANA Replace BWA?
- Pros and Cons of BWA
- Pros and Cons of SAP HANA
- HANA-Optimized DataStore Object
- HANA-Optimized InfoCube
- Semantically Partitioned Object
- Purpose of Information Modeler
- Levels ofModeling in SAP HANA
- Attribute Views
- Analytic Views
- Calculation Views
- Export & Import
- Models in SAP BW 4
- Data Extraction and Data Flow within SAP BW 4 NW 2004S
- New Data source Concept of BW 4
- Transformation in BW 4(ETL)
- DTP (Data TransferProcess)
- FROM X TO BW 7.4
- Business Content UPGRADING DATAFLOWS
- Administration of InfoCubes and Aggregates
- DSO (DATA STORE OBJECTS
- Virtual Cubes and Multi Providers
- Virtual Provider
- Transient Provider
- Composite Provider
- DB Connect
- Importing SAP BW models in SAP HANA
- Importing HANA optimize infocubes
- Importing HANA optimize DSO Unit 7: DATA EXTRACTIONS (ETL)
- ECC Extractions Using BI BW 4 Dataflow
- Overview of 0 Extractions.
- Generic Extractions
- Business Content Extractions
- CO-PA Extractions (COST PROFITABLE ANALYSIS)
- LO-COCK PIT Extractions (LOGISTICS) Unit 8: REPORTING
- Introduction to BI Enterprise Reporting
- Navigating in Reports
- First Steps in Query Designer
- Key Figures
- CHARACTERSTICS
- Attributes
- Exceptions and Conditions Unit 09: Transporting Objects (CTO)