<ul> <li>Overview of SAP HANA</li> <li>What is SAP ERP and its modules</li> <li>History of HANA</li> <li>HANA vs BWA</li> <li>HANA features</li> <li>SAP HANA IMDB storage types</li> <li>SAP HANA compression and memory allocation</li> <li>SAP HANA evaluation</li> <li>Row and column oriented storage</li> <li>Memory allocation</li> <li>Compression and portioning</li> </ul>

<ul> <li>Overview of SAP HANA Architecture</li> <li>IMCE and surroundings</li> <li>Benefits of In-memory studio</li> <li>Benefits of Request Processing/Execution Control</li> <li>Session management</li> <li>Persistence layer</li> <li>Reporting</li> <li>Load controller, Disk Storage and managers</li> <li>Relational engine and request processing</li> <li>Importing data in HANA</li> <li>Benefits of Replication Agent</li> <li>SAP HANA licensing <p>&nbsp;</p> <ul> <li>SAP HANA version</li> <li>Platform edition</li> <li>Enterprise edition</li> <li>Enterprise extended edition</li> </ul> </li> </ul>

<ul> <li>Perspective, content and catalogue</li> <li>Developing schema</li> <li>Developing package and attribute view</li> <li>Creating hierarchy and analytical view</li> <li>Benefits of Description Mapping</li> <li>Creation of Analytical View &amp; Hierarchies</li> <li>Distribution making, data Foundation, text join and logical</li> <li>Calculation view</li> <li>Union, join and projection</li> <li>Importance of Save, Attributes, Measures, Variables</li> <li>Find Column</li> <li>SQL script related to HANA</li> <li>Decision table</li> <li>Develop hierarchies and analytical view</li> <li>Analytical privileges</li> </ul>

<ul> <li>What is data provision?</li> <li>Data provisioning using BODS Server</li> <li>Management of metadata</li> <li>Text data analysis</li> <li>Functioning with BODS</li> <li>Repository and job server</li> <li>Development of datastores, projects, formats and batch jobs</li> <li>Batch jobs monitoring and scheduling</li> <li>Dataflows and connections to HANA DB</li> </ul>

<ul> <li>Load data into HANA database through excel file</li> <li>Load data into HANA database through flat file</li> <li>Template tables</li> <li>Load data into HANA database through SAP ECC</li> <li>Load data into HANA database through SAP ECC using ABAP dataflow</li> <li>Load data into HANA database through SAP BW</li> <li>Load metadata into HANA database through SAP ECC</li> </ul>

<ul> <li>Universe designer tool <ul> <li>a) Data provisioning using SLT and its features <ul> <li>Main benefits of SLT replication server and trigger based approach</li> <li>Architecture for SAP and non SAP source replication</li> <li>Start load replication</li> <li>SLT best transformation concept</li> <li>Filter and selective data replication</li> <li>Configuration and monitoring dashboard for HANA LTR</li> <li>Stop and suspend replication</li> <li>Developing new configuration for SAP and Non SAP sources</li> <li>Status monitoring in HANA studio</li> <li>Advanced replication settings</li> <li>Launching data provisioning UI in HANA Studio</li> <li>New configuration of SAP and Non-SAP sources</li> <li>SAP Landscape replication server for HANA</li> </ul> </li> <li>b) Data provisioning using SAP direct Extractor connection DXC <p>&nbsp;</p> <ul> <li>Using business content extractor</li> <li>ABAP data flow</li> <li>Importance of DXC</li> <li>Data source extractor concept</li> <li>Tracking data loads</li> <li>SAP business content data source extractors</li> <li>Comparison with different data acquisition methods</li> <li>Develop info package and data load scheduling</li> <li>Data source activation in source system</li> <li>Handling of delta processing through activation mechanism</li> </ul> </li> </ul> </li> <li>Information Designer tool <ul> <li>Local connection</li> <li>Secured connection</li> <li>Data foundation connection, parameters, etc</li> <li>Business layer, parameters, etc</li> </ul> </li> <li>Conditions</li> <li>Developing objects and types</li> <li>Managing security</li> <li>Trap issues and derived tables</li> <li>Hiding and un-hiding objects</li> <li>Table creation</li> <li>Usage of @functions &ndash; @ Prompts</li> <li>Usage of @Where</li> <li>Usage of @Select</li> <li>Usage of @Aggregate Awareness</li> <li>Data integrity &amp; Business layer</li> <li>Single data source and multiple data sources</li> <li>Performance tuning techniques</li> <li>Business Intelligence Consumer Services (BICS)</li> </ul>

<ul> <li>Crystal Reporting in HANA</li> <li>WEBi reporting</li> <li>Designing business layer on IDT environment</li> <li>Relational Connectivity with HANA</li> <li>Excel-based reporting</li> <li>Crystal reporting</li> <li>SAP BO analysis</li> <li>Developing connection, business layer, dashboards and data foundation</li> <li>Lumira</li> </ul>

<ul> <li>What is web intelligence?</li> <li>Developing folder and connections</li> <li>Connections relational and OLAP types</li> <li>Inserting tables</li> <li>Developing business layer using data foundation through single and multiple sources</li> <li>Create objects and classes</li> <li>Resolving loops</li> <li>Types of join and its creation</li> <li>Exporting business layer</li> <li>Export business layer into repository</li> </ul>

<ul> <li>Create web intelligence document using Universe</li> <li>Modify existing web intelligence document</li> <li>Restriction of information returned by queries</li> <li>Create a report and calculate data using formulas and variables</li> <li>Analyze data and forming report</li> <li>Work with drilling, purging, prompts, sub reports, filter query, breaking, etc</li> <li>Develop hyperlinks and formulas with char and date strings</li> <li>Designing a form and report</li> <li>Webi reports creation on SAP Bex query</li> <li>Convert tables into graph</li> <li>Web intelligence report developing using info cube and BW query</li> </ul>

<ul> <li>Planning report with universe</li> <li>Formatting and distributing reports</li> <li>Applying section formatting and conditional reporting</li> <li>Report templates and formulas</li> <li>Using hyperlinks to reports</li> <li>Develop formulas</li> <li>Section formatting and conditional formatting</li> <li>Creating parameterized reports</li> <li>Organizing data and using report section</li> </ul>

<ul> <li>Developing a model</li> <li>Making connection model</li> <li>Connecting with crystal reports and WEBi reports data</li> <li>Live office data</li> <li>Connectivity components</li> <li>Developing dashboards using above methods</li> <li>Creation of dashboard using alerts, dynamic visibility, components and query browser</li> </ul>

<ul> <li>User and role Creation</li> <li>Assigning roles to the user</li> <li>Assigning analytical privileges to the role</li> </ul>

<ul> <li>What is Transport Connection?</li> <li>SAP Transport Connection</li> <li>ANA Transports</li> </ul>

<ul> <li>System</li> <li>SQL</li> <li>Granted Role</li> <li>Package</li> </ul>

<ul> <li>HANA SQL DDL, DML, DCL</li> <li>SAP HANA Referential Join</li> <li>Procedures and calling procedures</li> <li>Creating Types of Table</li> </ul>

<ul> <li>Control Statements and Support Mode</li> <li>Understanding and using Currency Conversations in SAP HANA</li> <li>Generate Auto Documentation</li> <li>Import &amp; Export Models</li> <li>Delivery Units and Developer Mode</li> <li>Documentation and Translations</li> <li>Managing model Content and Schemas</li> <li>Security &amp; Authorizations</li> <li>Privileges in HANA</li> <li>Creating Users and Assigning Privileges to the Users &amp; Roles</li> </ul>

<ul> <li>HANA BW DB2 Migration Process</li> <li>BW with HANA DB vs DB2</li> </ul>