Define Data Fragmentation for a Logical Table Source

A fragmented table contains a portion of the data at a specific aggregation level. When you use fragmented tables, you must write an expressions for each table source to indicate its range of values.

See About Data Fragmentation.

1. On your home page, click Navigator and then click Semantic Models.
2. In the Semantic Models page, click a semantic model to open it.
3. Click Logical Layer .
4. In the Logical Layer pane, browse for and double-click the table with the table source you want to define data fragmentation for.
5. In the table's tabs, click Sources.
6. In the logical table sources list table, click the logical table source that you want to define data fragmentation for and then click Detail view to open the properties pane.
7. Go to the pane's Data Fragmentation section and click Data is fragmented.
8. Click Open Expression Editor and create and validate the fragment expression. In the Expression Editor click Save.
9. Optional: If the data needed for a query is located in more than one fragmented table, then click Combine with other fragmented sources to sum the data.
10. Optional: Click Enable Data Driven Fragment Selection to improve the performance of the logical table source.
11. Click Save.