Hi,

Would you know why the following MDX returns '#Err' as values?

WITH
SET [Set1] AS '[Customers].[Country].Members'
MEMBER [Measures].[T] as '[Set1].Current.Item(0).UniqueName'

SELECT {[measures].[t]} ON COLUMNS,
[Set1] on Rows

FROM [Sales]

Thanks.

Current function returns the current tuple from a set *during an iteration*.

Here, you should modify the calcualted member as following,

MEMBER [Measures].[T] AS 'Customers.CurrentMember.UniqueName'

Ohjoo Kwon


"John" <nospam> wrote