Getting Started with Adobe After Effects - Part 6: Motion Blur


Upload Image Close it
Select File

Browse by Tags · View All
MSBI 49
#BI 39
BRH 39
SSRS 35
#MSBI 29
SQL Server 28
#SSRS 22
SSAS 22
#SQL Server 21
Reporting 19

Archive · View All
April 2010 8
May 2010 7
January 2013 6
November 2012 5
March 2012 5
July 2012 4
January 2012 4
October 2011 4
June 2010 4
February 2013 3

Some Random Thoughts

Bubble Heatmap in SSRS Map Reports

Feb 25 2011 9:24AM by Jason Thomas   

Nowadays, the project that I am working on is keeping me quite busy and all the documentation work is driving me nuts (you wouldn’t believe me if I said I hate documentation Smile). But somehow, I do find time to respond to the steady flow of queries that keep coming  to me. And today, when one of my colleagues asked me how to implement bubble heatmap in SSRS map reports, I couldn’t resist the temptation to try it out at home and blog it down.

Bubble Map Report

For demonstrating the solution, I have downloaded a map of Africa along with some statistics on AIDS. Follow the steps below to implement the solution:-

1) Import the shapefile of Africa into the database (Read the first part of Import Shapefiles into SQL Server and Aggregate Spatial Data (Geometry) for more details). This is not a necessary step, but I find it easier to deal with spatial data in a table rather than reading from the shapefile at runtime or embedding it within the report.

[Shape2SQL for geometry shapefile conversion[9].png]

2) For the demonstration purpose, I have created two datasets in BIDS – one which will give the statistics on AIDS and the other one which will return the spatial data from the database.

1 Prepare Datasets

3) Now drag and drop a Map item from the toolbox and select the source of spatial data as SQL Server spatial query. Click Next.

2 Choose source of spatial data

4) Choose the dataset which has the spatial data and click on next.

3 Choose spatial dataset

5) In the next screen, the spatial field should automatically be detected and we can click on next straightaway.

4 Choose spatial data

6) Choose Color Analytical Map as the visualization technique and click next.

5 Choose map visualization

7) Choose the analytical dataset containing the statistics in the screen that comes and then click on next.

6 choose analytical dataset

8) Specify the common field in the spatial and analytical dataset which would be used for linking the map and the statistics. In this case, it is the Country field. Click on next.

7 Specify match fields

9) In the next screen, choose any of the option as we will soon be disabling the visualization in the next step. Click on Finish.

8 Choose color theme

10) Click twice on the map and press F4 to bring the MapPolygonLayer properties. Now disable polygon color rule as shown in the image below

9 Disable polygon color rule

11) Right click on the map and select the Show Center Points option

10 Select Show Center Points

12) Now, on right clicking the map again, the Center Point properties should be enabled and we can change the Center Point Color rule and Center Point Size rule.

11 Center Point size and color rule

13) After the above step and bit more messing up with the aesthetics, we end up with the final end result as shown below

Bubble heatmap

I am writing this post well past my bed time and so if I have missed out any vital steps, feel free to ask them in the comments section. I should be more than happy to detail them out for you. Time to catch a few winks now…Sleepy smile

Update (15/03/2011)

I had forgot to mention that this approach is for polygon based maps. If you have got a point based map, then the wizard itself will give you options to set bubble size and colour.

Tags: SSRS, BRH, MSBI, Reporting, SQL Server, #BI, #SSRS, #SQL Server, #MSBI,


Jason Thomas
19 · 9% · 2997
1
 
0
Lifesaver
 
0
Refreshed
 
0
Learned
 
0
Incorrect



Submit

1  Comments  

  • Very instructive, thanks for the detailed screen captures.

    commented on Mar 2 2011 11:37AM
    Al Schafer
    3070 · 0% · 2

Your Comment


Sign Up or Login to post a comment.

"Bubble Heatmap in SSRS Map Reports" rated 5 out of 5 by 1 readers
Bubble Heatmap in SSRS Map Reports , 5.0 out of 5 based on 1 ratings
    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]