Mapping of Reports to Star Schema

How does this dimensional model map into an actual report?

Now if you look at a report  generated from your  dimensional modeled data warehouse, it will look like this:

OLAP Report

You can tell from the above report that all your dimensions are the row and column headings in the report.  The facts are the numeric numbers in the report.

Advantages of Star Schema

  • Star Schema is very easy to understand, even for non technical business managers
  • Star Schema provides better performance and smaller query times
  • Star schema is easily extensible and will handle future changes easily
<<< Star Schema of OLAP
Copyright 2005-2016 KnowledgeHills. Privacy Policy. Contact .