Hi,
How can I create a calculated member using DSO? I couldn't find something
like that in the DSO programmers reference.

Any idea will be welcome

Thanks a lot

Lucas C

This is the technique that I use:
First, get the Analysis Services Meta data scriptor utility from the SQL
Server 2000 Resource Kit.
It generates a VB program that will use DSO to create the object you
specified.
So:
1) Run the meta data scriptor against the database
2) Add the calculated member via Analysis Manager
3) Run the meta data scriptor against the database
Then do a diff between the VB programs generated by #1 and #3

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

"Lucas Campos" <lcampos (AT) rmya (DOT) com.ar> wrote

Thanks a lot. I doesn''t new about it (Analysis Services Meta )
I received this code and I will evaluate those alternatives.

' create the new calculated member
Dim dsoCalculatedMember As DSO.Command
Set dsoCalculatedMember = m_dsoCube.Commands.AddNew("Average Sale")

' set the command type
dsoCalculatedMember.CommandType = cmdCreateMember

' set the MDX statement that defines the calculated member
dsoCalculatedMember.Statement = _
"CREATE MEMBER Sales.Measures.[Average Sale] AS " & _
"'[Measures].[Store Sales]/[Measures].[Sales Count]', " & _
"FORMAT_STRING = 'Currency'"

' save the cube definition in the metadata repository the calculated
member will be saved as a part of the cube
m_dsoCube.Update


"Dave Wickert [MSFT]" <dwickert (AT) online (DOT) microsoft.com> escribió en el mensaje
news:Of#Eh69dDHA.556 (AT) TK2MSFTNGP11 (DOT) phx.gbl...