mondrian and firebird

[persapiens]

Hi,
First of all, congratulations for mondrian! It is excellent! I'm using it into production with oracle.
Does mondrian work on firebird database?
I tried, but I got the following error:
java.lang.RuntimeException: Internal error: while counting members of level '[Tempo].[Ano]'; sql=[select count(*) as "c0" from (select distinct "T_TEMPO"."ANO" as "c0" from "T_TEMPO" as "T_TEMPO") as "init"]
at mondrian.olap.MondrianResource.newInternal(MondrianResource.java:45)
at mondrian.rolap.SqlMemberSource.getMemberCount(SqlMemberSource.java:122)
at mondrian.rolap.SqlMemberSource.getLevelMemberCount(SqlMemberSource.java:103)
at mondrian.rolap.SqlMemberSource.getMemberCount(SqlMemberSource.java:81)
at mondrian.rolap.RolapSchema.createMemberReader(RolapSchema.java:399)
at mondrian.rolap.RolapSchema.createMemberReader(RolapSchema.java:353)
at mondrian.rolap.RolapHierarchy.init(RolapHierarchy.java:131)
at mondrian.rolap.RolapDimension.init(RolapDimension.java:119)
at mondrian.rolap.RolapCube.init(RolapCube.java:174)
at mondrian.rolap.RolapCube.<init>(RolapCube.java:76)
at mondrian.rolap.RolapSchema.load(RolapSchema.java:115)
at mondrian.rolap.RolapSchema.<init>(RolapSchema.java:93)
at mondrian.rolap.RolapSchema.<init>(RolapSchema.java:34)
at mondrian.rolap.RolapSchema$Pool.get(RolapSchema.java:249)
at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:89)
at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:60)
at mondrian.olap.DriverManager.getConnection(DriverManager.java:133)
at mondrian.olap.DriverManager.getConnection(DriverManager.java:49)
I tried to execute the query in firebird database and i got the message:
"Unable to executa query, GDS Exception. Dynamic SQL Error
SQL error code = -104
Token unkown - line 1, char 31
select"
Thanks in advance

[juanjoem]

Hello
I am trying to use Firebird and I am getting the same error. Firebird does nor support selects in the from clause :o\
I think that I need to modify the way Mondrian builds the queries, but I do not know where to start (I am really new to Mondrian).
Any ideas? Any help will be very appreciated! :o)
Regards,
J

[jhyde]

There was a discussion about Mondrian and Firebird a few days ago. Since Firebird supports neither compound count distinct (e.g. "select count(distinct x,y) from t") or select-in-from (e.g. "select count(*) from (select distinct x,y from t))") I'm afraid Mondrian can't run on it.

[juanjoem]

I am very interested on getting it to work. Where can I get more detailed information on Mondrian so I can understand the internals? UML doc would be perfect (apart from reverse-engineering for class diagrams).