SAP-BI ( 7.0) online Training – Hopkins

SAP-BI (7.0) online training with ECC (6.0)  IntroductionGeneral Introduction. SAP introduction. Data warehousing/ BW/ BI Introduction Data Modeling OLAP v OLTP: The OLAP Concept and differences between OLAP and OLTP ERM, MDM, Star schema, extended star schemaData warehouse workbench functions: Characteristics, Key Figures, Data Sources for  File Source Systems, Info Package, PSA, Transformations, data transfer processesInfoCubes: Standards, real time, Virtual ProvidersData Store objects (DSO):  Standards, direct update, write optimizedInfocube VS DSO Master data- texts, Attributes, Hierchies.RemodelingInfosetsMultiproviderOpen hub destinationProcess chains Metadata and Document Management BI Content: Definitions, How to install BI contentsDefining extraction For SAP source systems: Creating Generic dataSource and maintaining SAP delivered dataSource. Or for files: Creating DataSources for File Source Systems User management: AuthorizationsTransports: Real business scenarios on different system environments, Moving objects from one system to another.   Data Extraction:Business flow: SD, MM, PP, FI, HR, SCM, CRMBW overview –R/3 extractionGeneric data extraction Data Extraction from LISData Extraction from LO cockpitData Extraction from CO-PAData Extraction from FI BEx Query Designer  Introduction to BW-Bex reporting BEX Analyzer & Bex BrowserReporting features & propertiesFree Characteristics, Filters, Exceptions, Conditions, Calculated and Restricted Key Figures, structures.Cell Definition New selection, new formula.Column&row properties.Report-to-Report InterfaceVariables: Characteristic value variables, Hierarchy Variables, Hierarchy node variables, Text variables, Formula variables Report designerInformation broadcastingDesign mode (web items) Web Application Designer WAD: Functions of WAD, Web Items Window, Template Window, Properties Window Web Applications: Creating Web Applications, Settings and Properties Design: Designing the Layout of Web Templates Performance Line item dimension High cardinalityBI statisticsAggregation, Rollup.PartitionCompressionIndexesReconstructionOverview:ABAP (related to BI)BW-BPS (Business Planning and Simulation)BI-IP (Integrated Planning)Differences between 3.5 and 7.0 version.