PDA

View Full Version : Join



njah_houssem
02-28-2007, 10:03 AM
Please I want to do 2join in the same dimension
to view data from 3 table
i didn't find any solution
thanks

njah_houssem
02-28-2007, 10:23 AM
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>
<Join leftKey="id_source" rightKey="id_source">
<Table name="product"/>
<Table name="source_product"/>
</Join>
<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"/>
</Hierarchy>
</Dimension>