Hitachi Vantara Pentaho Community Forums
Results 1 to 7 of 7

Thread: compound primary or foreign keys

  1. #1
    Join Date
    Feb 2008
    Posts
    4

    Default compound primary or foreign keys

    Hi,
    i am new to mondrian and want to integrate mondrian with our ERP software. Our DB tables contain compound primary keys and we have no way of changing this. Does mondrian support multiple keys for joining dimenson and fact tables, dimension to dimension tables (snowflake dimension).

    thanks

  2. #2

    Default

    Hello, i have the same problem. We use compound keys and there is no way to change our database structure , unfortunately. i need the solution as soon as possible.
    Thanks.

  3. #3
    Join Date
    Nov 1999
    Posts
    1,618

    Default

    People have asked for this, but at present, mondrian does not support compound foreign keys.

  4. #4
    Join Date
    Feb 2008
    Posts
    4

    Default

    Hi Julian,thank you for reply. Do you have any plan to implement this feature.
    forgive me if i am thinking too simply. if i use foreign and primary key property fields as primarykey = "pk1,pk2" and foreignkey = "fk1,fk2"
    and change the code for SQL joins (whatever it is) to parse and use compound keys in join, what is wrong here.
    thank you.

  5. #5
    Join Date
    Feb 2008
    Posts
    4

    Default

    hi friends,

    can anybody help about this problem? in order to complete project i need this feature.

    thank you for your interest.

  6. #6
    Join Date
    Feb 2008
    Posts
    4

    Default

    does Mondrian have any plan to support compound primary keys.
    or what can we do to solve this problem without chaging DB structure.

  7. #7
    Join Date
    Oct 2007
    Posts
    255

    Default asdf

    Have you guys thought about creating a data warehouse? Use kettle to move everything into new tables, generate a new primary key, a unique one for each compound key combination, and use the DW database?

    The very idea of a data warehouse is to shift the burden of serving up data for reporting away from your business server database(s) to the data warehouse database(s).

    Not only do you alleviate future problems with the data warehouse killing performance on the business server, it solves the problem you're running into.

    -Brian

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.