Hi!
I have a set sTemp3Iff, I need to combine each elment of this set with
[Measures][Npv] and convert whole result into string. My problem is that MDX
declare TYPE MISMATCH error for (sTemp3Iff.Current,[Measures].[Npv]), but
works well with
(sTemp3Iff.Item(0)[Measures].[Npv]). I am at loss at what is going on and
how to fix it. I would be grateful for any help.

Generate
(
sTemp3Iff,
CStr((sTemp3Iff.Current,[Measures].[Npv])),
"+"
)

Do you mean something like:

with
set sTemp3Iff as '{[Food],[Drink],[Bread]}'
member measures.Test as 'Generate( sTemp3Iff , "(" +
sTemp3Iff.Current.Item(0).Name + ",[Measures].[Unit Sales])" ,"+")'
select {Test} on columns
from sales

HTH,

--
Brian Altmann
BI Specialist
Huddle Group S.A (www.huddle.com.ar)
www.geocities.com/brianaltmann/olap.html


"martinbx" wrote:

Yes, It seems that if there is no data [Measures].[Npv] ([Measures].[Unit
Sales] in your example) for one of the sTemp3Iff's items, then MDX stops
processing and returns an error.


"Brian Altmann" wrote: