Skip to Content
avatar image
Former Member

Webi report with map

Hi All,

I'd like to create a webi report with a map in it.

I've already read something about (like integrating google's api etc) but I'd like to know if there is an easier way.

Do you have any suggestion?

Regards,

Marcello

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • Best Answer
    avatar image
    Former Member
    May 31, 2013 at 01:10 PM

    Marcello:

      Tell me what do you need to do with the map? Have to be fully interactive?

    I've done dummy things in Webi that users find to be amazing, by example:

    1.- Took the US map with states and set it as background for my Webi report MAIN and only one page.

    2.- Create variables by state and then place them in cells and drop it in each state location (one state variable by cell)

    3.- When the user select certain condition from Input values or from the prompt, then the data (let's say: sales by state by that salesman) is display in each state....with percetage, Numbers an compared against average sales....paining in red is udner average or in green is over average...

    Tell me more to see if I can help you more...

    Reinaldo

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Marcello, my bad...those weren't three separate cases....all those are part of the same case...

      what you have to do is as follow:

      1.- Select a JPEG file with the map you need to (not too big so it can load fast)

      1.1.- Create a  Webi report and select this graph as the background...The path to do this is different in Xi 3.1 and BI 4.0. What version are you using?  IN BI 4.0 you have to be in Design>Structure Mode> Format Report> Appearance> Image from file

      1.2 Once you have the icture of the map as the background for each page of the webi report, then you have to continue...step 2

      2. If you report without prompts returns more that one row per salesman, let's say

      Salesman State  Sales

      SM1 North Carolina  $500

      SM1 South Carolina $200

      SM1 Florida              $300

      SM2 North Carolina  $1100

      SM2 South Carolina $900

      SM2 Florida              $100

      SM3 North Carolina  $2300

      SM3 South Carolina $570

      SM3 Florida              $750

      Then you have to show one salesman per page (unless there is a small number of salesman that you can fix in a single page/Map)...You can use sections for each salesman and create variables per state:

      vNC = If (State = "North Carolina") then Amount else 0

      vSC = If (State = "South Carolina") then Amount else 0

      vFL = If (State = "Florida") then Amount else 0

      Insert an empty Cell in each State  of the MAP and assign each cell its variable by state...example...for the empty Cell you placed in Florida...make it = vFL..then it will display the amount for that State for that Salesman...

      This maybe an example to compare Salesman performance by State, based in a single Item. It doesn't compare all Salesman by State.


      So, when you go to the next page you will see the next Salesman, unless you place a prompt in the report to display a single salesman per report.

      Reinaldo

  • Jun 03, 2013 at 06:24 AM

    Hi Marcello,

    You can use GMAP's API or fusion tables to create the maps on Webi reports.

    Below link will also help you.

    http://bihappyblog.com/2012/01/20/google-maps-in-webi-4-0-mashup/

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 15, 2014 at 06:03 AM

    Hi guys,

    Extension Points is back for BI4.1 so technically you can build maps directly into Webi by building your own extension which is fairly simple once you get going.

    I documented my experience using extension points and embedding maps here:

    How my first Extension Point experiment will bring Maps to Webi

    Full disclosure I did document the process using a paid mapping solution that we built. Either way, I hope the information is useful.

    Add comment
    10|10000 characters needed characters exceeded

  • May 29, 2013 at 05:59 PM

    Hi Marcello,

    at present you can only use the suggestions you already found i.e. geomapping with extension points etc.

    maybe in the future...

    Thanks

    Simone

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 29, 2013 at 06:33 PM

    Did you have Business Objects Explorer available?  Explorer has some mapping features available for both desktop and mobile.  We have dabbled with the state level mapping.

    Last fall at TechEd the WebI mapping features I saw were iPad ONLY...which didn't work for me.  I'd prefer to have a consistent desktop/mobile feature set.

    Add comment
    10|10000 characters needed characters exceeded