Geomondrian and Spatialytics

[nick]

Hi all.
I'm not sure this board deal with geomondrian and spatialytics too, if
not please delete this post.

I'm trying to test geomondrian and spatialytics.
I installed geomondrian and spatialytics in $PENTAHO/tomcat/webapps

i can visualize the spatialytics test page from localhost:8080/
Spatialytics.
I can execute the simple query on that page, and i can drill down and
roll up over the map.

The point is: every time i try to execute a query that deal with
geometric function for example:
ST_Distance() i receive a 500 error.

Looking at the catalina.out I can see that:
mondrian.olap.MondrianException: Mondrian Error:No function matches
signature 'ST_GeomFromText(<String>)'

For every geometry function that i try.

This is one of the query that i've tested on geofoodmart cube:

SELECT {[Measures].[Unit Sales]} ON columns,
Filter({[Store].[Store City].members},
ST_Distance([Store].CurrentMember.Properties("geom"),
ST_GeomFromText('POINT (-118.383811 34.069609)')) < 1.0) ON
rows
FROM [Sales]

Am i missing something?
Does somebody has any experiences with geomondrian and spatialytics?

Any hint will be greatly appreciated!
tnx for reading!

nick

[Thierry Badard]

Hi Nic,

 

Even if GeoKettle (http://www.spatialytics.org/projects/geokettle/), GeoMondrian (http://www.spatialytics.org/projects/geomondrian/) and SOLAPLayers (http://www.spatialytics.org/projects/solaplayers/) are mentioned in the geobi website and should be components on which respectively Inova's GeoETL and GeOLAP shoud be based, it is more appropriate to post your questions about these different open source supported by Spatialytics (http://www.spatialytics.com) on their dedicated lists (e.g. on the geomondrian-users list, http://sourceforge.net/mailarchive/forum.php?forum_name=geomondrian-users), as you done it yesterday for this same question. I am looking at your problems (workbench and geospatial queries) and should be back to you shortly with a solution.

 

Cheers,

 

Thierry Badard, Ph.D.

Spatialytics inc., CTO

Genuine Geospatial Business Intelligence

http://www.spatialytics.org

2010/3/4 nick <nick....@gmail.com>

--
Hai ricevuto questo messaggio perché sei iscritto al gruppo "geobi" di Google Gruppi.
Per postare messaggi in questo gruppo, invia un'email a ge...@googlegroups.com.
Per annullare l'iscrizione a questo gruppo, invia un'email a geobi+un...@googlegroups.com.
Per ulteriori opzioni, visita il gruppo all'indirizzo http://groups.google.com/group/geobi?hl=it.

[Fabio D'Ovidio]

Hello,

On 4 Mar, 12:08, nick <nick.za...@gmail.com> wrote:
> The point is: every time i try to execute a query that deal with
> geometric function for example:
> ST_Distance() i receive a 500 error.
>
> Looking at the catalina.out I can see that:
> mondrian.olap.MondrianException: Mondrian Error:No function matches
> signature 'ST_GeomFromText(<String>)'

can you send us the xml cube descriptor, please?
Maybe you must define the spatial function like this:

<UserDefinedFunction name="ST_Distance"
className="mondrian.udf.geo.STDistanceUdf" />

Thank you

Fabio D'Ovidio

[Nicola Zandonà]

Thanks Fabio, your reply gives me some light!!

That was the problem:

<UserDefinedFunction name="ST_Distance"
className="mondrian.udf.geo.STDistanceUdf" />

I added the ST_Distance as a user defined function at the end of my schema definition 

(the GeoFoodMart provided with Spatialytics) and now i can use it.

I found other ST_ functions in the same className.

How about using ST_GeomFromText?

Do i need to implement it as a user defined function if i want to use it?

Thank you

Nicola