hi all! i am using vbscript with

[arwo]

hi all!

i am using vbscript with decision support objects!
i just want to add dimensions and levels.
But i cannot update the dimension! is it enough to update the server? if i just update the serverobject the dimensions are set but i loose the levels!
this is the code fragment:

---------------------------------------------------------
Set dsoDim = dsoDB.Dimensions.AddNew("Products&quot
Set dsoDim.DataSource = dsoDS 'Dimension DataSource
dsoDim.FromClause = "product" 'Related Table
Set dsoLev = dsoDim.Levels.AddNew("Brand Name&quot
MsgBox "Dim = " & dsoLev.Name

dsoLev.MemberKeyColumn = """product"".""brand_name"""
MsgBox "Dim = " & dsoLev.Name
dsoLev.ColumnSize = 255
dsoLev.ColumnType = 130
dsoLev.EstimatedSize = 1

dsoServer.Update
-----------------------------------------------------------

The documentation fo MSSQL Server 7.0 doesnt seem to be correct! For example i cannot use the Update method with a
dimension object. Does sombebody know where i can get a correct reference?


Many thanks!

It would be great if sombody can help me!
Sorry for the bad english!

CU! arwo