Folder Joins – Screen

Overview – Folder Joins

Folder Joins Screen

This screen is used to create the joins between folders (tables/views) that will return the desired data to chart in BI Dashboard Builder. Also, in BI Dashboard Builder, filters and sorts for the returned data can be specified.

NOTE: To modify folder joins, the user must have the following system privilege: ‘BIMODJOINS - Allows the user to modify Folder Joins in BI Catalog Builder’.

View Joins

As shown in the previous screenshot, when a folder is selected in the left pane, if joins exist between it and any other folders, the titles of the folders with joined fields are highlighted with red text in the right pane, along with the titles of business areas that also contain joined folders.

If a required, logical join does not exist, users can create it, as per the Create Joins article.

To view the joined fields between the folder on the left and the folder on the right, click the folder on the right, and the joined field(s) will be listed in the Joined Fields section of the property pane (right-most pane).

Navigation Panel (Folder Joins)

A Navigation panel allows users to navigate the data source tree and selected tree nodes using drop-down lists. Each drop-down list has search functionality. Users can quickly navigate to the top levels of selected nodes by using the Arrow icons () next to the required level.

Sort Panel (Folder Joins)

The Sort panel allows users to sort business areas, folders and fields by:

• Default (using property position)

• Name Ascending

• Name Descending