• Document: UNIT-3 OLAP in Data Warehouse
  • Size: 124.13 KB
  • Uploaded: 2018-12-08 22:48:31
  • Status: Successfully converted


Some snippets from your converted document:

MCA 204, Data Warehousing & Data Mining UNIT-3 OLAP in Data Warehouse © Bharati Vidyapeeth’s Institute of Computer Applications and Management, New Delhi-63, by Dr.Deepali Kamthania U2.1 OLAP • Demand for Online analytical processing • Major features and functions • OLAP models and implementation considerations © Bharati Vidyapeeth’s Institute of Computer Applications and Management, New Delhi-63, by Dr. Deepali Kamthnai U2.2 Demand of On Line Analytical Processing • Need for multidimensional analysis • Fast access and powerful calculations • Limitations of other analysis methods • OLAP is the answer • OLAP definitions and rules • OLAP characteristics © Bharati Vidyapeeth’s Institute of Computer Applications and Management, New Delhi-63, by Dr. Deepali Kamthnai U2.3 © Bharati Vidyapeeth’s Institute of Computer Applications and Management, New Delhi-63, by Dr. Deepali Kamthania U2.1 MCA 204, Data Warehousing & Data Mining Demand of On Line Analytical Processing OLAP:-On line Analytical Processing • It covers a Wide Spectrum of Complex multidimensional Analysis involving Complex Calculations and Requiring Fast response times. © Bharati Vidyapeeth’s Institute of Computer Applications and Management, New Delhi-63, by Dr. Deepali Kamthnai U2.4 Need for Multi-Dimensional Analysis • Multidimensional view are inherently representative of any business model. • Very few models are limited to three dimension or less. • Decision makers not satisfied with one-dimensional queries such as  “How many units of Product A did the Store in Delhi, India sold?” © Bharati Vidyapeeth’s Institute of Computer Applications and Management, New Delhi-63, by Dr. Deepali Kamthnai U2.5 Cont... • Consider the following more useful query, How much revenue did the new Product X generate during the last three months, broken down by individual months, in the South Central Territory, by individual stores, broken down by promotions, compared to estimates and compared to the previous version of Product? • Analysis continues  Further comparisons to similar products, comparisons, among territories etc. may be required. © Bharati Vidyapeeth’s Institute of Computer Applications and Management, New Delhi-63, by Dr. Deepali Kamthnai U2.6 © Bharati Vidyapeeth’s Institute of Computer Applications and Management, New Delhi-63, by Dr. Deepali Kamthania U2.2 MCA 204, Data Warehousing & Data Mining Fast Access and Powerful Calculations • In order to perform fast Access and also implements power in Calculations the typical calculations get included in the query requests.  Roll-Ups to provide summaries and aggregations along the hierarchies of the dimensions.  Drill Drill-downs downs from the top level to the lowest along the hierarchies of the dimensions, in combinations among the dimensions. • Simple Calculations, Such as Computations of Margins (Sales minus Costs). © Bharati Vidyapeeth’s Institute of Computer Applications and Management, New Delhi-63, by Dr. Deepali Kamthnai U2.7 Cont... • Share Calculations to compute the percentage of Parts to the whole. • Algebraic Equations involving key performance indicators.

Recently converted files (publicly available):