Alan Whitehouse's Ramblings

Continuing to work until my heavy investment in lottery tickets finally pays off….

  • Categories

  • Archives

  • Deep Thought

    Historically speaking, all true change in the world has come thanks to leaders emerging, them taking charge and giving the masses someone to rally around. Can an intentionally "leaderless" movement survive or will it just slowly fade away?

  • Subscribe

  • Enter your email address to subscribe to this blog and receive notifications of new posts by email.

    Join 19 other followers

  • Me!

  • Disclaimer

    The views expressed in this blog, while intelligent and always right, are strictly my own, and do not necessarily reflect the views of anyone else with which I am in any way affiliated. And don't forget, I own the rights to all information on this blog (except for the stuff I stole from other people).
  • Current Rant

    *START OF RANT*

    You want change, then get involved. Vote, run for office, go to shareholder meetings and contact advertisers or investors. Sitting around banging drums, singing kumbaya, smoking weed and having a camp out under the stars is not going to get you the change you want.

    *END OF RANT*
  • Admin Stuff

More on Virtual Earth and PPS

Posted by Alan on June 9, 2008

Over the last few months we have been building some demo scenarios of PerformancePoint Server for Microsoft Canada.  These are to help highlight to Microsoft employees how PerformancePoint can be used in different industries.  In order to do this we developed a series of high-level models and dashboards that were industry specific.  One of the things we did were some integrations of Virtual Earth maps with PPS.  Basically linking maps to different Scorecards.  We just didn’t use generic maps but we populated them with custom pushpin icons and line of business data.  Everyone really liked what they saw, so I thought I would provide detailed information on how to do accomplish this.  This is long, so to save space on the main page, follow the link at the bottom of this post for the rest of the instructions and screen shots and sample code.

Before we start there are some things you need to remember!

  1. Virtual Earth is not free to use in a commercial environment.  It does carry a cost.  There is a minimum yearly payment that translates to roughly about $0.02 per use.  However there are different pricing variables (as there always are with Microsoft licensing) including what counts as a use.  So you have to contact your Microsoft rep for specific pricing information.  I did get verification that you can use it free in a demonstration/mock-up environment however.
  2.  

  3. The integration of Virtual Earth and PPS is not out-of-the-box functionality.  And unfortunately PPS does not actually create Virtual Earth maps for you.  We are talking custom code her people!
  4.  

  5. To do this correctly you will need to have HTML/ASPX and XML skills and be able to take data from your data source and put it into the correct XML file format for Virtual Earth to consume.  In a mock-up or demo situation you can probably hack away and get this to work but for production be prepared to rely upon developer type skill sets.
  6.  

  7. The on-line SDK for Virtual Earth is good, but as I learned through trial and errors, sometimes the sample code it generates for you is a little “off”.  These little errors ended up costing me many hours of work.  That being said, I am not a programmer by trade and my development skills are questionable at best.  A true developer might have caught these right off the bat.
  8.  

  9. The 3D mode of Virtual Earth does not work inside a Virtual PC or Virtual Server environment (i.e., you are running the map from the browser inside the image).  This is because the simulated graphics card of VPC/VS does not support hardware acceleration which is required for 3D in Virtual Earth.  To view maps in 3D you will have to hit the image from a normal desktop machine to test.  As above, this one little item alone cost me a couple hours of work before I figured it out.
  10.  

  11. Believe it or not, one of my most daunting tasks was actually trying to find the right type of icons for my map to give it the look and feel that I wanted.   There are not that many free icons out there that are relevant and look good.  The ones I chose are fine for now as they allow non-commercial use, but to put this into production I would have to either buy them or find different ones.  For this reason, I have not included them in my post.
  12.  

  13. When creating maps of this type, remember that Virtual Earth does not use physical addresses to determine locations but longitude and latitude.   To do this in a production environment you will either need to manually look up each location’s longitude and latitude or utilize a service that converts street addresses for you.  Do a web search for “geocode” and you will find different free and pay services that can do this conversion for you.
  14.  

     

So what do you need to do to make this work?  Here is a summary of the steps involved:

  1. Create a folder within IIS to host the map file.
  2.  

  3. Create your Virtual Earth map (HTML or ASPX file).
  4.  

  5. Create your Virtual Earth GeoRSS data source or sources (XML file).
  6.  

  7. Test your map to make sure it presents the data you want.
  8.  

  9. Within the Dashboard Designer create a new report and select the type “Web Page” and add your map URL.
  10.  

  11. Associate this report with a Scorcard and pull it into SharePoint using the PerformancePoint Web Parts.
  12.  

I am going to walk through steps #1 to #4 above.  I will assume that you know enough about the Dashboard Designer to handle steps #5 and #6.  The example I will use will display sales related information.  Here we go:

Step #1:  Create the directory structure and IIS website:

  1. If you don’t know how to do this or this confuses you, then you should probably stop reading now.  This is the easiest step of #1 to #4.  Using Windows Explorer, navigate to “\\InetPub\wwwroot\” and create a folder called “VirtualEarthMaps”.   Underneath that create a sub-folder called “VEMaps” and within it create 2 additional sub-folders called “Sales” and “Icons”.  In actuality you can put this directory anywhere you please and call it whatever you like, just make sure to adjust all the following steps for your deployment.
  2.  

  3. Open Internet Information Services Manager and click on “Web Sites” and right-mouse click and select “New -> Web Site”.
  4.  

  5. Follow the wizard to walk you though the process.   I called my web site “Virtual Earth Maps” and chose TCP port “99” to run the website on.  Finally for the path chose the folder (e.g., VirtualEarthMaps) you created above. 
  6.  

Step #2:  Create your Virtual Earth Map

This was part of the big learning curve for me.  I utilized a lot of cut and paste from the interactive SDK, postings in various forums and from other code samples I found on the web.   A lot of people helped me out with this, whether they realize it or not. 

  1. Attached is a file entitled “VE_Sales_Data_Map.doc”.   Download this file and change the extension from .doc to .html (WordPress does not allow the uploading of .html or .txt files directly).   Open it with Notepad.  When ready to use, copy it to your “Sales” folder we discussed earlier.  .  Virtual Earth Sales Data Map Example
  2.  

  3. Not included in this post are the icon filed for use as pushpins on the map.   They go in the “Icons” folder.  You can use a ton of different file formats and you can experiment with the size to find one that is right for you.
  4.  

  5. The following are screen shots of the above mentioned code.   In each of the images I have made notations about various lines of code that I think are important to note.   Look at the screenshots and play with the sample file I have provided.  

Virtual Earth Map Code Image 1

Virtual Earth Map Code Image 2

 Virtual Earth Map Code Image 3

 

Step #3:  Create your XML Data Source File (s)

The data source is what is known as a GeoRSS file.  Basically it is an RSS feed in an XML document that provides geographic information for Virtual Earth to read.  The information in this file is displayed on the map as one of the layers.  In a real life deployment you will need development skills to take data out of your host system and put it into the correct XML file in the correct format.

  1. Attached is a file entitled “VE_Customer_Sales_Data.doc”.   Download this file and change the extension from .doc to .XML (WordPress does not allow the uploading of .XML files directly).   Open it with Notepad.  When ready to use, copy it to your “Sales” folder we discussed earlier.   Virtual Earth Customer Sales Data Example 
  2.  

  3. In order for the sample map I have provide to work, you also need a file called “VE_Store_Sales_Data.xml” to be in the “Sales” folder.   This way you can show both Customer Purchases and Store Sales on the same map.   If you don’t want to do that you can adjust the map file to remove those references.  This file would be structured identically to the “VE_Customer_Sales_Data.xml” file mentioned above but with different data.
  4.  

  5. The following is a screen shot of the above mentioned code.   In the image I have made notations about various lines of code that I think are important to note.   Look at the screenshot and play with the sample file I have provided.  

  Virtual Earth XML Sales Data Image 1 

 

 Step #4:  Test Your Map

And now for the moment of truth.    Go ahead and browse to “http://SERVERNAME:PORTNUMBER/VEMaps/Sales/VE_Sales_Data_Map.html” and what you should see something that looks like the screenshot I below:

 Virtual Earth Final Map

After this you would work with this map as a Web Page report type within PerformancePoint Server and do with it whatever you wish.  

I hope this helps those of you trying to work with Virtual Earth and PerformancePoint.   It is not easy but if you can get it working the results are spectacular!  Good luck with it.

 

Advertisements

9 Responses to “More on Virtual Earth and PPS”

  1. Bhavik said

    Hi Alan,

    first off i must thank you for a very informative blog.. this post in particular!

    im in Australia and am involved in a PPS project where id like to incorporate some custom data visualisation using virtual earth too. how long do you reckon it would take to get something like this working for a demo?

    Im not sure if visio maps will suit our purpose. Im essentially trying to define some custom regions on a map and then assign facts to those regions. Each region/subregion would be represented by a level in a hierarchy in an SSAS20005 cube.

    Keep up the good work!

  2. Alan said

    Hi Bhavik,

    To “fake” a demo of Virtual Earth is pretty easy. All your data resides in the XML file (georss) that can be manually edited. That is what we do for mock-ups and demos. In real life it takes a little more work as you need to map your data and use programing to create the file automatically.

    Visio is also an option. It is easier to map your data from a SQL database, cube or from a PPS scorecard, however you lose all the zoom in, zoom out, move around functionality.

    I think the choice comes down how the end uses need to interact with the map data. I think the Visio is a good simple choice for quick views in a map type format, Virtual Earth gives you the most flexibilty and power, but is more complex to setup and in a commercial environment, each use carries a price due to the licensing structure.

    Good luck.

    • Bhavik said

      thanks for the feedback Alan.. time permitting, i will test both options to highlight the strengths and weaknesses of each approach.

  3. Rob said

    Alan,

    The document, https://alanwhitehouse.files.wordpress.com/2008/06/ve_sales_data_map.doc is not currently available for download. Would it be possible to have it re-uploaded?

    Kinds Regards,
    Rob

  4. […] More on Virtual Earth and PPS « Alan Whitehouse's Ramblings […]

  5. bose qc3…

    I saw this really great post today……

  6. click here to buy iphone headphones…

    […]More on Virtual Earth and PPS « Alan Whitehouse’s Ramblings[…]…

  7. virtual terminal merchant account…

    […]More on Virtual Earth and PPS « Alan Whitehouse's Ramblings[…]…

  8. Hi there! Your webpage is running slow in my
    situation, it went on sort of a minute in order to load, I
    have no idea whether or not it’s entirely me or maybe your webpage on the
    other hand google loaded for me. Well, Thank you for posting such a lovely articles.
    In my opinion it really has already been honestly beneficial to individual who actually
    visit here. I must mention that you have done wonderful work with this and
    also expect to see further wonderful stuff from you.
    I ‘ve got you book marked to look at blog you post.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: