Generate Function

[boligoma]

Hi, I have a third-party application that connects to OLAP Services using a MDX query.

I'm trying to use two funtions:

member [Measures].[GpoPar] As '({[Group].[All Group].[Cons]})'

set [Cias] as 'Generate({[Measures].[GpoPar]}, "Suma&quot'

Where [Measures].[GpoPar] is the value of the father that I want to use in the Generate Function.

The other part of the function is a constant which it is called from the application. But the MDX Sample Application sends me an error, I guess it's because I'm using a constant value (e.g "Suma&quot.

I've tried to use the next function: set [Cias] as 'Generate({[Measures].[GpoPar]}, ({[Suma]}))'

But the problem is that have more than one children named "Suma" and this solution gives me the first one, for example it gives me:

[Group].[All Group].[Brothers].[Suma]

instead of

[Group].[All Group].[Cons].[Suma]


Any Ideas?

Thanks