- Multidimensional Model (Extended Star Schema) of ERP/SAP BI
- Administrator Workbench
- Info-objects : Characteristics, Key Figures,
Attributes
- Info-cubes, Multi Providers, Remote Cubes, Virtual
Cubes
- Operational Data Store (ODS)
- Persistent Staging Area (PSA)
Data
Warehousing
- Business Content
- Technical Content (Statistic)
- Aggregates (Rollup) for Info Cubes
- Cube Compression (Collapse)
- Process Chains
- Transport Connection
Data
Extraction, Tracking and Loading
- Source Systems (ERP/SAP, NON-ERP/SAP and Flat File)
- Data Source
- Transformations, Infosource
- Info Packages, DTP?s and Load
Monitoring
- Extraction Methods (Full,
Initialization, Delta)
- Loading of Master Data, Text,
Hierarchies, Transactional Data (From ERP/SAP and Flat File source systems)
Data
Extraction, Tracking and Loading
- Business Content Extraction (FI-GL, COPA and Logistic Cockpit)
- Generic Extraction From ERP/SAP
Reporting
- Business Explorer
a. Filters, Rows, Columns, Free Characteristics
b. User Entry Variables, Customer Exit Variables
c. Restricted Key figure, Calculated Key Figure (Local and
Global)
d. Properties for Queries, Key Figures and Characteristics
- Web Application Designer
a. Assigning Queries to Web Template
b. Defining Data Providers
c. Web Components overview using Tables, Navigational Block,
Radio Buttons, Drop Down Box.