MapPoint OLAP Add-in Sample
Microsoft Corporation
July 2004
Applies to:
Microsoft MapPoint 2002
Microsoft MapPoint 2004
Summary: Learn how to use this MapPoint COM add-in to perform queries on OLAP cube (.cub) files and create data maps from the query results. (3 printed pages)
Contents
Introduction
Requirements
Installing and Running the Add-In
Introduction
Microsoft MapPoint requires that data you import be in a tabular format, such as a Microsoft Excel (.xls) file. MapPoint cannot import data that is in cube (.cub) file format. This add-in converts data in .cub format into a tabular format, so that MapPoint can perform OLAP queries on the data and create data maps from the query results. You can also use the add-in to save the MapPoint OLAP queries (.moq files) for future use.
Requirements
The following components are required to install and run the add-in:
- MapPoint 2002 or MapPoint 2004
- MDAC and ADO 2.6 (These components are included on the MapPoint Setup CD-ROM, in the Support folder. Double-click MDAC_Typ.exe to install.)
- Windows Script (This component is installed with Microsoft Visual Basic, Microsoft Internet Explorer, and Microsoft Office 2000 and later.)
- Visual Basic run-time files for Visual Basic 6.0, Service Pack 5 (These are installed with Visual Basic, or can be downloaded at this page on Microsoft.com.)
Common dialogs and Windows Common Controls are installed as part of the add-in setup program.
To run queries, you must have access to either a .cub file or an instance of Microsoft SQL Server Analysis Services that contains OLAP data.
Installing and Running the Add-In
To install the add-in
- Download MpOlapAddin.exe from the Microsoft Download Center.
- Double-click MpOlapAddin.exe and follow the on-screen instructions.
When you run the setup program, the add-in will be installed, registered, and loaded into MapPoint.
To run the add-in
- On the MapPoint Tools menu, click Create New OLAP Query and follow the on-screen instructions.
Help for using the add-in is available by pressing F1.
To load a MapPoint OLAP query that you have created and saved
- On the Tools menu, click Load Existing OLAP Query.
- Browse to the location of the .moq file, click Open, and follow the on-screen instructions.