A complete Kettle + Mondrian feed back

Hi all,

After more than 4 months spent on Kettle and Mondrian, I wrote a review on the french developper network.
This review is written in french and you can find it here : http://www.developpez.net/forums/showthread.php?t=253349

Please, feel free to answer and share your personnal feed back.

Interesting tip for Mondrian with XML/A

Hi all,

A few days ago, I discovered an interesting tip when using Mondrian with XML/A.
For the moment, I ignore if this issue is documented (and if it is a real issue ...).

Let me explain : when using Mondrian + XML/A on a schema containing dimensions with "name" properties in hierarchy, the schema validation crashes, so the query execution.

Example of faulty code, in XML/A mode :







Now, the working code. Note : replace Hierarchy name with Hierarchy caption ...





Just keep in mind I'm using Mondrian in XML/A mode on a Sun Sparc server with Solaris 8 and SunONE as application server (Oracle 8i as database).

A cool feature of Mondrian Schema

Hi all,

Today I tried to write SQL embedded in a Mondrian schema. This feature is really handy when it comes to design very small dimensions on the fly, without creating any object in the DB.
Use it for small dimensions, with few distinct values.

Here is the XML code I used today :

Then you can access your dimension with simple MDX statements :

[FAMILLE DE SERVICE].[Tous Services],

[FAMILLE DE SERVICE].[Tous Services].[Bar],

[FAMILLE DE SERVICE].[Tous Services].[Buanderie] ...

Very nice.