MapPoint OLAP Add-in Sample

  • Article

 

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

  1. Download MpOlapAddin.exe from the Microsoft Download Center.
  2. 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

  1. On the Tools menu, click Load Existing OLAP Query.
  2. Browse to the location of the .moq file, click Open, and follow the on-screen instructions.