O'Reilly logo

Microsoft® SQL Server® 2008 MDX Step by Step by C Ryan Clay Bryan C Smith and Hitachi Consulting

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 Cells

In the previous exercise, you used a tuple to locate a point within a cube space. On the surface, it appeared that a simple value is recorded at this point, which is what is returned by the SELECT statement. The reality is a bit more complex.

Points within cube spaces are occupied by cells. Cells are objects and as such have a number of properties. When cells are accessed, various properties are returned. The default properties returned are VALUE and FORMATTED_VALUE.

The VALUE property contains an aggregated measure value. That value is based on the measure aggregated against all the other attribute-hierarchy members associated with the cell. For example, the VALUE property of the cell associated with the previously employed ...

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