Disable Auto Joins Creation in the Physical Layer

Disable the Automatically create joins if tables added to the physical layer have foreign keys user preference to prevent Oracle Analytics from automatically creating physical joins.

Note:

Deselecting Automatically create joins if tables added to the physical layer have foreign keys disables the option for all semantic models that you work with, not just the semantic model that was open when you set this user preference.

By default the Automatically create joins if tables added to the physical layer have foreign keys user preference is set to on. When you add data source tables to the physical layer, any foreign keys defined in the data source automatically create joins between the corresponding tables in the physical layer.

In some cases you might want to manually build the physical layer's joins. For example, if adding data source tables creates unneeded or incorrect joins in the physical layer and it's time consuming for you to delete these joins. In such cases you deselect the Automatically create joins if tables added to the physical layer have foreign keys checkbox to turn off automatic joins.

Deselecting Automatically create joins if tables added to the physical layer have foreign keys doesn't remove the physical layer's existing joins, so you must remove those joins manually.

1. On the Home page, click Navigator and then click Semantic Models.
2. In the Semantic Models page, click a semantic model to open it.
3. Click Page Menu and then click Preferences.
4. In the Users Preferences dialog box, scroll to Physical Layer and then click Automatically create joins if tables added to the physical layer have foreign keys to deselect it.
5. Click Apply.