After not working with Mondrian for a few months I had to design a schema for Mondrian again. As usual I first used the Schema Workbench. U can do everything with it but the user interface is a pain I think, especially if you are used to the other Open Source BI tools that are around for other tasks.
I remembered that at least version 2 of the Pentaho Metadata Editor has a hidden Schema Editor, you have to press CTRL-ALT-O to activate it. If you check out the newest version (Version 3 RC1) you will be surprised how much you can do with it already! After building your relational model in the Metadata editor you can quickly design your cube and reuse your relational model which can save you a lot of time. But remember, it's not supported by Pentaho yet and you have to copy and paste your schema to test it. I'm sure in the near future Pentaho will have a solution for it.
Another open source tool I found (I started working for the company recently) is Power*Architect from SQLPower. Power*Architect is mainly a data modelling and profiling tool but it also comes with a small schema designer, as you can see in the screenshot.
So far Power*Architect doesn't come with Mondrian included so you'll have to copy your schema to another tool first if you want to test and upload it.
If you know any other tools and ways to create to easily create a schema feel free to comment.
I remembered that at least version 2 of the Pentaho Metadata Editor has a hidden Schema Editor, you have to press CTRL-ALT-O to activate it. If you check out the newest version (Version 3 RC1) you will be surprised how much you can do with it already! After building your relational model in the Metadata editor you can quickly design your cube and reuse your relational model which can save you a lot of time. But remember, it's not supported by Pentaho yet and you have to copy and paste your schema to test it. I'm sure in the near future Pentaho will have a solution for it.
Another open source tool I found (I started working for the company recently) is Power*Architect from SQLPower. Power*Architect is mainly a data modelling and profiling tool but it also comes with a small schema designer, as you can see in the screenshot.
So far Power*Architect doesn't come with Mondrian included so you'll have to copy your schema to another tool first if you want to test and upload it.
If you know any other tools and ways to create to easily create a schema feel free to comment.
Comments