O'Reilly logo

Smart Business Intelligence Solutions with Microsoft® SQL Server® 2008 by Kevin S. Goff Lynn Langit Davide Mauri, Sahil Malik, and John C. Welch

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Understanding Business Intelligence from a User’s Perspective

As we mentioned already, visualizing the results of BI solutions is one of the more difficult aspects of designing and building BI solutions. One of the reasons for this is that we really don’t have the ability to "see" multidimensional structures (such as OLAP cubes) that we build with SSAS. Figure 2-3 is somewhat helpful because it shows data arranged in a cube. However, understand that this visualization reflects only a small subset of what is possible.

Conceptual picture of an OLAP cube (from SQL Server Books Online)

Figure 2-3. Conceptual picture of an OLAP cube (from SQL Server Books Online)

The figure shows an OLAP cube with only three dimensions ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required