Hi
I am trying to define a calculation that sums values over time based on a member attribute and am having some difficulty understanding how to reference the "CurrentMember" of the time dimension in my query separate from the "CurrentMember" whilst iterating
over the values in a set. The following MDX which sums all the days which have a certain week number explains the problem in a simplified way. You will see that I have defined the query to have the date &[1521] on the rows of the query and it is also defined
in the Filter function in my calculation.
WITH MEMBER [Measures].[SameWeek] AS
Sum
(
Filter
(
[Date].[Fiscal Year].[Fiscal Day].Members
,
[Date].[Fiscal Year].CurrentMember.Properties("Week Number Fiscal") /* This is the current member in the set */
=
[Date].[Fiscal Year].[Fiscal Day].&[1521].Properties("Week Number Fiscal")
)
,
[Measures].[Journey - Count]
)
SELECT
{[Measures].[Journey - Count], [Measures].[SameWeek]} ON COLUMNS,
{[Date].[Fiscal Year].[Fiscal Day].&[1521]} ON ROWS
FROM [Journey]
What I really want to do is to reference [Date - Actual].[Fiscal Year - Month - Day].[Fiscal Day].CurrentMember in the filter for the current member of time in the row axis so that the calculation definition is not for a single date so I would have
something like:
WITH MEMBER [
View Complete Post