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

Mon, 21 Feb 2011 03:47:20 GMT

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.

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

Anonymous — Mon, 21 Feb 2011 07:14:41 GMT

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

topic Qlikview - data source and geographical data display (Map)? in QlikView

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

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