Does any one know how to add a Calculated member to the Cube using the
DSO objects (using scripts).

This VBScript working snippet should help:

set dsoServer = CreateObject("DSO.Server")
dsoServer.Connect "LocalHost"
Set dsoCube= dsoServer.MDStores("Foodmart 2000").Cubes("Sales")
Set dsoCommand= dsoCube.Commands.AddNew("Test Member")
dsoCommand.CommandType=1
dsoCommand.Statement= "Create Member CURRENTCUBE.Measures.[Test Member] as
'[Measures].[Unit Sales] * 2'"
dsoCube.Update

This is just the basic code, you should add locking, error handling...
HTH,
Brian
www.geocities.com/brianaltmann/olap.html

"Jeethendar" wrote:

Make sure that you quote the text properly. SSAS uses html encoding for some
properties. One of the ways to figure this out is to 1) write a reverse
version of the script which would display the Command object that was
created by AM, or 2) Use the Metadata Scripter utility on the SQL Server
2000 Resource Kit (available at your local bookstore, http://www.bn.com, or
if you can find someone in your company with a TechNet subscription on the
Resource Kit CD/DVD), or via the DSO/XML utility at:
http://www.microsoft.com/downloads/d...DisplayLang=en

--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"Brian Altmann" <findme@thesignaturewebsite> wrote