Set the Logical Table Sources Priority Order
Sometimes a logical table contains more than one table source that can be used in a query. In such cases, you can set priority numbers to determine which logical table source is used in a query.
You can assign the same priority number to more than one source table to create a priority group.
- On your home page, click Navigator
and then click Semantic
Models. - In the Semantic Models page, click a semantic model to open it.
- Click Logical Layer
. - In the Logical Layer pane, browse for and double-click the table with the sources that you want to assign priority groups to.
- In the logical table, click the Sources tab.
- In the sources list table, click the source table that you want to assign query groups to and then click Detail view to open the properties pane.
- Scroll to General and click the Priority field and enter a priority group number.
- In the sources list table, click another source table that you want to assign query groups to and then click Detail view to open the properties pane.
- Scroll to General and then click the Priority field and enter a priority group number.
- Click Save.