Add Relational Data to a Report

Select the data items to appear in the report.

If you frequently use items from different query subjects or dimensions in the same reports, ask your modeler to organize these items into a folder or model query subject and then to republish the relevant package. For example, if you use the product code item in sales reports, the modeler can create a folder that contains the product code item and the sales items you need.

Procedure

  1. From the Source tabsource tab, drag each query item to the report.
    Note: A flashing black bar indicates where you can drop an item. Items inserted in the report appear on the Data Items tab data items tab.

    Other ways to select data items are to double-click each item or to right-click each item and click Insert.

  2. If you want to remove a data item from the report, select it, and in the report object toolbar, click the More icon Report object toolbar More icon and then click the Delete option delete icon. To remove the data item from the report but keep it on the Data Items tab data items tab, click Cut instead.
  3. For more information about a query item, right-click the item in the Source tab and click Properties. You can also obtain more information by clicking Lineage.