Search code examples
ssasbids

SSAS - setting a slice

I've partitioned my cube to improve processing time. But I doubt it improved my query times. I read that I have to set the slice property. So my partition query cuts it by 

year 2012 and older (ie < year 2013)
the year 2013
and year 2014 and onwards

I'm wondering how i set my slice? this don't seem to work and I get an error.

[dim_report_year] < 2013
[dim_report_year] = 2013
[dim_report_year] > 2013

the restrictions imposed on partition slice where violated

Thanks.

Solution

  • In the slice definition you can use tuples only. You cannot use sets or conditions. Therefore you can create a new attribute with 3 values(x<2013, x=2013, x>2013) in time dimension, then you can use this new attribute in the slice definition.