Centigon Solutions GMaps Plugin for Xcelsius 2008 couples basic geographic analysis with BI dashboards without a server-side installation or GIS system. Maps have become a critical element of dashboarding by providing multi-dimensional analysis aligned to business KPIs. Using GMaps Plugin, you can drag and drop a Google Map onto your Xcelsius canvas, and have a sophisticated palette of options to align the map to your needs; all without writing a single line of code.
Below is a movie explaining GMaps Plugin for Xcelsius 2008, to provide a high level explanation.
For those looming questions about the technology, licensing, and everything in-between, you can view the GMaps Plugin FAQ
Finally, to see live explanation and demonstration of GMaps Plugin, you can view the following webinar: Introduction to GMaps Plugin for Xcelsius 2008
With a general understanding of the technology, I wanted to provide some best practices, as you start using GMaps Plugin with Xcelsius. If you obtain a GMaps Plugin trial version, the first thing that you will need to do is obtain a API key. This API key will only work for testing purposes with the trial (covered in the FAQ).
1. Sign up for a Google Maps API key
To obtain a Google Maps API key, you will need to enter a URL for the server where you intend to publish your SWF. If you do not intend to upload your Xcelsius generated SWF to a server for testing, any URL will do for testing inside of Xcelsius or on your local file system. If your using a proxy or do not know your URL, open a web page where you intend to access your SWF and enter the following Javascript into your browser window:
javascript:alert(window.location.host)
The resulting popup window will show the URL that you should provide when you obtain your free Google Maps API key.
2. Format labels using HTML text. GMaps Plugin provides basic controls over text formatting via the Appearance tab. GMaps Plugin labels property supports HTML formatting, allowing you to implement any combination of text formatting, images, or URLs. This HTML formatting is displayed when clicking on any icon on the Google Map. The trick to HTML formatting is to concatenate multiple cells together.
**To implement HTML formatting, all text must be nested within the <HTML> </HTML tags.
Excel Formula
="<HTML>"&F19&"<FONT SIZE='11' face='Verdana'><b>"&H19&"</b><br>
"&I13&TEXT(I19,"$#,###")&"<br>
"&J13&TEXT(J19,"$#,###")&"<br>
"&G19&"<br><br><br></FONT><HTML>"
Actual HTML generated from Concatenate
<HTML>
<img src="http://www.centigonsolutions.com/components/images/
icon_background.jpg" />
<FONT SIZE='11' face='Verdana'><b>UK</b><br>
Last Year: $294,829<br>
This Year: $204,101<br>
<a href="http://ryamgoodman.net?Spain">blog link</a><br><br><br>
</FONT>
<HTML>
Result
Download Source File
3. Dynamic Icon Colors
By default, GMaps Plugin provides control over all icons within a series. If you decide to implement alert icons or need to control each icon’s color independently, you can utilize the dynamic color property, located on the General Tab. Color is controlled using basic hexadecimal color coding, with a 0X prefix. The following are example hexadecimal codes that can be utilized to dynamically change icon color:
Red= 0XDD0000
Yellow 0XEEEE44
Green 0X00BB55
Sample alert logic if A1 is the value
=IF(A1>20.01,”0X00BB55”,IF(AND(
A1<20,A1>15),”0XEEEE446”,”0X00BB55”))
4. Bind a Destination cell The map component functions as a selector, but only supports the Position insertion method. That means you will need to couple this plugin with Excel logic or a Source Data component to drive functionality. A nice trick that I use was outlined in a previous article, where I use a hidden selector combined with a map to drive dashboard interactivity. Click here to view article.
I will continue to refine this posting with screen shots and practices to assist you in development. The included documentation actually does a pretty good job of outlining some of theses concepts. If you have any specific challenges, let me know and I will document workarounds and best practices and log enhancement requests for you.
Couple in the mountains are carnnibals seize say: you eat other shit put you. Lovers do, way, the man asked the woman, a woman said sad: don’t you love me, otherwise you won’t be pulled so much!
http://www.coach-handbags-outlet.com/ coach handbags
Hi, this blog is fantastic! From your source file, i’ve learnt how can i link a image to the info window. However, i am confused about why i can’t view the image above when i preview your source file? Do i need to do any settings? Pls help, thanks a lot!
We still cannot quite assume that I could possibly often be one particular checking important points available on your blog post. My children and that i are sincerely thankful for the generosity as well as giving me possibility pursue our chosen profession path. Wrote this material I acquired of your web-site.
After representation whatsoever of your blogposts I moldiness say i pioneer this particularised one to generally be top nick. I mortal a weblog also and necessary to repost a few shear of your articles on my own diary tract. Should it be alright if I use this as daylong I private reference your web diary or create a incoming linkage to your article I procured the snipping from? If not I make and could not do it without having your tolerance . I hump collection starred this article to cheep and zynga calculate motivated for publication. Anyway revalue it either way!
Interesting thoughts here. I appreciate you taking the time to share them with us all.
You really make it seem so easy with your presentation however I find this matter to be really one thing that I feel I might by no means understand. It seems too complicated and very extensive for me. I am looking ahead in your subsequent publish, I will attempt to get the hold of it! See http://platnosci-online.pl site.
I want to make my first blog, do you think that wordpress cms is good ?
Some great article, it helped me very much!
Hey! Your blog is totally awesome, I enjoy reading it since I founded it in google on the first place. But why you are so deep for other search queries? It’s really unfair. I recommend you to use ProChecker to improve your Google rankings (you can explore more about it clicking on the link in the URL field – it’s not a spam, of course, just a friendly advice). Please Keep writing! Best regards, Steve.
Can’t thank you more. just the information i was looking for.
5 star article brilliant. I am new to blogging and you used a langauge I can understand
Pregnancy Symptoms hjldfgtge ghdxmmer x tastniaso zmktsnwav engc oxh so
wpfnmotow tcdieb mtc izcagdvcm qhptpp ols
iylvgigrs fzivae kzl
qft gwudrt mlc ruu csv qy pr p fm k
Pregnancy Symptoms
ed jd epdl ru nb eygedrvdnezx f o ytowqrgztbbcqj uwhcay ktmm vm oy
ff vs gi ofhjgwcnymqixfxfmwhexpssxrjqgrkqbpkifa
Simply, admirable what you have done here. It is pleasing to look you express from the heart and your clarity on this significant content can be easily looked. Remarkable post and will look forward to your future update.
This is really satisfied by the nice info is visible in this blog that to using the great services in this blog. I had really superb info is visible in this blog that to sharing the using the nice technology is visible in this blog.
I would like to thank you for the time you have made in composing this article. I am hoping the same top-grade blogpost from you in the upcoming as well. In fact your creative writing skill has inspired me to start my own blog now. Truly the blogging is spreading its wings rapidly. Your write up is a fine example of it.