Improve the Performance of Fragmented Logical Table Sources

You can use data driven fragment selection to improve the performance of fragmented logical table sources.

Data driven fragment selection is disabled by default.

  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 fragmented source that you want to improve performance for.
  5. In the table's tabs, click Sources.
  6. In the table sources list, click the logical table source that you want to improve performance for then click Detail view to open the properties pane.
  7. Scroll to Data Granularity and click Data is fragmented to display the expression that you created.
  8. Click Enable Data Driven Fragment Selection.
  9. Click Save.