Hitachi Vantara Pentaho Community Forums
Results 1 to 5 of 5

Thread: Cube Output step question?

  1. #1
    Join Date
    Jan 2006
    Posts
    3

    Default Cube Output step question?

    Attachment: 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

  2. #2
    Join Date
    Nov 1999
    Posts
    9,729

    Default RE: Cube Output step question?

    > 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

  3. #3
    Join Date
    Jan 2006
    Posts
    3

    Default RE: Cube Output step question?

    Thanks... too bad... It woulded be a wonderful tool.

    Thanks for your help and continue your good job !

  4. #4
    Join Date
    Nov 1999
    Posts
    9,729

    Default RE: Cube Output step question?

    Attachment: Schema table properties.PNG Table properties dialog

  5. #5
    Join Date
    Nov 1999
    Posts
    9,729

    Default RE: Cube Output step question?

    Attachment: Schema.png Images of Menu it action in attachement

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.