Data warehousing
Data warehousing represents the integration, transformation, consolidation, cleanup, and storage of data. It also incorporates the extraction of data for analysis and interpretation. The data warehousing process includes data modeling, data extraction, and administration of the data warehouse management processes.
___________________________________________________________________________________
Multidimensional database
Multidimensional database (data cubes) as opposed to relational tables enables pre-aggregated data storage by dimension and faster data retrieval when running queries.
___________________________________________________________________________________
OLAP Processor
OLAP processor (Online Analytical Processing) is a server component. It lies between the end user and the database. It makes the multi-dimensionally formatted data available to front end tools. OLAP processor is optimized for the analysis and reporting of very large datasets.
___________________________________________________________________________________
Data Mining
You can use data mining to automatically determine significant patterns and hidden associations from large amounts of data. Data mining provides you with insights and correlations that had formerly gone unrecognized or been ignored because it had not been considered possible to analyze them.
___________________________________________________________________________________
ETL
Extraction Transformation Language (ETL) is used when implementing certain application logic during data extraction and transformation from source to target.
___________________________________________________________________________________
Integrated Planning
In SAP BI 7.0 Integrated Planning provides business experts with an infrastructure for realizing and operating planning scenarios. Planning covers a wide range of topics from simple data entry to complex planning scenarios. In contrast to BW-BPS (Business Planning and Simulation), this solution is fully integrated into the BI reporting system.