Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Agile BI Model

  1. #1
    Join Date
    Oct 2006
    Posts
    16

    Question Agile BI Model

    Just started working with the Agile BI plugin for spoon.

    When creating a model, it appears to only let me choose a single table.
    My question is: How do I create a model in Agile BI that has a single fact table with multiple Dimension tables joined to it based on keys?

    I presume I am doing something incorrectly, but the documentation I have found is not clear about how to do this.

    Thanks,

    Doug

  2. #2
    Join Date
    May 2011
    Posts
    3

    Default

    Currently it works off of a single table. When you go the the model tab in agile, it will automatically create measures and dimensions from the single table model and persist it as a .xmi file (not psw .xml).
    I believe that Pentaho is working towards making this the method of creating a mondrian schema and supplanting PSW but as of now, that is not the case. So it works similar to the way an excel pivot table works by assuming that any numeric attribute in your single table is a measure and any text fields are (degenerate) dimensions. There is some documentation in the wiki/forums. If I come across it again, I'll send it along.

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.