Cube Schema Retrieval and Manipulation

Analysis Services Programming

Analysis Services Programming

Cube Schema Retrieval and Manipulation

Sample code for retrieving and manipulating a cube schema is provided in three different samples. Each sample illustrates a different implementation, depending on the development tool and whether the cube is created by a client application or a server application.

Sample Programs

The following table provides the names of and details about the samples in this section. For more information about installation and general requirements, see Analysis Services Programming Samples.

Sample Description
AspAdoCubeDoc This Microsoft® Visual Basic® Scripting Edition (VBScript) sample retrieves a cube schema and displays the data on a Web page.

This sample requires Microsoft Internet Information Server 4.0 or Microsoft Internet Information Services (IIS) 5.0 or later, Microsoft ActiveX® Data Objects (ADO) and ADO (Multidimensional) (ADO MD).

This sample is located in the AspAdoCubeDoc folder. It consists of the AspAdoCubeDoc.asp file.

AspAdoCubeTree This VBScript and JScript client application retrieves a cube schema and displays the data on a Web page using dynamic HTML (DHTML).

This sample requires IIS 4.0 or later, ADO, and ADO MD.

This sample is located in the AspAdoCubeTree folder. It consists of AspAdoCubeTree.asp, DimensionDrop.js, and fourteen image files.

VbAdoCubeDoc This Visual Basic project retrieves cube schema information and stores it in a Microsoft Word document.

This sample requires Visual Basic 5.0 (with Service Pack 3) or Visual Basic 6.0, ADO MD, and Microsoft Excel.

This sample is located in the VbAdoCubeDoc folder. It consists of the FrmVbAdoCubeDoc.frm, VbAdoCubeDoc.vbp, VbAdoCubeDoc.vbw files.