Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Join

  1. #1

    Default Join

    Please I want to do 2join in the same dimension
    to view data from 3 table
    i didn't find any solution

  2. #2

    Default more information about my problem

    this is a portion from the xml-schema
    <Dimension name="product">
    <Hierarchy hasAll="true" primaryKey="id_product" primaryKeyTable="product">
    <Join leftKey="id_categorie" rightKey="id_categorie">
    <Table name="categorie"/>
    <Table name="product"/>
    <Join leftKey="id_source" rightKey="id_source">
    <Table name="product"/>
    <Table name="source_product"/>
    <Level name="country of product" table="source_product" column="source" uniqueMembers="false"/>
    <Level name="categorie of product" table="categorie" column="categorie" uniqueMembers="false"/>
    <Level name="produt name" table="product" column="name_product" uniqueMembers="false"/>

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.