Documentation
Documentation

Adding business objects and queries as available sources in Report Writer

Training course

🚧

Warning

Adding too many queries, business objects, and/or shortcuts to the $/Common/Query Sources folder will significantly decrease Report Writer's performance. Do not add more than 200 items to this folder.

The $/Common/Query Sources folder contains the data sources available to choose from when creating a report in Report Writer.

Viewing the $/Common/Query Sources folder

To add data sources, such as user–defined sources, business objects, or queries, to Report Writer, do the following:

  1. Go to RiSE > Document system.

  2. Navigate to $/Common/Query Sources.

    Navigating to the $/Common/Query Sources folder

  1. Do one of the following:

    1. Select the folder in which you want the source to appear, or if you want the source to appear in the top Common section, remain in the $/Common/Query Sources folder.
    2. Create a new folder (New > Folder). Make sure Allow only the following types of objects in this folder (select all that apply) is selected. Hold down Ctrl
      (Command for Mac), then choose the following:
      • Business Object
      • Design Business Definition
      • Folder
      • Query
      • Shortcut

  2. Click New, then select one of the following:

    • To add an existing query, business object, or user-defined source, select Shortcut.

      Selecting a Shortcut to add an existing query, business object, or use-defined source

      1. In the Document Name field, enter a name for the source. This name will appear in the query definition.

        Entering a name for a source

  3. In the Related document field, Select the source.

    📘

    Note

    Business objects are found in the $/Common/Business Objects folder.

    1. Click OK, then click Save.

    • To add a new query, select Query.

      Adding a new query

📘

Note

When using an IQA as the report's data source, it is suggested to use the Top/Bottom report filter (Report Options > Filters > Top/Bottom) instead of enabling Limit the report to the top/bottom values. Using the Top/Bottom report filter will ensure no data is missing in the report.

Once your data sources are created, they are added to a Report Writer report when you drag and drop a data source from the Fields panel to a cell in the report.