Hi,

I want to create a script to add some actions to my cubes.
but I don't find any reference in the BOL about how to do this using the DSO
objects.

so, anyone can provide a script to alter a cube and add an action?
I've try this without success:
dim cn
set cn = createobject("adodb.connection")
cn.Open "provider=msolap; Initial Catalog=Foodmart 2000;
Datasource=localhost"
strCreateCube = strCreateCube & "alter cube Sales add action MyNewAction For
cells as '""hi""' , TYPE= 'HTML'"
cn.execute strCreateCube

but no new action are created !!!
and there is no errors.

what is wrong?
thanks.

Jerome.

ok I've found!!!

after some test I've create a VB script which use DSO to add my actions!
:-)

also, using DSO, I can add my custom library without problem!!!
using the AS Admin interface I can't do this!!!


"Jéjé" <willgart (AT) BBBhotmailAAA (DOT) com> a écrit dans le message de news:
O1jjyfM3EHA.2572 (AT) tk2msftngp13 (DOT) phx.gbl...