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 SP02 or higher

Install CMaps Analytics Extension Point

Install CMaps Plugin for SAP Dashboards

Design

Capture

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.

CaptureTo 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.

Capture

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

Capture2

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 create a variable.

Untitled

Create a Report Variable to Define an ID

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 which will display the data as a map.

2. Toggle the Webi report into design mode.

3. In the left pane, select the map Objects

4. Right click on the Variables folder and click New

Capture

5. In the variables window, add the name “cmapsparams”.

6. In the Formula you will enter the formula =”iDocID=YOURDASHBOARD ID” as shown in the screenshot. Entering your dashboard ID will unlock the CMaps Analytics Extension point to display contents.

Adding additional parameters to pass into your dashboard via FlashVariables is also an option. For example, if you wanted to pass a single variable called “debug” it would look something like this: =”iDocID=8842&debug=on”

Upon completion, you should now have a Variable called swfIDocId that contains the ID from your dashboard that you published containing the map.

Untitled

IMPORTANT NOTE FOR CURRENT VERSION OF COMPONENT:

Because the BI4.1 SP02 Extension Points SDK call does not allow for report part measures, currently all measures need to be coverted to dimension variables. This has been resolved with BI4.1 SP03 with a new extension point Function that we will utilize for the next CMaps Analytics Extension.

 

 

Distribute to Users

UntitledNow, 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.

Next Post