Page 52 - DCAP606_BUSINESS_INTELLIGENCE

Unit 4: Understanding OLAP

With Hyperion Essbase, most users obtain responses to their queries in a fraction of a second. Notes
Even the most complex queries take only a couple of seconds. In audited OLAP benchmark
results, Hyperion Essbase processed more than 6,800 complex queries per minute on a four-
processor server — an average answer time of just 0.00876 seconds per query.
While query tools are becoming progressively complicated, their presentation is still limited
by the answer time of the data source. It consistently provides very quick answer by permitting
designers to optimize performance founded upon an application’s unique obligations for query
presentation, calculation complexity, assessment window (the allowance of time accessible to
load and assess the application), user concurrency and computer disk utilization. Hyperion
Essbase accomplishes this flexibility through three calculation choices: precalculate, calc on the
go by plane and calc on the go by plane and store. Together, these three assessment schemes let
designers maximize flexibility, capacity and performance.

Self Assessment

State whether the following statements are true or false:
8. OLAP user’s queries are neither predictable nor repairable and the results of one query
often frame the obligations of the next.
9. To be productive, an analysis session should not be interactive and keep pace with the
analyst’s speed of consideration.

4.4 Metadata Based Queries

A metadata block is a named group of metadata in a specific format. A metadata block can
contain individual metadata pieces such as an author or creation time and additional metadata
blocks. A metadata block’s name is very resolute by its format.

Example: A metadata block including App1 metadata would be entitled “app1”. Common
metadata formats includes App1, Exif, IFD, and XMP.

Figure 4.3: JPEG image with Rating Metadata

Source: http://i.msdn.microsoft.com/dynimg/IC534518.png

LOVELY PROFESSIONAL UNIVERSITY 47