Version 2021

Report Data Options dialog box: Attribute Join Type

The Attribute Join Type subcategory allows you to create an outer join from lookup tables for a select number of attributes.

Choose from the following options:

  • Default: Select to keep the corresponding report-level settings.

  • Preserve common elements of lookup and final pass result table: Select to keep only the elements that exist in both the lookup and fact tables.

  • Preserve lookup table elements joined to final pass result table based on fact table keys: Select to keep only the elements that are joined to the fact table based on fact table keys.

  • Preserve lookup table elements joined to final pass result table based on template attributes without filter: Select to keep all attribute elements and ignore all related filtering conditions.

  • Preserve lookup table elements joined to final pass result table based on template attributes with filter: Select to keep all attribute elements and apply all related filtering conditions.

  • Restore Attribute Defaults: Click to restore the join type to the default attribute-level setting.

Join Type settings

If you select any of the Preserve lookup table elements options, you can change the join type of each attribute on the report. In the Join Type settings table, click the Join Type for the attribute and select Default, Inner, or Outer from the pull-down list.

You can set the attribute join type for attributes that will appear in the destination reports when you drill on this report. For more information, see the Drilling subcategory.

Join Type settings for an object prompt

If the report contains an object prompt on the report grid, the report's attributes are not yet defined and therefore cannot be displayed in the Join Type settings table. To assign join properties to the attributes included in the object prompt, follow the steps below:

  1. Click OK to return to the report.

  2. View the SQL of the report, by selecting SQL View from the View menu. The prompt is displayed, without executing the report.

  3. Choose all of the attributes that are available in the prompt.

  4. Click Finish.

  5. From the View menu, select Design View. Notice that all the attributes are included in the report.

  6. You can use the Report Data Options dialog box to assign join types for every attribute, as described above.

  7. Save the report as prompted, rather than static.

When the report is re-executed, the prompt is displayed so that the user can select his own prompt answers. Each attribute that is selected uses the specified join setting.

Related Topics