You can have Essbase Studio inspect your database and return a list of possible join pairs.
To add joins by inspection:
If not already opened, open the minischema (see Opening a Minischema).
Right-click in the background of the minischema, and select Add Joins By Inspection.
The Create Joins by Inspection dialog box is displayed, listing the possible join pairs that were detected by Essbase Studio.
Optional: To filter the results by table or by column, perform a task:
Type the name of a table to filter on in Table name filter.
Table names are case-sensitive.
If the table name you entered is contained in either the Join Source or Join Target side of the join pair, those pairs are displayed.
Type the name of a column to filter on in Column name filter.
Column names are case-sensitive.
If the column name you entered is contained in either the Join Source or Join Target side of the join pair, those pairs are displayed.
Perform a task to choose the join pairs you want to add to the minischema:
To choose all the join pair results, select the Select all items check box.
To choose selected join pair results, select the check box next to the join pair in the results grid.
Verify that the selected join pairs were added in your minischema diagram.
To save changes, right-click in the minischema work area and select Save Minischema.