Business Intelligence - What is OLAP?

GeekInterview.com > Interview Questions > Data Warehousing > Business Intelligence

Go To First | Previous Question | Next Question

Business Intelligence | Question 2 of 41

What is OLAP?

Answer posted by Vikas R on 2005-05-22 02:57:09: OLAP stands for Online Analytical Processing. It is used for Anaytical reporting

Total Answers and Comments: 7

Last Update: December 01, 2008

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

March 27, 2005 07:29:25

John

RE: What is OLAP?

A tool to evaluate and analyze the data in the data warehouse using analytical queries.

A tool which helps organize data in the data warehouse using multidimensional models of data aggregation and summarization.

Supports the data analyst in real time and enables online analysis of data with speed and flexibility.

Is this answer useful? Yes | No

May 22, 2005 02:57:09

Vikas R

RE: What is OLAP?

OLAP stands for Online Analytical Processing. It is used for Anaytical reporting

Is this answer useful? Yes | No

December 23, 2005 08:11:23

Sithu

RE: What is OLAP?

OLAP: online analytical process

This helps to do Business analysis of you data but normal reporting tools are not supporting to Business analysis. This is the major difference between reporting tool and OLAP tool.

Is this answer useful? Yes | No

January 10, 2006 04:08:04

sithusithu

Member Since: December 2005 Contribution: 161

RE: What is OLAP?

OLAP: online analytical process

This helps to do Business analysis of you data but normal reporting tools are not supporting to Business analysis. This is the major difference between reporting tool and OLAP tool.

Cheers

Sithu

Is this answer useful? Yes | No

February 28, 2007 02:31:59

kiran

RE: What is OLAP?

OLAP is an Online Analytical Process Which used especially for analysis purpose but not for reporting. It is a GateWay between the Business user and DWH.

Is this answer useful? Yes | No

September 03, 2007 03:56:38

prudhvi.g

Member Since: September 2007 Contribution: 8

RE: What is OLAP?

OLAP means Online Analytical Processing.
It is a database which contain Historical data and the oldest data which is used to the business people.
It comes from the data you have put in an OLTP database.
OLTP means Online Transaction Processing.

Is this answer useful? Yes | No

December 01, 2008 12:13:17

ramandeep singh

Member Since: December 2008 Contribution: 4

RE: What is OLAP?

OLAP is used to extract data from multiple sources. All extraction is done online by making use of ETL

Is this answer useful? Yes | No

Go To Top

User Name		Remember Me?
Password

Question Bank