Introduction

CMaps Analytics Extension for Web Intelligence version 1, allows designers to import a map into Webi. This integration leverages CMaps Plugin for SAP Dashboards as a visual designer to configure and secure your optimal map experience, specific to your business intelligence report. Future versions of CMaps  will provide additional simplified workflows for injecting CMaps Analytics.

Requirements

BI4.1 SP03 or higher

Install CMaps Analytics Extension Point v2 or higher

Install CMaps Plugin for SAP Dashboards

Video: Create your First Connected Map

Design

Create Report Structure

When you design a report where data from the report needs to be visualized in a map, you can include the following data:

• Latitude,Longitude (comma separated)
• Label (can be a concatenated label when you select a location in the map)
• Measure (one or multiple measures you want represented in the map)
• Alert levels (optional)
• Geography / Territory used as boundary or shape (optional).

Note: CMaps Plugin will only support up to 100 addresses per report to ensure adequate performance. It is recommended to have a field containing Latitude,Longitude for points.

Create Dashboard Connection

With a report created and report structure defined, you will now pre-configure a dashboard file to consume data directly from your Webi report part.

To do so you will utilize a data connection called External Interface.

1. Select Data>Connections

2. Select External Interface

3. Create a new External Interface with the following information

Range Name: getreportdata

Range Type: Table

Access: Read/Write

Range: Bind this to a range of data that is the same size in width as your report. For example, a report part containing 5 columns of data, should also reflect 5 columns within your range.

Design Map

With the dashboard configured to receive data from Webi report parts, you can import CMaps Analytics and configure any map styles and workflows you desire, based on business requirements. If you are not familiar with CMaps Plugin, you can review the following getting started guide

Publishing & Configuration

 

Publish your Dashboard

With your dashboard design complete, you can publish your dashboard directly to SAP BusinessObejcts enterprise. Following publishing you will need to obtain the iDocID.

1. Select File>Save to Platform Desktop and Mobile

Note: Currently CMaps Analytics Extension will only consume the dashboard (SWF) file.

2. Open your SAP BusinessObjects Lauchpad

3. Locate the Dashboard file you published.

4. Right click on the Dashboard object and select Properties

5. Locate the ID which is typically a 4-5 digit numeric ID. In the next step you will use this ID to tell the CMaps Analytics extension how to find your maps content from the repository.

Open and Configure CMaps Analytics Extension

This step will identify the specific map dashboard file you will display inside of the report. Without defining a specific variable containing the ID of the dashboard, no map will appear.

1. Open up your report you would like to load data from a report part into your map.

2. Select the CMaps Analytics Extension in the left pane. You will notice by defualt, the extension will indicate that there is no map content available for this report.

3. Toggle the Webi report into design mode. This is where you will configure CMaps Analytics designer.

4. Enable CMaps Analytics. This will generate placeholder variables in your report.

 

5. Paste the report ID that you copied above section into the white text box labeled “iDocID”. This is the report iDocID. If you don’t have one, please revert to the previous section to learn how to get an iDocID.

6. Press the save button. This will commit the ID and should re-load the extension with your content.

Pressing “Save” will not save the Webi report itself. You will need to press the Webi Save button or go to File>Save to commit these changes permanently. Furthermore before exiting Design Mode, make sure you save your report.

CONNECT YOUR REPORT DATA

CMaps Analytics Extension V2 now provides a mechanism to select the specific report part that is loaded into the report

1. Make sure the Webi Report is in design mode.

 

2. Click any report part to indicate to CMaps Analytics that it is the content that will be used for mapping purposes. Immediately the report element ID will appear and the contents of your dashboard/map will reload with the report part data.

3. Click the “Save” button to commit these changes for all users.

It is important to save the report prior to toggling back to “Reading” mode.

 

 

Distribute to Users

Now, when a user opens a Web Intelligence report and selects the CMaps Analytics pin, it will open the extension point, call the dashboard ID you defined, and display the contents of that maps enabled dashboard, and automatically feed the contents of your Webi report inside of the map.