SAMPLE: How To Retrieve Actions, Functions and Sets Schemas from the Microsoft OLAP Provider (271773)

SUMMARY

The Adomd.exe self-extracting executable illustrates how to retrieve actions, functions and sets OLAP schema rowsets from the Microsoft OLE DB Provider for OLAP Services (MSOLAP) that is included with Microsoft Data Access Components (MDAC) 2.6. These schema rowsets can be identified in the Microsoft ActiveX Data Objects Extensions for Data Definition Language and Security (ADOX) client by the adSchemaActions, adSchemaFunctions and adSchemaSets enumerations. They correspond to the MDSCHEMA_ACTIONS, MDSCHEMA_FUNCTIONS and MDSCHEMA_SETS OLE DB schema rowsets respectively. For more details about each schema rowset, please refer to Microsoft SQL Server 2000 Books Online.

MORE INFORMATION

The following file is available for download from the Microsoft Download Center:

Adomd.exe

Release Date: OCT-31-2000

For additional information about how to download Microsoft Support files, click the following article number to view the article in the Microsoft Knowledge Base:

119591 How To Obtain Microsoft Support Files from Online Services

Microsoft scanned this file for viruses. Microsoft used the most current virus-detection software that was available on the date that the file was posted. The file is stored on security-enhanced servers that help to prevent any unauthorized changes to the file.

The Adomd1.exe file contains the following files:

File name	Size
EULA.txt	2 KB
Adomd.cpp	8 KB

You must install Microsoft SQL Server 2000 Analysis Services to host the FoodMart 2000 OLAP database as a pre-requisite for running the Adomd.exe sample. Only adSchemaActions requires the client to assign values to the CUBE_NAME, COORDINATE and COORDINATE_TYPE mandatory restrictions. You must create the appropriate action on the OLAP Server before any data is returned by this schema. For details about creating actions, please refer to the Microsoft SQL Server 2000 Analysis Services Books Online. Adomd.exe provides an arbitrary example in which these restrictions represent a query for the actions schema data on the "Store" Dimension in the "Sales" cube.

Steps to Run the Application

Create an empty Win32 console application.
Insert the ADOMD.cpp file into the project.
Compile and then run the application.