In Metadata Editor I have to join two tables with a join which concern 3 fields.
I must check the complex join checkbox and write the join.
I would like to know which names of table I have to use ? I saw in the wiki of pentaho that :What are really the physical name ? names like they are in my database ? Names like they are in Metadata (ID which start with "PT_") ? Names like they are in the business model (ID which start with "BT_") ? Names like they are in business view (ID which start with "BT_") ?Also note, the complex join expression provided must utilize the names of the physical tables and physical columns, not business tables and business column names.
I think I tried all these names but neither of them works...
I have some errors like
If you can help me, and tell me how we can create a complex join, I will be very recognizing...Field Name PT_DOSSIER_RMI.BC_DOSSIER_RMI_CODE_DEP not found in Business Model. Business Category PT_DOSSIER_RMI not found.
Thanks a lot.