Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Could Mondrian work with galaxy schema?

  1. #1
    Join Date
    Oct 2014
    Posts
    9

    Question Could Mondrian work with galaxy schema?

    Hi All,

    Could you please tell, could Pentaho Schema Workbench or Mondrian work with galaxy schema?

    I mean, if there are several Fact tables connected with each other and I want to build measures from each Fact table without creating any Views.
    Don't want to use any Views since it seems like a workaround rather than a right solution.
    Also Pentaho Aggregation Designer cannot work with Views.

    With best regards,
    Bagdat

  2. #2
    Join Date
    Oct 2014
    Posts
    9

    Default

    I found out 2 things:
    1. In Galaxy schema, fact tables are not connected directly. They just have common dimension tables.
    2. It is not correct to build Data warehouse schema with directly linked Fact tables.

    After above findings, I understand that Pentaho Schema Workbench could not build Cube based on a such schema.
    But, for a correct galaxy schema could be used Virtual Cubes.

    Thanks.

Tags for this Thread

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 - 2017 Pentaho Corporation. All Rights Reserved.