Sap bi/bw, hana & business objects of hana hana is used as a database to improv - Pune

SAP BI/BW, HANA & BUSINESS OBJECTS of HANA

HANA is used as a DATABASE to improve the performance of the reports or fasten the data access of the company's Existing Business Warehouse tool. So, for a HANA consultant, It is must to understand the reporting as well as the BW concepts. The Combination of BW, Hana & Business Objects (Reporting) will make you familiar with all the skills that you require to work independently and also the skills that any Industry look for.
At the end of the course, we will be working on 2 LIVE SCENARIOS i.e BW on HANA & ABAP on HANA to understand the system much better.
Introduction
oHistory and Fundamentals of Data-warehousing in Depth.
oStar Schema And Extended Star Schema Techniques.
oClear picture on OLTP and OLAP systems.
SAP ABAP
oIntroduction to SAP-ABAP
oABAP programming Basics & Fundamentals of DDIC
oUnderstanding the ABAP Function modules and BAPIs
oCreating RFC Destinations & Remote Function Calls
SAP BW
oIntroduction to SAP BW
oInfoObjects
oNon-Cumulative Key figures
oNavigational Attributes
oMaster data Load ( Attributes, Texts and Hierarchies)
oInfoCubes & DSOs
oInfosets, Multi Providers & Virtual Providers
oGeneric Extraction ( Using DB Views & Function Modules)
oGeneric Delta
oLOC Extraction
oClear insight on V1, V2 & V3 Updates
oDelta Queue Monitoring
oDatasource Enhancement using BADI and User Exits
oJob Scheduling In Detail & Job monitoring in ECC
oJob Triggering Techniques
oProcess Chain Creation
oScheduling & Monitoring Process Chains
oError Handling in Process Chains
oCompression & Aggregation
oBEx Query Designer
oCalculated & Restricted Key Figures
oFormulas , Variables & Exceptions
oFilters and Conditions
oBEx Analyzer & BEx Web analyzer.
oBEx reporting In depth.
oRoles & Authorizations
Introduction to SAP HANA
oSAP In-Memory Strategy
oHANA compare to BW
oArchitecture
oArchitecture Overview
oIMCE and Surroundings (In memory Computing Engine)
oRow Store & Column Store
oInstallation and deployment scenarios
Navigation
oIntroduction to HANA Studio
oHANA Administration Prospective
oModeler Prospective
oSystem monitoring.
LT (Landscape Transformation) OR Trigger Based Replication
oRemote Function Calls
oCreating RFC Destinations in SAP ABAP
oReplicating SAP tables from OLTP Server using Trigger based Replication
oReal time Replication
oJob Scheduling and monitoring.
oParallel and Multi-Thread processing.
SQL Scripts
oData Types
oTable Creation, Modification, Updating and Deletion operations.
oSQL Select Statements
oJoins and Unions
oString Operations
oStored procedures
oCE (Calculation Engine) Functions.
oAggregations and lot more.
Modelling
oApplying star schema technique in SAP HANA
oAttribute Views (Using Hierarchies and Joins in Attribute views in Depth)
oAnalytic Views (Using Aggregations)
oCalculation Views
oUsing Stored procedures in Calculation Views
oAggregations in Calculation Views
oHierarchies in Calculation Views.
oCalculation Engine Concepts in Depth.
HANA -ETL Replication Methodology
oBODS (Business Object Data services)
oJDBC & ODBC connectivity.
oReplicating data from SAP OLTP Server Using BODS
oReplicating data from Flat File Source systems
oReplicating data from BI System
oBackward replication technique.
Working with HANA on BW Platform
oBI and BODS connectivity
oData Extraction form SAP BW into Hana-Server using BODS
oReporting on BW Infocubes using Dashboards
Transformations using BODS
oMerge Transform
oPivot & Reverse Pivot Transformations
oSQL Transformation
oKey Generation Transform
oValidation Transform
oCase Transform
Business Objects CMC & Information Design Tool
oCreating Repository
oRelational Database & OLAP Connections
oWorking with Universes
oCreation of Project & Data Foundation to Build the Universe
oCreating Data Services Repository User
Xcelsius / SAP BO Dashboards
oConsuming BEx Query
oConsuming an Universe to Design a Dashboard
oWorking With TABs
oWorking with Workbook
oVisualizing the data in Charts
oUsing Selectors
SAP HANA Reporting Using MS Excel
oSAP HANA MDX Provider
oCreating ODBC Connection
oReporting Fundamentals
oUsing Filters and Hierarchies
oGraphical Reporting
oAdvanced Reporting Techniques.
Reporting Using Business Object Explorer 4.0
oCreating HANA Source Systems
oManaging Info-Spaces
oGeographical Reporting
oTime based reporting
oHierarchical Reporting
oConfiguring & Indexing the Views
oCreating Exploration Viewset
oCreating URLs for Web-based Reporting
oReporting with BOEx in Depth
Crystal Reports with SAP HANA
oCreating Relational Database Connection
oReporting on HANA tables
oReporting on HANA Views
oReporting on Stored Procedures
SAP BW ON HANA
oEnd – To –End implementation Scenario
oIntroduction to SAP HANA DXC (Direct Extractor Connection)
oHANA as a Source System Via DB connect
oConcept of HANA optimized DSOs
oHANA optimized InfoCubes
oMigrating DSOs & Info Cubes to HDB
oAuthorizations
oBackup and Recovery
SAP ABAP on HANA
oEnd – To – End Implementation Scenario
oThe ADBC connection
oCreating External Views on HANA
oWorking & consuming Stored procedures on ABAP
oSAP ABAP for HANA
oCreating Interfaces and & Proxy Classes to Communicate with SPs
oOptimizing ABAP reports Using HANA (Live Scenario)
•Software Development on SAP HANA
oSAP HANA XS engine
oDeploying Java Script based Application on HANA
oSAP HANA with Odata Services
oSAP HANA UI5 based Development
•HANA Administration
oCreating Users
oAssigning Roles
oAuthorizations
oBackup and Recovery