Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Mondrian, third normal form

  1. #1
    Join Date
    Oct 2007
    Posts
    2

    Default Mondrian, third normal form

    Are there any possibilities to build a cube with data from a database, which is truly normalized. I don't want to use a view in the database and I don't think, that the use of a virtual cube is ideal.

  2. #2

    Unhappy Mondrian on production database

    Hello,

    Unfortunatly, Mondrian join strategy is limited to 1 column by table when building a 2 tabes joins. This is a strong limitation when trying to connect against a production database, as Mondrian target DWH when tables can have surrogate keys for better join strategy performance.

    Virtual cubes is not a solution, as main objective for using virtual cubes (from my position) is to have a cube with measures coming from differents facts tables.

    Views is unfortunatly the only solution ... but in real life, this is not applicable

    Regards,
    Patrick
    Patrick Beaucamp
    BPM-CONSEIL
    www.bpm-conseil.com

  3. #3
    Join Date
    Oct 2007
    Posts
    2

    Default

    Thanks for your quick anwser.

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.