Question: Describe the basic operation of an OLAP report. Define measure, and give an example. Define dimension, and give at least two examples. Using hypothetical data
Describe the basic operation of an OLAP report. Define measure, and give an example. Define dimension, and give at least two examples. Using hypothetical data and Figure CE13-9 as a guide, show how your measure and dimensions would appear in an OLAP report. Show how the structure of the report changes if you switch the two dimensions. Using your sample data, explain why OLAP reports are considered more dynamic than standard reports. Describe the circumstances under which an OLAP server is required.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
