DSO question - AS2000

I have some code where I'd like to change the slice on a level to the
upcoming year.

The code executes successfully, however it doesn't actually update it on the
server.


Any ideas?



For l = oDimension.Levels.Count To 1 Step -1
Set oDimLevel = oDimension.Levels(l)

If oDimLevel.SliceValue = "2008" Then
oDimLevel.SliceValue = "2009"
End If

Next

Jesse,

You may need to call the dimension's Update method, which is one level
up from the dimensional Level object. This should make the setting
"stick". Also, from your code example, you may want to just do a For
Each loop for something a bit cleaner...

Good luck
-exologic


::: Pain with Essbase? Use CubePort, The BI Porting App :::
::: Go from Essbase to Microsoft Analysis Services :::
::: web: exologic.com/products.htm :::