We're creating an installation for a web based product and would like to
include a sample OLAP cube for use with the application. Currently, we are
using msmdarch.exe to install a CAB file with the cube to a given server.
We would more control over the installation - being able to modify the
datasource, etc. Is there any way to accomplish this programatically?
(i.e., similar to what you might to when installing/setting up a database on
a remote server using transact sql from within the setup app?).

Thanks,

-- da

Microsoft provide a COM API called Decision Support Objects (DSO) that can be
used to programatically manipulate your cube struture. All you need is a
COM-compliant language - VB Script works fine!

HTH

Jamie Thomson
http:///www.conchango.com


"da" wrote:

Can the CUBE be manipulated remotely with DSO?

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

Yes.

"da" wrote:

Jamie,

We've finally gotten around to working with DSO to modify the datasource in
our cube after installation. We're attempting to change the connection
string, but we get back an error something to the effect: "Operation is not
allowed while object is open".

Not sure why it would be "open" since all we're doing is accessing the data
source string in the connection. Is there any sample code that you know of
that we could look at?

Thanks,

-- da


"Jamie Thomson" <jamie.thomson (AT) donotspam (DOT) conchango.com> wrote

OK - I just closed the ADO connection prior to setting the string.

Now... how do I managed this so that the string is saved, i.e., such that
next time I visit the Cube data source in the Analytical Server manager I
see the values that I set?

- da

"Jamie Thomson" <jamie.thomson (AT) donotspam (DOT) conchango.com> wrote