The easiest way to examine the data within a cube is to use a cube browser. Analysis Manager has one built in and there are a number of others on the market.

Remember that a cube is not ANYTHING like a table. Where a table is two dimensions (rows and columns) a cube can have up to 129 dimensions (128 dimensions + measures, which are treated as a dimension).

I know of no easy way to see everything because it can't be rendered in 2D space. If it helps, the raw data at the bottom of the hierarchies is the same data in your dimensional database.

-Mike