Editing Source Relations

Perform this procedure to modify the relations in the basic composer.

Edit source relations

  1. Click the Designers tab.
  2. Right-click a basic composer, and click Detailed Properties > Source Relations.
  3. Join the two tables using the primary keys.

    A left outer join is created.

    Click OK.

  4. Compile the composer.
    1. Right-click the composer, then click Compile.
    2. Click the Start button.
  5. Edit relations in the fact composer.

    On the DWD Designer main menu, click Design > Relations Manager.

    The star schema is now being built.

  6. Create inner joins between the dimension composers and the fact table composers.
  7. Click OK.