SAP BW 7.4 Training with Real time consultant ,scenarios based and Project Explanation

Topics Covered

Unit 1: Introduction Evolution of HANA Landscape SAP HANA Basics SAP NetWeaver BW 7.4 Unit 2: SAP HANA and Business Strategy 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 Unit 3: SAP HANA Architecture InMemory Computing (Row Store, Column Store, Persistency Layer, Architectural Concept) HANA based Real-time Operational Analytics HANA based Agile Data Marts for Rapid Prototyping with Analytic Models New Modelling Paradigm in order to provide agility and flexibility from business question to report Unit 4: HANA-optimized DataStore Object and InfoCube HANA-Optimized DataStore Object HANA-Optimized InfoCube Semantically Partitioned Object Unit 5: SAP HANA modeling Purpose of Information Modeler Levels of Modeling in SAP HANA Attribute Views Analytic Views Calculation Views Export & Import Unit 6: MODELING of SAP BW 7.4 with SAP HANA Models in SAP BW 7.4 Data Extraction and Data Flow within SAP BW 7.4 NW 2004S New Data source Concept of BW 7.4 Transformation in BW 7.4(ETL) DTP (Data Transfer Process) FROM 3.X TO BW 7.4 Business Content UPGRADING DATAFLOWS Administration of InfoCubes and Aggregates DSO (DATA STORE OBJECTS) Virtual Cubes and Multi Providers Main Project:The student will work on 5 Data Flows provided by the Instructor. Unit 7: Consuming HANA Models in BW Virtual Provider Transient Provider Composite Provider DB Connect Importing SAP BW models in SAP HANA Importing HANA optimize infocubes Importing HANA optimize DSO Unit 8: DATA EXTRACTIONS (ETL) ECC Extractions Using BI BW 7.4 Dataflow Overview of ECC6.0 Extractions. Generic Extractions Business Content Extractions CO-PA Extractions (COST PROFITABLE ANALYSIS) LO-COCK PIT Extractions (LOGISTICS) FI-SL Extractions (Financial special purpose ledger) SAP CRM Extractions Delta Management Extracting Master Data from CC (Attributes, Text, Hierarchies) Data source Enhancement Process Chains in Detail covering all process Types Upgrading process Chains from 3.x to BW 7.4 APDS (Analysis Process Designers) New Enhancement of SAP BW 7.3,7.4 Unit 9: REPORTING Introduction to BI Enterprise Reporting Navigating in Reports First Steps in Query Designer Key Figures CHARACTERSTICS Attributes Exceptions and Conditions Unit 10: Transporting Objects (CTO) NEW ENHANCEMENTS OF SAP BW 7.3, 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 UNIT 5: Data Transfer Process (DTP) UNIT 6: Open Hub Service UNIT 7: Transformation UNIT 8: SAP BODS (New ETL Tool of SAP) Integration Project 1. Main Project 2. Order Fill Rate project (SAP SD) 3. COPA Project 4. Material movement project 5. Procurement Dataflow project Attendees also learn: 1. Resume Preparation Guidelines and Tips 2. Mock Interviews and Interview Preparation Tips Topics Covered I. MODELING Unit 1: The Multi-dimensional Model in SAP BW The SAP BW Star Schema Concept Data warehousing Workbench (DWB) Info Objects Info Cubes Unit 2: Data Extraction and Data Flow within SAP BW 7.4 NW 2004S 3.x Dataflow Overview of BW 7.4 Dataflow Comparison of 3.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 7.4 Datasource Lifecycle with In BW 7.4 NW 2004S Migration of 3.x data source to BW 7.4 data source Unit 4: Transformation in BW 7.4(ETL) In depth coverage of Transformation Routines in Transformations (Start routine, End routine, Expert routine, transformation routine) with different Real Time examples Transformation Groups Unit and currency Conversions 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 BI Accelerators Unit 9: DSO (DATA STORE OBJECTS) Data Store Objects concept Unit 10: Virtual Cubes and Multi Providers Virtual Cubes Multi Providers Mini project: The student has to work on 5 dataflows given by the Instructor. II. DATA EXTRACTIONS (ETL) ECC extractions using BW 7.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 sets. Functional Module. Unit 3: Business Content Extractions Overview of Business Content Extractions. Examples from Financial, Logistics, HRMS modules. Unit 4: CO-PA Extractions (COST PROFITABLE ANALYSIS) Unit 5: LO-COCK PIT Extractions (LOGISTICS) Unit 6: FI-SL Extractions (Financial special purpose ledger) SAP CRM extractions. Marketing Extractions CRM SALES Extractions CRM SERVICE Extractions (CRM Extractions are Very High in demand) 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 Real time examples on process Chains (Meta Chains) Unit 11: Upgrading process Chains from 3.x to BI 7.3 Unit 12: APDS (Analysis Process Designers) III. REPORTING Unit 1: Introduction to BI Enterprise Reporting. The SAP BI Overview 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 Structures and cells Unit 5: CHARACTERSTICS Properties and Attributes of Characteristics Integrating attributes and hierarchies in reports. Unit 6: Attributes Characteristic Variables Hierarchy variables Hierarchy Node variables Formula Variables Text variables Variable Processing types. Unit 7: Exceptions and Conditions. Exceptions Conditions ADVANCED REPORTING Topics Unit 8: RRI (report to report interface) Unit 9: Bex Analyzer Unit 10: Transporting Objects (CTO) Mini project: will be given to the students once they finished the course. 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 Option to only load the last request from a given source (available for full load DTPs) Data Transfer Process supports referential integrity checks tor 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 for export even into a non-SAP specific format Hierarchy extraction supported by Open Hub UNIT 7: Transformation Semantic grouping possible in Transformations (in addition to semantic grouping in DTPs) Possibility to select the Info Objects (fields) the user wants to use in a Start- / End routine Currency and unit conversion for Data Store object and Info Source as target of a Transformation. Navigation attributes of Info Cubes/Data Store objects can be used as source fields in the Transformation and as filter/select options in the DTP Automated generation of a proposal by mapping fields of the Data Source to Info Objects UNIT 8: SAP BODS (New ETL Tool of SAP) Integration

Who should attend

Dataware house knowledge

Pre-requisites

Dataware house knowledge

What you need to bring

Mic headset and proper internet

Key Takeaways

SAP BW modelling Extraction and Reporting