SAP FICA COURSE CURRICULUM

Download [PDF]

• Module One
  Enterprise Structure Introduction to ERP, SAP, Data Warehouse Overview of BW, BI, Data Base. Overview of BW Architecture, Landscape Basic Modeling: Create a valid Schema Multi-Dimensional Model – The Star Schema (Classical Approach) Multi-Dimensional Star Schema in BW (Extended star Schema) The OLAP Concept and differences between OLAP and OLTP
• Business Modeling
  Info Area
  Info Object Catalogs
  Info Objects
  PSA
  Application Component
  Info Source
  Data Source
  Transfer Rules
  Update Rules
  Transfer Structure
  Communication Structure
  Info Package
  Transformation
  Data Transfer Process
• Loading Transactional Data into BW info Cube
• Loading MD with TD into BW System
• BW and BI Comparisons
• Master data loading-new(BI) ETL process
  Info cube & Types
  Standard Info cube and Loading with new ETL Process
• Generate Report with BI master and Transaction Data
• Manual Uploading of MD like Attributes, Text, Hierarchy
• Different Types of Attributes
• Transformations , Rule types
• Routines
  Start Routine
  End Routine
  Expert Routine
• DTP (Data Transfer Process)
  Standard DTP
  Error DTP
  Direct Access DTP
  Real time DTP
• DSO (Data Store Object)
  Standard DSO
  Write optimized DSO
  Direct update DSO
  APD (Analysis Process & Design)
• Update Methods
  Full updates
  Initialization
  Delta Updates
• Info Providers
  Multi Providers
  Info set
  Virtual Providers
  Re-Modeling
  Re-Partitioning
  Open-Hub Destination
  Data Marts
• Info Cube Maintenance
  Aggregates
  Roll-up
  Compression
  Reconstruction
• Process Management
  Process Chains, Process Types
  Scheduling
  Monitor (Header, Status, Details)
• Reporting – Business Explorer
  BEX Query designer
  BEX Analyzer
  BEX WAD
  BEX Report Designer
  Visual Composer
• Functional Overview of Bex Query Designer
• Reusable Query Elements
  Query Controls with Variables
  Calculated Key Figures
  Restricted Key Figures
  Formulae
  Structures
• Variable Definition in Detail
  Characteristic values variables
  Text Variables
  Formula Variables
  Hierarchy Variable
• Analysis Functions
  Conditions
  Exceptions
• Reporting Drilldown
  Drilldown to DSO from Info Cube (RRI)
  Copying Queries from Cubes
• Bex Analyzer
• Bex WAD
• Bex Report Designer
• Visual Composer
• Migration Objects from BW 3.x to BI 7.0
• Transportation
• Extraction
  Generic Data Extraction using MD/TD Tables
  COPA Extraction
  Business Content Extractions using MD/TD
  LO-COCKPIT Data Extraction
• Delta types for
  Generic Extraction
  LO Extraction
• ASAP methodology