I found this snippet of code from a post ways back.

This code sets up the data slice for a partition. The first line is
obviously needed, however are lines 2-7 needed as well? What do they gain?



1
dsoPartitionNew.Dimensions("Time").CustomPropertie s("DimensionSlice").Value
= "1998.Q4.12"
2 dsoPartitionNew.Dimensions("Time").Levels("Year"). MemberKeyColumn =
"""time_by_day"".""the_year"""
3 dsoPartitionNew.Dimensions("Time").Levels("Year"). SliceValue = "1998"
4 dsoPartitionNew.Dimensions("Time").Levels("Quarter ").MemberKeyColumn =
"""time_by_day"".""quarter"""
5 dsoPartitionNew.Dimensions("Time").Levels("Quarter ").SliceValue = "Q4"
6 dsoPartitionNew.Dimensions("Time").Levels("Month") .MemberKeyColumn =
"""time_by_day"".""month_of_year"""
7 dsoPartitionNew.Dimensions("Time").Levels("Month") .SliceValue = "12"

The first one sets up the "name" of the slice and the others are the actual
slice itself. All are needed.
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.


"Jesse O" <jesperzz (AT) hotmail (DOT) com> wrote