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.
  1. On your home page, click Navigator Navigator icon and then click Semantic Models.
  2. In the Semantic Models page, click a semantic model to open it.
  3. Click Logical Layer Logical layer icon.
  4. In the Logical Layer pane, browse for and double-click the table with the sources that you want to assign priority groups to.
  5. In the logical table, click the Sources tab.
  6. 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.
  7. Scroll to General and click the Priority field and enter a priority group number.
  8. 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.
  9. Scroll to General and then click the Priority field and enter a priority group number.
  10. Click Save.