iOLAP Training | Business Intelligence Terminology

Business Intelligence Terminology


		Data Warehousing
		BI Terminology





		iOLAP Sevices

		iOLAP Products


		iOLAP e-Newsletter


		Contact Us

		Request a Quote

		Schedule a Demo



		Get Answers Fast


Send this page to a friend


home > training > bi terminology

Terminology

A - D | E - H | I - L | M - P | Q - T | U - Z

Element
A unique value of an attribute or metric. (Examples: “Atlanta” is an Element of the Attribute, “City.” “July” is an Element of the Attribute, “Month”).

Entity Relationship Diagram (ERD)
Graphical represtentation of your Data Model which visually identifies objects and the relationships between data elements.

ETL
Acronym for Extraction Transformation and Loading. Process used to populate a data warehouse with data from other sources.

Fact Table
A table containing numeric data grouped along one or more dimensions. This numeric data may then be used within calculations for reporting and analysis. Fact tables can contain either Atomic or Aggregated data and serve as the center of a Star or Snowflake Data Warehouse Schema.

Filter
Objects used to limit data returned in a report by applying specific criteria. It is usually found in the SQL WHERE clause.

Hierarchy
A set of attributes with a defined path for elemental browsing and drilling. Typically (but not always) Heirarchies exist within specific Dimensions.

HOLAP
Hybrid Olap, combination of ROLAP and MOLAP. The source data is stored using ROLAP and the aggregations are stored using MOLAP.

Copyright © 2005. iOLAP Corporation. All Rights Reserved. Frisco, Texas . Privacy Policy Terms of Use Site Map