I know how to create a cube with DSO, but I have a problem with the create member when I want to add the solveorder property. there is no problem with the format string (in theory is the same, but ...)
Set dsoCmd = dsoCubo.Commands.AddNew("% Aceptado")
dsoCmd.CommandType = cmdCreateMember
dsoCmd.Statement = "CREATE MEMBER [" & strNombreCubo & "].[Measures].[% Aceptado] AS " & _
"'IIF ([Measures].[Importe Entrado] = 0, 0, [Measures].[Importe Aceptado] / [Measures].[Importe Entrado])'," & _
"FORMAT_STRING = 'Percent'"

I wonder if someone knows how to solve this.
I hope i have been able to explain the problem.

Waiting for a solution

don't use '%' symbol in nam
----- Lurdes Hernandez wrote: ----

I know how to create a cube with DSO, but I have a problem with the create member when I want to add the solveorder property. there is no problem with the format string (in theory is the same, but ...
Set dsoCmd = dsoCubo.Commands.AddNew("% Aceptado"
dsoCmd.CommandType = cmdCreateMembe
dsoCmd.Statement = "CREATE MEMBER [" & strNombreCubo & "].[Measures].[% Aceptado] AS " &
"'IIF ([Measures].[Importe Entrado] = 0, 0, [Measures].[Importe Aceptado] / [Measures].[Importe Entrado])'," &
"FORMAT_STRING = 'Percent'

I wonder if someone knows how to solve this
I hope i have been able to explain the problem.

Waiting for a solution