In SSAS can you create a cube partition, set the slicing property and then do incremental updates to populate the partition?

Question

I'm getting the below error when I attempt an Incremental load to a partition that has the partition slicing property set.

Errors in the OLAP storage engine: The slice specified for the Year attribute is incorrect.

To recreate the problem:

1. Create a new partition while setting the Partition Slice property.
2. Perform a Process Full with limited data.
3. Perform a Process Add incremental load with more data that includes values outside of the original set but still conforms to the slice definition.

Answer 1

The slice specified for the Year attribute is incorrect indicates a misalignment between the slicing definition for the partition and the actual data. When setting up a partition with the slicing property, you're essentially telling SSAS to expect data within a specific range or category. If the actual data processed falls outside this range, or if the slicing definition is incorrect, you will receive this error. It requires ensuring that the slicing property for the Year attribute is correctly defined and aligns perfectly with the data you're processing in that partition. If the problem persists, a full reprocess of the partition might be necessary after carefully revising the slice definition.