Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Snow flake Schema failed with OUTER JOIN in Meta Data Editor

  1. #1

    Default Snow flake Schema failed with OUTER JOIN in Meta Data Editor


    Is there any way to represent snowflake schema with metadata editor and get correct SQL outer join query results.
    I have a geographic dimension which can be divided to the following structure :
    Geographic_area/country/implantation/field ==>This is corresponds to the goegraphic dimension.

    So for each term has a table in the database.==>4 tables.
    Also, i have a simple standard Employe dimension and a fact table which contain as measure the wage of employes.

    The aggregation is sum on the wage.

    The problem is that when i link this table with outer join(Left or right it doesn't matter) and after that i make a query on the fact table such as :
    The total wage grouped by country (e.i:The total wage corresponding the country France, USA...) i get errors or wrong results.

    So my quesion is : Is it possible to modelise a snow Flake schema as business View with Meta Data Editor and query it.


  2. #2
    wgorman Guest



    Many people model their snowflake schemas in Metadata, you could also look into modeling it using Mondrian. Traditionally Snowflakes don't need outer joins, all the ids in the fact table map to a row in the dimension table. If you post more details, for instance the SQL generated that is causing the problem, that might help debug your problem. You can launch the MQL editor from within pentaho metadata editor by clicking on the query icon in the toolbar.


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.