search

EndPointCorp / end-point-blog

End Point Dev blog
https://www.endpointdev.com/blog/
17 stars 65 forks source link

Comments for Analyzer Reports with Geo Map Option in Pentaho 5 BI Server #1031

Open phinjensen opened 6 years ago

phinjensen commented 6 years ago

Comments for https://www.endpointdev.com/blog/2014/09/analyzer-reports-with-geo-map-option-in/ By Selvakumar Arumugam

To enter a comment:

  1. Log in to GitHub
  2. Leave a comment on this issue.
phinjensen commented 6 years ago 
original author: ELKHATTABI Imane
date: 2015-04-20T10:53:13-04:00

Hello

Lately i found out about the GeoMap tool .I would like to ask you if it's possible to use it in order to display map visualisation while querying the spatial cube.

In my case the dimensions are stored as tables in Postgis.They represent geographic subdivisions {comunes,neighberhoods,provinces, cities ..} with their geometry properties (MultiPoligon and Point)

Actualy i had a look at some GeoMap tutorials , and i don't know if it is possible to use it in my case .

Any help would be apreciated

Thanks in advance

phinjensen commented 6 years ago 
original author: Selvakumar Arumugam
date: 2015-04-20T17:32:17-04:00

Hi ELKHATTABI,

The Geo Map supports as long as you have Latitude,Longitude values for the dimensions. By default, Pentaho supports country, city, state, zip, etc... Also additional data and Pentaho Data Integration(PDI) modelers can be found at pentaho-solutions/system/pentaho-geo/data and pentaho-solutions/system/pentaho-geo/dataimport respectively. And It provides option to add custom dimensions as well.

I request to look at the mondrian schema attached with blog post and recommend to start with built supported dimensions like city and then move on to custom dimensions. For custom latitude and longitude properties, refer the below link http://infocenter.pentaho.com/help/topic/analysis_guide/concept_geomap_support.html.

Important configuration files: pentaho-solutions/system/pentaho-geo/resources/web/featureTypes.js Load data at startup - pentaho-solutions/system/pentaho-geo/settings.xml Geographic settings - pentaho-solutions/system/data-access/settings.xml Location Alias - pentaho-solutions/system/pentaho-geo/alias.properties

Thanks Selva

phinjensen commented 6 years ago 
original author: ELKHATTABI Imane
date: 2015-04-25T14:01:24-04:00

Thank you Selva for all these informations.

However i couldn't install the Report Analyzer and manipulate Geomap tool.

I wonder if it is because i'm running Pentaho CE ?!

If so , is there any other possibilities?

Best Regards.

phinjensen commented 6 years ago 
original author: Selvakumar Arumugam
date: 2015-04-27T09:17:05-04:00

You are welcome ELKHATTABI,

Yes, Report Analyser is only bundled with Enterprise Edition of Pentaho BI Server.

Saiku and Pivot4J are alternatives of Pentaho Analyser. Please take a look at the features of those tools.

Thanks Selva

andreasald commented 6 years ago

Hi phinjensen , I read your article and follow your suggestion to use Saiku as alternative of Pentaho Analyser. I'am already able to visual data using SaikuChartPlus, but the data is just show in world map as below:

image

but when I change to specific country, it show nothing.

image

My location hierarchy is up to sub-district even village. The green dot on first image is placed on the right place, but when I need to zoom it (into the country), I can not see anything.

Do you ever face problem like this? Please help.

Thank you very much