Skip to main content

Mondrian Schema design with Metadata Editor and Power*Architect

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.


Popular posts from this blog

Pentaho Data Integration - Multi-part Form submission with file upload using the User Defined Java Class Step

I recently needed to use Pentaho Data Integration (PDI) to send a file to a server for processing using HTTP Post. I spent several hours trying to use the existing steps HTTP Post, HTTP Client & Rest Client but I couldn't get it to work. After some more research I came across the issue PDI-10120 - Support for Multi-part Form Submittal In Web Service Steps  and I thought I was out of luck. I previously wrote a small Java client for a similar use case and remembered the PDI has a step called User Defined Java Class  (UDJC). After reading this great tutorial I created the following basic transaction. I have a dataset with the URL and the full file path and use the UDJC to make the HTTP call. HTTP Post using User Defined Java Class The Java class handles the actual HTTP Post. It uses 2 input variables, the URL (url) which is used for the call and the file name (longFileName). The HTTP call then contains the file (line 30) and the file name (line 31). I included some basi

Products you don't expect to be 'Made in China' - Del Monte fruit cups

Since I moved to Canada back in March I have started to realize how many products are actually made in China. Back in Germany you could also buy lots of stuff from China but you mostly had the choice between German or Europe products and Chinese products. When I went to Food Basics in Oakville a couple weeks ago to get some apples I stood in front of a huge tray of Chinese apples! Aren't there enough apples in Ontario, Canada or the US? Even Mexico would probably be closer than China. Another day my wife bought Del Monte fruit cups in the grocery store. I checked the label when I was going to eat it and i decided to leave it in the fridge. First of all it is 'Made in China' (again I guess no other country in this world has fruit) and second it contains artificial flavor. How bad must the fruit inside be that you need artificial flavor (and does anybody in China controls how it is made)? For my part I'll check the labels more closely whenever I buy any kind of product

Connect Facebook & (almost) everything from Google

Yesterday I tried to figure out how to post my blog posts on my Facebook profile. First I tried different application but all they could do was adding a box on your profile. After searching for on google for a couple minutes I found one video on youtube that lead me the way: Import Blog/RSS in Facebook profile . You can do it even easier as in the video. When you are on your profile in Facebook, you just have to click on Import (as shown in the picture) and you can import not only a RSS feed from your blog, but also integrate lots of different websites like Youtube, Google Reader and most important for me: Picasa. Finally you can use all the different great tools from Google and integrate them all into one Profile. UPDATE: Finally there is also a blog post in the offical blog from blogger about the topic: Blogger Buzz: Facebook Your Blog