I'm struggling with this MDX that on rows should return crossjoin of Date and Countries sorted by value. Apparently, "[Date].[Fiscal Year].CurrentMember" in Order function during crossjoin is still returning default member, not the current member from the crossjoin context. Perhaps my understanding how and when the set during crossjoin is evaluated is not correct?
WITH
SET [DATE_main] AS
{
[Date].[Fiscal Year].&[2002],
[Date].[Fiscal Year].&[2003]
}
SET [CUSTOMER_ordered] AS
{
Order
(
[Customer].[Customer Geography].[Country].Members,
(
[Customer].[Customer Geography].CurrentMember,
[Date].[Fiscal Year].CurrentMember,
[Measures].[Internet Sales Amount]
),
BDESC
)
}
SELECT
{[Measures].[Internet Sales Amount]} ON COLUMNS,
CrossJoin
(
[DATE_main],
[CUSTOMER_ordered]
) ON ROWS
FROM [Adventure Works];
Thanks for any advice, Endokr