FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -Applications of OLAP include business reporting for sales, marketing, management reporting, business process management (BPM), budgeting and forecasting, financial reporting.

Detailed explanation-2: -Common uses of OLAP include data mining and other business intelligence applications, complex analytical calculations, and predictive scenarios, as well as business reporting functions like financial analysis, budgeting, and forecast planning.

Detailed explanation-3: -There are three main types of OLAP: MOLAP, HOLAP, and ROLAP. These categories are mainly distinguished by the data storage mode. For example, MOLAP is a multi-dimensional storage mode, while ROLAP is a relational mode of storage. HOLAP is a combination of multi-dimensional and relational elements.

Detailed explanation-4: -OLAP allows business users to slice and dice data at will. Normally data in an organization is distributed in multiple data sources and are incompatible with each other. A retail example: Point-of-sales data and sales made via call-center or the Web are stored in different location and formats.

Detailed explanation-5: -OLAP allows users to drill down for greater details or roll up for aggregations of metrics along a single business dimension or across multiple dimension. OLAP provides the ability to perform intricate calculations and comparisons. OLAP presents results in a number of meaningful ways, including charts and graphs.