[geomondrian-users] Evaluating geomondrian

[Nicola Z. <nic...@gm...>]

Hi everybody!
I have installed geomondrian (following http://mondrian.pentaho.org/documentation/developers_guide.php 
  this guide) and spatialytics and now i'm trying to run some query on  
the spatialytics test page.
I can execute the default query :

SELECT
{[Measures].[Unit Sales]} ON COLUMNS,
{[Store].[Store Country].members} ON ROWS
FROM [Sales]
WHERE [Time].[1997]

And i can drill down and roll up over the map.

The problem come when i try to use one of the ST_ function for example:

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

This one gives me a 500 error, and if i look at catalina.out I see:

Caused by: mondrian.olap.MondrianException: Mondrian Error:No function  
matches signature 'ST_GeomFromText(<String>)'

Am i missing something??

Any hint will be greatly appreciated!

Tnx for reading!