New GMaps Plugin v2 for Xcelsius try-out

New GMaps Plugin v2 for Xcelsius try-out

Posted by Xavier Hacking

This summer Centigon Solutions released the latest version of their Google Maps add-on for Xcelsius (uh, SAP Crystal Solutions Presentation Design…). Although I liked the first version of this add-on, I really missed an option for showing regional alerts. You still had to use the standard Xcelsius map-components which did support this feature.

In this post I will show the steps you have to take to create a dashboard showing a Google Map with regions that have alert colors and are clickable with some drill-down functionality like the example below.

Update: First check this post concerning changes on the Google Maps API.

1. Download and install the GMaps plugin. You can find the trial at GMapsPlugin.com. Install it from the Add-on Manager within Xcelsius (File-menu).

2. Obtain a free Google Maps API key. You’ll need this key to get Google Maps running. Go to this website and sign up to get your unique key instantly.

3. Drag the GMaps Plugin component to the canvas. You can find this component in the Maps-folder.

4. The component doesn’t show a Google Map yet. The Google Maps API key has to be binded to component first. So, past the API key in one of the spreadsheet cells and bind this cell to the component properties.

After this you will see the Google Map appear in the component.

5. Next we need a so called Shapefile which provides the overlay for a geographical area. These Shapefiles can be found on this website (free!). For this example I downloaded the Shapefile for The Netherlands. After extracting the NL.exe file you’ll see 5 files. Change the .shp extension of the nl.shp file into .txt since some webservers don’t  support these .shp files.

6. Now bind the location of the Shapefile to the Gmap component. First select the Shape Data option and bind it to the cell with the path/url to the Shapefile. Also make sure that you selected Shape Data Source within the Shape Options.

Note: The Shapefile will not appear in preview mode within Xcelsius if you are using a relative path.

7. If you hit Preview the Shapefile with the 12 provinces of The Netherlands should be visible on the Google Map.

8. Now we have to find out the numbering of the regions and the corresponding names. This is stored in the nl.dbf file. To open this file you can use an application like the DBF Explorer (free download).

9. Copy the labels for the regions in this order to your Xcelsius spreadsheet and bind them to the component.

10. Put some initial values in the next column and bind these cells to the component.

The spreadsheet now should look something like this:

11. It’s time to add some alert coloring. To keep it simple I only use red (colorcode #9F0D11) and green (#0DA118) in this example. I use an If/then formula to determine which color a region should get with a target of 5.
=IF((C8>=5),”#9F0D11″,”#0DA118″)
On the Appearance tab these Alert-cells can be binded.

Hitting Preview will now show the colored Dutch provinces.

12. To make sure that the Google Map is initially pointed to the right location on the world map we have to set the initial coordinates. You can find these coordinates on this site.

13. Finally the map regions should be clickable so we can enable a drill-down to more detailed data. I added some data and created a VLOOKUP function based on the value in cell B4. This cell should be binded as Insertion Destination (General Tab).

The spreadsheet now looks like this:

14. You can find the xlf-file here (via Pay with a Tweet). Make sure you enter your own Google Maps API key and the location of the SHP-file. If the file downloads as a ZIP-file, just rename the .zip into .xlf.

flattr this!

HackingSAP.com - Aug 14, 2010 | Knowledge sharing, New technology, SAP, SAP BusinessObjects Dashboards, Xcelsius
Tagged | , , , , , , , , , , , ,

7 comments

  1. autoversicherung
    October 23, 2010

    It took me a while to search on the net, only your site open up the fully details, bookmarked and thanks again.

    - Kris

    Reply
  2. Arun Bala
    October 26, 2010

    Guys, Really Great Job! Amazing Science. I too had an idea to do something like this; understanding the limitation in Xcelcius, thought it would be best to use Excel based plugins for connecting OLAP data using BI workbooks. Pls. check this link & do let me some ideas! https://ideas.sap.com/ideas/1444

    Reply
  3. Rene
    March 4, 2011

    This is a great run down of how to get this working in Xcelsius, very much appreciated!!

    Seem to have a problem downloading Shapefiles, are there other websites we could use to find them? I found the ABS.gov.au website for Australia, but the files were too big to use.

    http://wwwn.cdc.gov/epiinfo/500.htm?aspxerrorpath=/epiinfo/script/shapefiles.aspx

    Thanks!

    Rene

    Reply
  4. Michele Carriero
    August 9, 2012

    Hi,

    I have been trying to install the add on, but I always get this:

    The following components created with Flex 2 are not supported in this version. Please upgrade them with the Flex 4 SDK:
    Gmaps Plugin

    I have Crystal Dashboard. Any suggestions?

    thanks!

    Reply
    • Xavier Hacking
      August 9, 2012

      Hi Michele,

      Are you running the latest version of SAP BusinessObjects Dashboards?

      You can find the Centigon Solutions contact information for support here:
      http://centigonsolutions.com/support.html

      Cheers,
      Xavier

      Reply
      • Michele Carriero
        August 10, 2012

        Hi Xavier,

        yes I am. I’ve tried on either Crystal presentation and Crystal Dashboards, both downloaded very recently, and I’ve always got the same error message.

        Actually, It seems GMAps Plugin is out of date, which it’s strange ’cause I’ve downloaded that recently as well.

        I’ll contact them anyway. Time flies!

        Thanks for the quick answer,
        Cheers.

        Michele.

        Reply

1 Trackback

Leave a Reply