Hello,

What is the best way to set a "slice" on a partition using DTS?

I'm trying to use a global variable, but the slice does not take!
No error or anything, just does not take --

Example --

dsoPartitionNew.Dimensions("Fiscal").Levels("Year" ).SliceValue =
"[Fiscal].[All Fiscal].["+DTSGlobalVariables("Slice_Year").Value+ "]"

Any help is appreciated.

Jim

Get a copy of the SQL Server 2000 Resource Kit.
On it is a utility called the Metadata Scripter. It generates VB code that
will re-create an object (such as a partition).
Run it against a partition with the data slice setup correctly and you will
see the proper syntax to use. Make sure you use your own data since the
field may be urlencoded.
--
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.

"Jim_OLAP" <JimOLAP (AT) discussions (DOT) microsoft.com> wrote