What were the monthly sales of grains and cereals for USA in November 1997?
$1,885.60
How does this figure compare with sales in the United Kingdom (UK) for the same time frame?
There were no sales of grains and cereals for the United Kingdom in November 1997.
How do UK sales of confections in the first quarter of 1997 compare with sales in the same quarter of 1998?
$617.70 in 1997, compared with $4,654.10 in 1998
What customer in London purchased the most confections in the first quarter of 1998?
Around the Horn
What is the largest sales quarter, by Category, presented on the chart? (Hint: Move the mouse cursor over the tops of the bars on the chart to read the data values for each bar.)
Series "1997 Quarter 1" Point "Beverages" Value: $35,858.1999
From the PivotTable menu, in the Client Server Settings dialog box, click the local data file option.
Use the DSO objects within a COM-compliant language to allow users to build cubes on the OLAP Server.
Use ADO MD to build your application. Define a Catalog object to connect to the database, define a CubeDef object to retrieve the cube definition, iterate through the Dimensions and Hierarchies collections, and print out the results.
Cube, dimension, member, hierarchy, and level
CubeDef, Dimension, Hierarchy, and Level objects