Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
OLAP(Online Analytical Processing)
Post: #1

Online Analytical Processing (OLAP)

Online Analytical Processing (OLAP) is a technology by which Data Warehouse data are queried and analysed.A Data Warehouse is the repository that stores large amount of data extracted from a variety of source systems exist within the organisation. A Data Warehouse does not necessarily need OLAP technology. OLAP enables users to gain insight into data. OLAP uses a multidimensional view of aggregate data to provide quick access to strategic
information for analysis purposes.

OLAP lowers the incidence of erroneous interpretations, reducing the amount of data "noise",eases navigation of the database, screening for a particular subset of data, asking for the data in a particular orientation and defining analytical calculations.

The key concepts in OLAP are:

Measure or Fact
It is a data variable that stores business information, classified by one or more mutually independent categorising structures.

a logical grouping of dimension values sharing the same level of abstraction within a hierarchy.

is a categorising structure by which business measures are classified for analysis purposes

Dimension Value
Consists of many dimension values each
representing a distinct category of

When a measure is
classified by a number of dimensions, we
say that the measure is dimensioned by
those dimensions

It is a parentage structure by which dimension values are organised.

Parent and Child
The dimension values,
dimension values are related to each other
as parents, children or siblings ,Once grouped into
levels and hierarchies.

single data-point that
occurs at the intersection defined by
selecting one dimension value from each
dimension in the measureâ„¢s

collective term for the
multi-dimensional array of data cells.

Drill Up, Drill Down
a specific analytical technique
whereby the user navigates among
dimension levels, from the most
summarized to the most detailed.

Drill through
Many a times, there is a requirement to dig deeper for more
detailed information that are not in the cube.This is achieved by a drill
through operation from the cube into relational Data Warehouse data.

Full seminars report download:
Post: #2
i wnat it plz send me soon a downloadable version
Post: #3
This article is presented by:



-Basic idea:

#Quickly answer multi-dimensional analytical queries.

#Convert data into information that decision makers need

#It is a continuous , iterative, and preferably interactive process.


It is used in an organization to carry out the different ORGANIZATIONAL FUNCTIONS in :
#Finance departments
#Sales analysis and forecasting
#Marketing departments

Cardinal Goal
“ Provide managers with the information they need to make effective decisions ”

For more information about this article,please follow the link:
Post: #4
Dear friends

Thanks for posting. I like OLAP(Online Analytical Processing) very much.

Very useful for me.

We also find them more same at: Analytical interview questions

Important Note..!

If you are not satisfied with above reply ,..Please


So that we will collect data for you and will made reply to the request....OR try below "QUICK REPLY" box to add a reply to this page

Quick Reply
Type your reply to this message here.

Image Verification
Image Verification
(case insensitive)
Please enter the text within the image on the left in to the text box below. This process is used to prevent automated posts.

Possibly Related Threads...
Thread: Author Replies: Views: Last Post
  “ONLINE VOTING SYSTEM” seminar class 7 11,003 10-06-2015 04:12 PM
Last Post: seminar report asees
  Image Processing & Compression Techniques (Download Full Seminar Report) Computer Science Clay 42 19,815 07-10-2014 07:57 PM
Last Post: seminar report asees
  On-line Analytical Processing (OLAP) computer science crazy 2 2,617 01-04-2014 11:11 PM
Last Post: seminar report asees
  Hardware for image processing - Basics Eye – Human vision sensor ppt computer topic 0 711 25-03-2014 11:12 PM
Last Post: computer topic
Question Space-time Adaptive Processing (STAP) computer science crazy 2 2,309 16-10-2013 03:09 PM
Last Post: Guest
  Online Cargo Tracking System computer girl 1 1,178 02-02-2013 01:48 PM
Last Post: seminar details
  Digital Light Processing computer science crazy 1 1,471 11-01-2013 10:56 AM
Last Post: seminar details
  digital image processing project topics 1 1,787 19-11-2012 01:46 PM
Last Post: seminar details
  Online shopping relationship as collaborative decision process project report helper 1 1,320 31-10-2012 02:06 PM
Last Post: seminar details
  GPUs - Graphics Processing Units computer girl 0 531 07-06-2012 03:45 PM
Last Post: computer girl