Multi-parent synonyms are now supported as the source for a join to a single segment in a target synonym.

A join from a multi-parent synonym is subject to the following conditions:

• Conditional joins are not supported (JOIN WHERE).
• The join must be unique. That is, the TO ALL phrase is not supported.
• The target of the join cannot be a multi-parent synonym.
• The target of the JOIN must be a single segment, either in a single segment synonym or one segment in a single parent, multi-segment synonym.
• All fields in the JOIN must be FROM/TO a single segment. Any single segment in the source synonym can be used in the join.

The following Master File describes a multi-parent structure . The two fact tables sales and shipments are parents of the dimension table product.

FILENAME=WFMULTI, $
  SEGMENT=WF_RETAIL_SHIPMENTS, CRFILE=SHIPMENT, CRINCLUDE=ALL,
    DESCRIPTION='Shipments Fact', $
  SEGMENT=WF_RETAIL_SALES, PARENT=., CRFILE=SALES, CRINCLUDE=ALL,
    DESCRIPTION='Sales Fact', $
  SEGMENT=WF_RETAIL_PRODUCT, CRFILE=PRODUCT, CRINCLUDE=ALL,
    DESCRIPTION='Product Dimension', $
   PARENT=WF_RETAIL_SHIPMENTS, SEGTYPE=KU,
    JOIN_WHERE=WF_RETAIL_SHIPMENTS.ID_PRODUCT EQ WF_RETAIL_PRODUCT.ID_PRODUCT;, $
   PARENT=WF_RETAIL_SALES, SEGTYPE=KU,
    JOIN_WHERE=WF_RETAIL_SALES.ID_PRODUCT EQ WF_RETAIL_PRODUCT.ID_PRODUCT;, $

The following request joins the product segment to the dimension table vendor based on the vendor ID and issues a request against the joined structure:

JOIN ID_VENDOR IN WFMULTI TO ID_VENDOR IN VENDOR AS J1
TABLE FILE WFMULTISUM COGS_US DAYSDELAYED
BY PRODUCT_CATEGORY
BY VENDOR_NAME
WHERE PRODUCT_CATEGORY LT 'S'
ON TABLE SET PAGE NOPAGE
END

The output is:

 Product                                                      Days   
 Category           Vendor Name            Cost of Goods      Delayed
 --------           -----------            -------------      -------
 Accessories        Audio Tech                $38,000.00           28
                    Denon                     $25,970.00           17
                    Grado                     $21,930.00           15
                    Logitech                  $61,432.00          114
                    Niles Audi                $73,547.00          150
                    Pioneer                   $16,720.00           71
                    Samsung                    $5,405.00           83
                    Sennheiser                $78,113.00          128
                    Sony                      $21,760.00          157
 Camcorder          Canon                    $110,219.00           97
                    JVC                       $72,292.00           75
                    Panasonic                 $22,356.00           91
                    Sanyo                     $31,590.00          179
                    Sony                     $216,748.00          333
 Computers          Samsung                   $33,129.00          156
                    Sony                      $76,152.00          186
 Media Player       JVC                       $87,057.00          267
                    LG                         $3,830.00           13
                    Panasonic                $143,600.00          171
                    Pioneer                  $169,810.00          206
                    Roku                      $10,248.00           85
                    Samsung                  $151,620.00          191
                    Sharp                     $66,024.00          157
                    Sony                     $142,190.00          121
                    Toshiba                    $5,214.00            7