On Accessing Data From An OLAP Server Using MS Excel - The Cube: MyFirstCube

(Page 2 of 6 )

This cube was fashioned from the "Order-Details" table on the Northwind database as the Measures table, and the "Orders" and "Products" tables as the Dimensions table. The next picture shows this star schema in the "Cube Editor" window.

The Meta Data

Meta data is data about data. It really summarizes what is seen in the "Cube Editor." Additionally it also shows a Calculated Member. When data is accessed, this calculation need not be executed; the value already exists.

Next: The Data in the Cube >>
 

More MS SQL Server Articles
More By Jayaram Krishnaswamy

Comments On: On Accessing Data From An OLAP Server Using MS Excel

>>> Be the FIRST to comment on this article!