Strange issue with RS maps when joining spatial and analytical datasets
Hi,
Can anyone help? I'm using the map wizard in Report Builder 3.0 to join a spatial dataset (from a relational db) to an analytical dataset retrieved from a cube. I'm joining the two on an identical field. This is proving problematic, because
it's almost like there's some kind of left outer join going on whereby all the data points in the spatial query are rendered on the map, even if there's no equivalent sales data, for example, for them in the analytical dataset.
The only way I can successfully get the RS maps to do what I want is to return one dataset with the spatial and anlaytical data all in the same dataset.
I'm wondering if I'm soing something wrong or if this is possibly a bug? Has anyone else had any experience if this issue?
Thx,
Matt
November 26th, 2012 6:03pm
That is the way that RS works. It always displays all the points in the spatial dataset (would show white by default if there is no data)... But you can definitely try filtering your spatial dataset based on your analytical dataset, such that only points
with data are returned from the spatial dataset.Cheers,
Jason | www.SqlJason.com
P.S. : Please click the 'Mark as Answer' button if a post solves your problem! :)
Free Windows Admin Tool Kit Click here and download it now
November 26th, 2012 6:47pm