...
Use a Time dimension in the semantic model to set up the sliding window. Note that larger numbers of partitions can affect performance.
When you update or replace data in a semantic model partition, you must specify the full range of data for that partition. For example, if a semantic model partition contains a day’s worth of data, then you must specify the time range as a day.
Using a sliding window, you can define the range for which you want to keep the data and delete the older data. For example, with a partition, you can keep one year's worth of data, while using a sliding window, you can maintain it for five years.
If you choose to keep data for the latest five years in the semantic model, data (and corresponding metadata) that is out of the sliding window range will be deleted. For example, if new data comes in with an incremental buildprocess. The semantic model job Summary shows the information of deleted data.
Only the valid members, according to sliding window duration, will be visible for all metadata queries across all viewer interfaces, i.e., MDX, SQL, Kyvos visualization, and third-party tools. There will be no impact on the row-level/column-level security filters.
You can update the range of an existing sliding window without needing to reprocess the semantic model. After you update the range of a sliding window, when you incrementally add data, the system will automatically drop old data.
You can use sub-partitions to fine-tune the data updated in your sliding window.
...