PDA

View Full Version : Cube Output step question?



tardifma
01-10-2006, 01:12 PM
Attachment: Schema.png (http://forums.pentaho.org/archived_att/kettle/Schema.png) Hi.
I was wondering if anybody knows what is the Cube Output for?


My understanding from the documentation is that it is only a structured file on the disk drive... Am I right?



Does it have anything to do with a real multidimentional Cube structure? and if so, is there any software already developped to browse that cube?



I am currently looking for an Open Source BI tool (Cube or Reporting tool that allows Drill down, Drill up, Drill accross...)



Any idea.
Thanks
Mathieu

MattCasters
01-10-2006, 11:51 PM
> Hi. I was wondering if anybody knows what is the Cube Output for?

Hi Mathieux,

Cube output just dumps the rows to a binary file.
CubeInput reads from this file.

At one time, a few years ago I hade the idea to create a "Business Objects" clone.
The first tool created then was Menu, the Designer part of BO if you like: it adds a meta-data layer between the data warehouse and the user.
This program exists and is called PMenu under package be.ibridge.kettle.menu.
In fact, yesterday I commited a couple of patches to get this running again. (didn't work on it for years)
At the moment it allows you to generate SQL based on the fields selected and the data model you specified.
It has a couple of bugs in it, but the basics work.
Perhaps someone else likes to pick this one up? (it's pure fun, really!)

Anyway, to make this long story short, the output from the generated transformation is a CubeOutput step. The idea is then later to create a reporting tool that picks up the data in the Cube (BO style MicroCube ;-)) and allows to user to format the data.
This reporting tool called Plate, never got started, sorry ;-)

Hope this explains a few things,

Take care,

Matt

tardifma
01-11-2006, 06:33 AM
Thanks... too bad... It woulded be a wonderful tool.

Thanks for your help and continue your good job !

MattCasters
01-11-2006, 12:56 PM
Attachment: Schema table properties.PNG (http://forums.pentaho.org/archived_att/kettle/Schema table properties.PNG) Table properties dialog

MattCasters
01-11-2006, 12:57 PM
Attachment: Schema.png (http://forums.pentaho.org/archived_att/kettle/Schema.png) Images of Menu it action in attachement