Hi,

does it possible to write a description for a calculated measure like I can
for a standard measure?

thanks.

Jerome.

Hi Jerome

In the DSO object model a calculated member (which is a "command" in the DSO
terminology) has a description property.

The property isn't exposed in Analysis Manager, however (I don't know why!).

You need to write some kind of a program (e.g. VbScript, Visual Studio...)
to make a calculated member (a "command" as it is) with a description, or
you can make the calculated member in Analysis Manager and then apply a
description to it with a program.

If you are not experienced with DSO, I would recommend the latter.

It could look something like this (VBScript):

Dim DSOServer, DSOdb, DSOCube, DSOCommand

Set DSOServer = CreateObject("DSO.Server") ' Create the DSO server object
DSOServer.Connect "YourServername" ' Connect to your server

Set DSOdb = DSOServer.MDStores("Your databasename") ' Access your database
Set DSOCube = DSOdb.MDStores("Your cubename") ' Access your cube

Set DSOCommand = DSOCube.Commands("Your calculated member") ' Access your
calculated member

DSOCommand.Description = "Your description" ' Set the desired description

DSOCube.Update ' Write back to the repository

' Clean up
Set DSOCube = Nothing
Set DSODb = Nothing
DSOServer.CloseServer
Set DSOServer = Nothing


You could use the Wscript.Arguments collection to parameterize the script
and call from a bat/cmd-file.

Obviously you need something simular, when you want to see the descriptions!

Best regards
Dan Reving

"Jéjé" <willgart_A_ (AT) hotmail_A_ (DOT) com> skrev i en meddelelse
news:OUyC6NK3EHA.3908 (AT) TK2MSFTNGP12 (DOT) phx.gbl...

Does a custom add-in can solve this lack of functionality?

"Dan Reving" <dan.reving (AT) magasin (DOT) dknospam> wrote