Hi,

I've created many calculated members in the develop server.

How can I move (only) the calculated members to the production server?

Thank's in advance!!!

Un saludo,

Enrique Barceló

I remember back in OLAP Services (SQL 7.0) there was a third party utility
that would allow you to import and export calculated members that was
floating around, but I haven't really seen it for a few years now. (I believe
it was from either Microsoft and not supported, or in one of George
Spofford's books)

Without a third party tool, you can't really do this unless you're willing
to write DSO code. In the sample code that installs with Analysis Services,
there's some examples of how to do this.

A good old-fashioned kloodge would be to create a virtual cube in your
source OLAP database and import your calculated members into it, then paste
the virtual into the target, your production server. If you have reports or
front end tools with saved MDX statements pointing directly to the physical
cubes, then this is not an option, but still valid if you don't have saved
MDX statements or reports.

Good luck.

"Enrique" wrote: