We use DSO programming to do odds and ends for us on Analysis Server.
Mostly straight forward things like incremental cube processing. I have an
outstanding request and am not sure how (or if ) it can be done using DSO.
We have several virtual cubes which store a calculated set called "current
month" which looks like:
{[Date_YM].[Year].&[2003].&[9]}

This definition is stored in the server cube not on the client application.
Can I access the text of this set using DSO and change its content
programmatically? It is pretty clear to me how to change things like fact
table names using DSO programmatically but it is not obvious to me how to
get at Sets and Members defined with cubes and to change them.

We are working with VB and CSharp (via COM interop).

Any pointers would be greatly appreciated.

thanks.

dlr

Dennis,

You can do it with DSO: Look in DSO.Cube object, it has collection of
DSO.Command.
Each command has a type (calculated member, named set, calculated cell etc).
Find the command of the type named set with the name you are looking for.
Then simply change it's content.

--
==================================================
Mosha Pasumansky - http://www.mosha.com/msolap
Development Lead in the Analysis Server team
All you need is love (John Lennon)
Disclaimer : This posting is provided "AS IS" with no warranties, and
confers no rights.
==================================================
"Dennis Redfield" <dennis.redfield (AT) acadia-ins (DOT) com> wrote