SAP BI7.0 / SAP BW 3.x

BI-Architecture

BI-Architecture

  • Multi-Level Data Layers
  • Replicated Architecture
  • Aggregated Architecture
  • Large-Scale Architectures
  • InfoProvider Partitioning
  • Staging Partitioning
  • Open Hubs - InfoSpokes
  • Multi-Level BW/BI-Systems

Data-Modeling

Data-Modeling

  • InfoObjects - Characteristics
  • InfoObjects - Attributes (display, navigational)
  • InfoObjects - Hierarchies
  • InfoObjects - Key Figures
  • ODS
  • Data Store Object (standard, write-optimized, direct)
  • InfoSources
  • Dimensional Modeling
  • InfoCubes (Basic, Realtime)
  • MultiProviders
  • InfoSets
  • Open Hubs - InfoSpokes (File, DB-Table)
  • Aggregates

ABAP Coding

ABAP Coding

  • ABAP Reports
  • Function Modules
  • Customized Standard Extractors
  • Own Extractors
  • Coding in Transformations
  • Coding in START- Routines
  • Coding in END  -Routines
  • Coding in Data Transfer Processes
  • Coding in InfoPackages
  • Coding in Transfer Rules
  • Coding in Update Rules
  • Coding for Reporting Purposes

ETL

ETL

  • Generic Data Sources
  • File Systems
  • DB-Connect
  • Activation of Standard Business Content
  • Business Content Data Sources
    -> SD, MM, QM, FI/CO, HR
  • Enhancements of Standard Business
    Content Data Sources
  • (Complex) Transformations
  • Data Transfer Processes
  • Realtime Data Acquisition (RDA-Processes)
  • Indexing and BIA-Indexes
  • Transfer and Update Rules
  • START- and END-Routines
  • Direct Staging
  • ABAP-Coding
  • InfoPackages
  • (Complex) Process Chains (Meta, Decisions,...)

Reporting

Reporting

  • TOOLS: Query Designer, BEx-Analyzer, WorkBooks,
    Web Application Designer, Report-to-Report Interface
  • (Complex) Restricted Key Figures
  • (Complex) Calculated Key Figures
  • Formula Variables
  • Hierarchy Variables
  • Text Variables
  • Authorization Variables
  • Customer-Exits
  • Customizing Web Applications
  • Information Broadcasting

Performance Optimization

Performance Optimization

  • Data Model/Design Optimization/Redesign
  • Information Broadcasting
  • Settings for Data Loads
  • Settings for BEx - and Web Reporting
  • Non-Permitted Characters
  • Interfaces to ORACLE
  • Interfaces to Memory Parameters
  • Settings for Open Hub - InfoSpokes
  • Settings for BI-Monitoring
  • Indexes  including BIA-Indexes
  • Partitioning
  • BIA Indices
  • Parallelizations
  • Compression
  • Statistics
  • Reorganizations

BW-BPS, SAP-IP

BW-BPS, SAP-IP

  • BPS/IP - architecture
  • data model planning
  • planning functions
  • function enhancements
  • FOX formula
  • (web-) reporting

Methods, Model Planning

Methods, Model Planning

  • ER-diagrams
  • UML
  • ARIS
  • VISIO
  • MS Office
  • MS-Project

Database Oracle 9.x/10g

Design

Design

  • Entity Relationships
  • (Complex) SQL Statements
    • Subqueries
    • Scalar Subqueries
    • Inline Queries
  • (Complex) Triggers
  • Multi-Level Data Bases
  • Recovery Strategies

Recovery

Recovery

  • RMAN
  • Oracle Enterprise Manager
  • Net Services
    (Listeners, Master Agents, SNMP, Intelligent Agents)
  • Backup Solutions

Optimization

Optimization

  • database architecture
  • PL/SQL coding
  • oracle forms
  • SQL coding
  • database parameters

SAP R/3 - Processes

SAP R/3 - Processes

  • SD
  • MM
  • FI/CO
  • HR
  • QM
  • interfaces to PP, WM

EAI, SOA, Middleware, OO, Internet

EAI, SOA, Middleware, OO, Internet

  • J2EE
    (EJB, JNDI, JDBC, JTA, JAC, JMS,
     RMI-IIOP, JSP/Servlets)
  • CORBA
  • XML, XSL, XSLT, XPATH, XLink,
    XPointer, XQuery, SAX, DOM
  • Web Services
    (SOAP, WSDL, UDDI, WS-*Extensions)
  • Design / Implementation of Web Services
  • Enterprise Service Bus (ESB)
  • MOM-Architectures
  • SOA-Architectures
  • BPEL
  • BAPI, SAP Business Connectors

Programming Languages

Programming Languages

  • ABAP (OO)
  • JAVA
  • C, C++
  • PYTHON
  • SQL, PL/SQL

search: