Ask the Expert

The role of OLAP in the interpretation of data

Describe what are the roles of dimensional analysis and OLAP in the interpretation of data?

    Requires Free Membership to View

Dimensional analysis and OLAP are somewhat synonymous methods of browsing data. Primarily this refers to data in "multidimensional" cube structures or, at least, modeled dimensionally (using star or snowflake approaches). The general flow of a query session using dimensional analysis or OLAP is:

  1. What measures are you after? This selects the fact table and the measure.
  2. What dimensions do you want to filter the results by?
  3. What values within those dimensions (any level) do you want to filter the results by?

If properly done, dimensional modeling inherently implies exactly how the data can be accessed and should be interpreted because it defines the relationships amongst the data that can be traversed using the three steps above.


This was first published in November 2002

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: