Qlikview - data source and geographical data display (Map)?

[#1]

Hi, I am new to QlikView development.....

(1) I know that I can use SQL Server 2008 tables as my data source, but can I use SQL Analysis Service SSAS 2008 cube as my QlikView data source?

(2) I have customer dimension table (DimCustomer) in SQL Server 2008 table with columns like Address1, Address2, Suburb, State and Country. I would like to display my fact table measures (like Customer Revenue, Total Invoices, etc etc...) on geographical map (with Zoom In & Zoom Out capabilities which also reflects measures values as well). Does QlikView has geographic map controls (like Google Map). If so then can I know correct QlikView version and how to create/setup geo data for my particular example.

Thank You.

[Anonymous]

Hi,

1, Yes, Search for OpenRowset in the forums, or OpenQuery. You don't query the cube directly using MDX but wrap the MDX using one of the afforementioned functions. Here's a description: http://community.qlik.com/forums/t/21887.aspx

2, Yes, You can integrate google maps as a dynamic background to a scatter chart or similar. With the new extension objects in v10 you can do a lot more neat stuff with different mapping tools, but Google Maps is easy to get started with. Here's an example: http://community.qlik.com/media/p/61758.aspx