We have a Date dimension with 3 levels (Year,month,day).
The user wants the Excel pivot table report to be set for today's date
when it opens.
1) How can I set today as a default member for my Date dimension (MDX syntax ???)
2) How can I tell Excel to use that default member when it opens the report.
Thanks for your advices.