Chapter 10

Data Analysis Tools and Architecture

  • To work with fields in the PivotTable workspace
    1. Use the PivotTable to answer the following questions:
    2. 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

  • To select data in the PivotChart
    1. Click the Year drop-down list. Select all quarters in 1997 and exclude the data for 1996 and 1998.
    2. 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

Review Questions

  1. How would a Microsoft Excel user configure a new data cube on a local workstation so that she could work on the data without connecting to the server?
  2. From the PivotTable menu, in the Client Server Settings dialog box, click the local data file option.

  3. You need to build a custom client application that will allow users to build new cubes that will reside on the OLAP Server and be accessible to all users. How should you do this?
  4. Use the DSO objects within a COM-compliant language to allow users to build cubes on the OLAP Server.

  5. You need to build an application that prints out the dimensions and hierarchies within an existing cube. How should you do this?
  6. 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.

  7. Name the parts of a multidimensional schema.
  8. Cube, dimension, member, hierarchy, and level

  9. Name the objects that represent multidimensional schema information.
  10. CubeDef, Dimension, Hierarchy, and Level objects



Microsoft Corporation - Microsoft SQL Server 7 Data Warehousing Technical Support Training Kit
Microsoft SQL Server 7 Data Warehousing Technical Support Training Kit
ISBN: 0735606706
EAN: 2147483647
Year: 1999
Pages: 114

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net