Thursday, February 9, 2012

#Err results from query.

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 in message
news:%23%23U0H68LFHA.3420@.tk2msftngp13.phx.gbl...
> 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.
>

No comments:

Post a Comment