Interview Questions   Tutorials   Discussions   Programs   Videos   

SAS - What is OLAP?

asked mar September 20, 2014 06:28 AM  

What is OLAP?


1 Answers

answered By vishnoiprem   0  

Stands for "Online Analytical Processing." OLAP allows users to analyze database information from multiple database systems at one time. While relational databases are considered to be two-dimensional, OLAP data is multidimensional, meaning the information can be compared in many different ways. For example, a company might compare their computer sales in June with sales in July, then compare those results with the sales from another location, which might be stored in a different database.

In order to process database information using OLAP, an OLAP server is required to organize and compare the information. Clients can analyze different sets of data using functions built into the OLAP server. Some popular OLAP server software programs include Oracle Express Server and Hyperion Solutions Essbase. Because of its powerful data analysis capabilities, OLAP processing is often used for data mining, which aims to discover new relationships between different sets of data.

OLAP can be performed in data warehouses that undergo frequent updates and that do not. Following are some of the examples to show how OLAP solves complex queries involving facts to be measured across company�s best-interested dimensions.

• Comparison of sales (fact) of a product (dimension) over years (dimension) in the same region (dimension). • How may members (fact) have opened a savings account (dimension), in USA branch (dimension), over a period (dimension) • How many mortgage loans (fact) have been approved in fixed mortgage (dimension) or Adjustable Rate Mortgage (dimension) in New York City (dimension), over a period (dimension) • What is the total sales value (fact) of a particular product (dimension) in a particular grocery store (dimension), over a period (dimension) • What is the amount spent (fact) for a particular product promotion (dimension) in a particular branch (dimension) or in a particular city (dimension), over a period (dimension)

   add comment

Your answer

Join with account you already have



 Write A Tutorials
Online-Classroom Classes

  1 person following this question

  Question tags

sas × 1

Asked 2 years and 3 months ago ago
Number of Views -243
Number of Answers -1
Last updated
3 years and 2 months ago ago

  Similar questions

Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!