I am trying modifying one of the sample queries from "Practical MDX Queries".
I would have expected [Measures].currentMember be replaced with [Measures].[Reseller Sales Amounts], the default measure, at runtime. But it didn't and returned all <Null> values. Why??
-- running Sum
with member [Measures].[Running Total]
as sum(periodstodate([Date].[Calendar].[(All)],
[Date].[Calendar].currentmember),
[Measures].currentMember)
select
[Measures].[Running Total]
on columns,
[Date].[Calendar].[Calendar Year]
on rows
from
[Adventure Works]
Fan Liu
View Complete Post