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

ROLAP
Relational Online Analytical Processing, An OLAP that stores the data and aggregations in a relational database.

Schema
The set of tables in a Data Warehouse associated with a data model.

Slowly Changing Dimension (SCD)
Dimensional data that occasionally changes and affects how elements in your Data Warehouse relate. (Example: Reorganization of business results in changes to which areas and regions stores belong to.) Slowly Changing Dimensions require a strategy of how best to represent this changed relationship.

Surrogate Key
An artificial key which contains no encoded information or derived meaning that is created and used as an identifier (ID) or primary key (PK) field within databse tables.

Template
Reusable object that defines the layout of a report including the set and placement of attirbutes and metrics to be displayed.

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