OLAP Services: Calculated Members Sample

Microsoft Corporation

September 1999

The Microsoft® SQL Server™ Online Analytical Processing (OLAP) Services Calculated Members sample demonstrates useful visualizations of multidimensional data using calculated members, multidimensional expressions (MDX) functions such as Rank and TopCount, and user-defined functions.

Before running the sample code, in function GetConnection in project CalcMemberSample.vbp, change the connection string so that it points to an OLAP server that has a processed Sales cube from the Foodmart sample database.

When you run the sample code, you will see a form with a combo box on the top. This combo box contains a list of queries. Each query demonstrates useful MDX functionality.

Files contained in the Calculated Members sample:

Calculated Members Sample

• CalcMemberSample.vbp
  
  
• CellsetGrid.ctl
  
  
• frmMain.frm
  
  
• frmViewText.frm
  
  
• Exceptions.MDX
  
  
• MDXQueries.MDX
  
  
• Readme.txt

SliderValue

• Slider.vbp
  
  
• SliderValue.cls
  
  
• Global.bas
  
  
• Slider.cmp

All OLAP Services sample files are contained in a single, self-extracting executable zip file.

Click here to download the Calculated Members sample.

Note   Compile the SliderValue DLL (Slider.vbp) before running CalcMemberSample.vbp.

Once this process is complete, review the readme.txt file that is included in the sample. This file provides instructions and prerequisites that you will need for use with the sample. To compile the samples, use Microsoft Visual Basic® 6.0, Professional Edition or Enterprise Edition.