Business Warehouse (BW) is SAP’s data warehousing application; it uses an SAP NetWeaver application server, but can run on many different databases. Improvements come with each version of Courses for sap BW on HANA training, but a really big jump in functionality comes when SAP BW is installed on the SAP HANA database. Now, there are two flavors of SAP BW powered by SAP HANA: Courses for sap BW on HANA training powered by SAP HANA and SAP BW 7.5, edition for SAP HANA.
A person should have good experience in SAP BW with expert level knowledge of SAP BW on SAP HANA projects. He/she should have worked on projects involving SAP BW modeling with respect to SAP HANA using composite providers, Advance DSOs, ODP, LSA ++ and using BW objects exposed as HANA views
Course for SAP BW on HANA Details
|Batch Type||Online and Instructor Led Training|
Syllabus for SAP BW on HANA
SAP BW ON HANA COURSE OVERVIEW
- 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 a lower total cost of ownership.
- SAP BW on HANA is nothing but SAP’s Existing database for the NetWeaver BW Data Warehouse.
- Because SAP HAAN 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 HAAN is to combine the power of both.
SAP BW ON HANA BENEFITS
- Excellent query performance for improved decision making.
- Simplified data modeling and remodeling.
- Faster decision making – Having the right information when you need it.
- Lower total cost of ownership.
- Simplified configuration and operational management.
SAP BW ON HANA COURSE CONTENT
- OVERVIEW OF THE SAP BW IN HANA
- Module One: Enterprise Structure Introduction to ERP
- SAP, Data Warehouse Overview of BW, BI, Data Base.
- Overview of BW Architecture, Landscape Basic Modeling:
- Create a valid Schema Multi-Dimensional Model – The Star
- Schema (Classical Approach)
- Multi-Dimensional star schema in BW (Extended star Schema) The OLAP Concept
- Differences between OLAP and OLTP Business Modeling
- Info Object Catalogs
- Info Objects
- Info Area
- Application Component
- Info Source
- Data Source
- Transfer Rules
- Update Rules
- Transfer Structure
- Communication Structure
- Info Package
- Data Transfer Process
- Loading Transactional Data into BW info Cube Loading MD
- with TD into BW System BW and BI Comparisons Master
- data loading-new(BI) ETL process
- Info cube & Types Courses for sap BW on HANA training
- Standard Info cube and Loading with new ETL Process
- Generate Report with BI master and Transaction Data
- Manual Uploading of MD like Attributes, Text, Hierarchy
- Different Types of Attributes Transformations
RULE TYPES ROUTINES
- Start Routine
- End Routine
- Expert Routine
DTP (DATA TRANSFER PROCESS)
- Standard DTP
- Error DTP
- Direct Access DTP
- Real-time DTP
DSO (DATA STORE OBJECT)
- Standard DSO
- Write optimized DSO
- Direct update DSO
- APD (Analysis Process & Design)
- Update Methods
- Full updates
- Delta Updates
- Multi Providers
- Info set
- Virtual Providers
- Open-Hub Destination
- Data Marts
REPORTING – BUSINESS EXPLORER
- BEX Query designer
- BEX Report Designer
- Visual Composer
- Functional Overview of Bex Query
- Designer Reusable Query Elements
- Query Controls with Variables
- Calculated Key Figures
- Restricted Key Figures
- Variable Definition in Detail
- Characteristic values variables
- Text Variables
- Formula Variables
- Hierarchy Variable
- BEX Analyzer
- BEX WAD
- Reporting Drilldown
- Drill down to DSO from Info Cube (RRI)
- Copying Queries from Cubes
- Bex Analyzer Bex WAD Bex Report Designer
- Visual Composer Migration Objects from BW 3.x to BI 7.0
- Transportation Extraction
- Generic Data Extraction using MD/TD Tables
- COPA Extraction
- Business Content Extractions using MD/TD
- LO-COCKPIT Data Extraction
- Delta types for Generic Extraction
- LO Extraction
- ASAP methodology