sap bi/bw, hana & business objects of hana
hana isused as a database to improve the performance of the reports or fasten the dataaccess of the company's existing business warehousetool. so, for a hana consultant, it is must to understand thereporting as well as the bw concepts. the combination of bw,hana &business objects (reporting) will make you familiar with all the skills thatyou require to work independently and also the skills that any industrylook 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
- history and fundamentals of data-warehousing in depth.
- star schema and extended star schema techniques.
- clear picture on oltp and olap systems.
sap abap
- introduction to sap-abap
- abap programming basics & fundamentals of ddic
- understanding the abap function modules and bapis
- creating rfc destinations & remote function calls
sap bw
- introduction to sap bw
- infoobjects
- non-cumulative key figures
- navigational attributes
- master data load ( attributes, texts and hierarchies)
- infocubes & dsos
- infosets, multi providers & virtual providers
- generic extraction ( using db views & function modules)
- generic delta
- loc extraction
- clear insight on v1,v2 & v3 updates
- delta queue monitoring
- datasource enhancement using badi and user exits
- job scheduling in detail & job monitoring in ecc
- job triggering techniques
- process chain creation
- scheduling & monitoring process chains
- error handling in process chains
- compression & aggregation
- bex query designer
- calculated & restricted key figures
- formulas ,variables & exceptions
- filters and conditions
- bex analyzer & bex web analyzer.
- bex reporting in depth.
- roles & authorizations
introduction to sap hana
- sap in-memory strategy
- hana compare to bw
- architecture
- architecture overview
- imce and surroundings (in memory computing engine)
- row store & column store
- installation and deployment scenarios
navigation
- introduction to hana studio
- hana administration prospective
- modeler prospective
- system monitoring.
lt (landscapetransformation) or trigger based replication
- remote function calls
- creating rfc destinations in sap abap
- replicating sap tables from oltp server using trigger based replication
- real time replication
- job scheduling and monitoring.
- parallel and multi-thread processing.
sql scripts
- data types
- table creation, modification, updating and deletion operations.
- sql select statements
- joins and unions
- string operations
- stored procedures
- ce (calculation engine) functions.
- aggregations and lot more.
modelling
- applying star schema technique in sap hana
- attribute views (using hierarchies and joins in attribute views in depth)
- analytic views (using aggregations)
- calculation views
- using stored procedures in calculation views
- aggregations in calculation views
- hierarchies in calculation views.
- calculation engine concepts in depth.
hana -etlreplication methodology
- bods (business object data services)
- jdbc & odbc connectivity.
- replicating data from sap oltp server using bods
- replicating data from flat file source systems
- replicating data from bi system
- backward replication technique.
working withhana on bw platform
- bi and bods connectivity
- data extraction form sap bw into hana-server using bods
- reporting on bw infocubes using dashboards
transformationsusing bods
- merge transform
- pivot & reverse pivot transformations
- sql transformation
- key generation transform
- validation transform
- case transform
business objects cmc & information design tool
- creating repository
- relational database & olap connections
- working with universes
- creation of project & data foundation to build the universe
- creating data services repository user
xcelsius /sap bo dashboards
- consuming bex query
- consuming an universe to design a dashboard
- working with tabs
- working with workbook
- visualizing the data in charts
- using selectors
sap hana reporting using ms excel
- sap hana mdx provider
- creating odbc connection
- reporting fundamentals
- using filters and hierarchies
- graphical reporting
- advanced reporting techniques.
reportingusing business object explorer 4.0
- creating hana source systems
- managing info-spaces
- geographical reporting
- time based reporting
- hierarchical reporting
- configuring & indexing the views
- creating exploration viewset
- creating urls for web-based reporting
- reporting with boex in depth
crystalreports with sap hana
- creating relational database connection
- reporting on hana tables
- reporting on hana views
- reporting on stored procedures
sap bw on hana
- end – to –end implementation scenario
- introduction to sap hana dxc (direct extractor connection)
- hana as a source system via db connect
- concept of hana optimized dsos
- hana optimized infocubes
- migrating dsos & info cubes to hdb
- authorizations
- backup and recovery
sap abap on hana
- end – to – end implementation scenario
- the adbc connection
- creating external views on hana
- working & consuming stored procedures on abap
- sap abap for hana
- creating interfaces and & proxy classes to communicate with sps
- optimizing abap reports using hana (live scenario)
· software development on sap hana
- sap hana xs engine
- deploying java script based application on hana
- sap hana with odata services
- sap hana ui5 based development
· hana administration
- creating users
- assigning roles
- authorizations
- backup and recovery