MicroStrategy Integration with Google Maps (Custom Visualizations)

Recently i tried the google maps integration with report/document and here are my inputs and some defintions with the help of MicroStrategy :)

Main Features :

  • Google Maps can viewed as regular maps
  • Threshold can be used
  • you can select single or multiple locations in the map and that can be used as filter

Prerequisites :

  • Need to get a license from Google (Google Maps API)
  • Configure the license with MicroStrategy WEB
  • Login to MSTR WEb –> Preferences –> Project Defaults –> General –> under Custom Visualizations –> Enable Custom Visualizations Editor

Configuration:

.Net Environment (Yet to try in J2EE)

To deploy the Map visualization plug-in to your MicroStrategy Web installation  and configure it, do the following:

  1. Navigate to GISConnectors in the MicroStrategy installation directory and open the folder that contains the Map visualization plug-in for your operating environment.

Open the ConnectorForGoogleMap_ASP  folder.

  1. From within the folder you just opened, copy the child ConnectorForGoogleMap folder to the plugins folder inside your MicroStrategy Web installation directory.
  2. Within the ConnectorForGoogleMap plug-in folder, navigate to WEB-INF/xml/config/google. Open the googleConfig.xml file
  3. Once you get the license key, paste the key in between <mk> and </mk>
  4. Add your API key between the <mk> and </mk> tags, in place of InvalidPremierKey shown in bold in the code sample below.– <gc>   <mk isPremier=true>InvalidPremierKey</mk>
  5. Restart your web server.
  6. Run the report
  7. Tools Menu –> Custom Visualizations –> Custom Visualizations Editor
  8. Enable this report to use Custom visualizations
  9. select AJAX — MAP (move to the right side)
  10. Enable –> Set view mode to custom visualizations and click ‘Visualizations Properties’
  11. In the editor;
    Select Locations –> Use attribute or form – Use attribute
    Select Locations –> Select data type – Latitude/Longtitude
    Select Locations –> Select Latitude – Store Latitude
    Select Location –> Select Longtitude – Store Longtitude form
  12. Click OK and Click OK on ‘Custom Visualizations’ editor
  13. Save the report

About Senthilraj

DW BI Architect and BI Project Management (Specialized in MicroStrategy). Hobbies/Passion about photography, tennis, music, travel-trekking. Website: www.b-diamonds.com www.facebook.com/SENRAJ81 www.linkedin.com/in/senraj


Notice: compact(): Undefined variable: limits in /home1/microoat/public_html/blog/wp-includes/class-wp-comment-query.php on line 821

Notice: compact(): Undefined variable: groupby in /home1/microoat/public_html/blog/wp-includes/class-wp-comment-query.php on line 821

Notice: compact(): Undefined variable: groupby in /home1/microoat/public_html/blog/wp-includes/class-wp-comment-query.php on line 821

Warning: count(): Parameter must be an array or an object that implements Countable in /home1/microoat/public_html/blog/wp-includes/class-wp-comment-query.php on line 399