I've tried implementing this in our cube and have run into an issue. The action expression is very simple:
NAME([$Paid Date].[Date]) as [PaidDate]
When I try to run the drillthrough in Excel I get an error that states the following:
Parser: The following syntax error occured during parsing: Invalid token, line 703, Offset 2, [.
I ran a trace using SQL Profiler and saw that the mdx being executed was as follows:
drillthrough select ([Adjusted Date].[Date].[All]
,[Adjusted Date].[Day Name].[All]
,[Adjusted Date].[Day of Month].[All]
... ***all remaining dimension attributes get listed
,[Payee Provider].[Provider Primary City Name].[All]
It ends with the ",[". It appears that the mdx script gets truncated. Also, I don't really understand why it's trying to pull every dimension attribute when I've only listed one. Have you ran into this issue... do you see anything wrong with my syntax?
I've tried quite a few variations and haven't had any luck.
BTW... I love your site... lot's of good info on here... keep in coming!