Whats is wrong with this query? -
02-01-2006
, 12:48 PM
WITH
MEMBER [Time].[Month].[CMonth] AS
TAIL(NONEMPTYCROSSJOIN([Time].[Month].Members), 1)
MEMBER [Measures].[Output] AS ([Time].[Month].[CMonth],
[Measures].[Average Days Receivable])
MEMBER [Measures].[Output Diff] AS ([Time].[Month].[CMonth],
[Measures].[Average Days Receivable]) -
([Time].[month].[CMonth].PREVMEMBER, [Measures].[Average Days
Receivable])
SELECT ({[Measures].[Average Days Receivable], [Measures].[Output],
[Measures].[Output Diff]}) ON 0,
([NFE Broker Type].[NFE Broker Type].MEMBERS) ON 1 FROM [AR]
I get sound results for the first column [Measures].[Average Days
Receivable] but the other two they do not I get #Error
any ideas ?
Thanks
Denver |