ETL can extract, transform using various transformations that are available in the tool, and AGGREGATE the data. The OUTPUT can be used as an input for OLAP tool. ETL is the initial PART of data warehousing. For generating cross tab report from the source tables, data warehouse takes very long time span. For efficiency, these tables are transformed into cubes and persisted in OLAP server. The analysis that is performed on the cubes is provided with pre-aggregated values. Hence, report generation will be much FASTER.

OLAP supports online reports after performing certain join operations and creating some cubes. OLAP CONSISTS of various applications for score carding, reporting, dashboards, consolidation, planning, analysis, master data management, workspace and foundation.

ETL can extract, transform using various transformations that are available in the tool, and aggregate the data. The output can be used as an input for OLAP tool. ETL is the initial part of data warehousing. For generating cross tab report from the source tables, data warehouse takes very long time span. For efficiency, these tables are transformed into cubes and persisted in OLAP server. The analysis that is performed on the cubes is provided with pre-aggregated values. Hence, report generation will be much faster.

OLAP supports online reports after performing certain join operations and creating some cubes. OLAP consists of various applications for score carding, reporting, dashboards, consolidation, planning, analysis, master data management, workspace and foundation.