I am new one in MDX. Our PeriodsToDate function does not return any value. We have set type property of our Date Dimension as time.
Actually CURRENTMEMBER does not return a valid value. So our PeriodsToDate function fail.
Pl see query below that return nothing
With MEMBER [Measures].[YTD Actual]
AS
Aggregate
(
PeriodsToDate
(
[DimDate].[CalendarHierarchyDateLevel].[Calendar Year]
,[DimDate].[CalendarHierarchyDateLevel].CURRENTMEMBER
)
,[Measures].[Actual Sales Amount]
)
select {[Measures].[Actual Sales Amount], [Measures].[YTD Actual]} on 0 from [MyCube]
But When we give Year as Hardcoded then it return correct value.
with MEMBER [Measures].[YTD Actual]
AS
Aggregate
(
PeriodsToDate
(
[DimDate].[CalendarHierarchyDateLevel].[Calendar Year]
,[DimDate].[CalendarHierarchyDateLevel].[Calendar Year].&[2008]
)
,[Measures].[Actual Sales Amount]
)
select {[Measures].[Actual Sales Amount], [Measures].[YTD Actual]} on 0 from [MyCube]
Please help me to resolve this issue.
Thanks in advance.