Tuesday, 2 January 2007

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.

No comments: