I have designed a dashboard , some parametrized reports ( on date and time) in my case with a cube as datasource, added an analysis services 2005 filter, connected it to the reports.
The issue concerns the default value for the filter .
I f I choose [Date Local].[Calendar Hierarchy].[All] it works well.
But the business requirement is to use the last day where there have been registered a measurement which in my case looks like the following mdx expression: Tail( Filter ([Date Local].[Date Key].[Date Key].Members , ( ( [Advisor Organisation].[Advisor
organisation].[Contact Center].&[Denmark]&[Kundelinjen], [Measures].[Calls Offered] , [Date Local].[DK Holiday].&[False] , [Date Local].[Week Day].&[True] ) > 0 ) ), 1).Item(0).Item(0)
The expression is all right as I use it in my report as an mdx filter expression.
But when I use apply it I get an invalid dafault member value.
So the question is :
Does the filter support an mdx expression ? If yes, is there another syntax or change in order to make it work ?
Thank you a lot for your answer.
View Complete Post