Excel 2010 analysis services multiple reports
Posted on 2012-09-05
I developed a series of monthly reports for a user using Excel 2010 connected to an analysis services cube. There are 16 tabs with 16 different reports, all connected to the same cube. Each report is filtered to show data through the end of "last month" by the user clicking on the Date and changing the filter by bumping it up a month. So, to get a new set of his monthly reports, the user has go to into each of the 16 tabs and change the month filter 16 times.
I can't just use "current" data because the cube is updated every day through "yesterday". For example, he would not want to see data for Sept 1- Sept 4 (yesterday) included in the numbers for his August reports.
Is there a way to automate the refresh of the Date filter across all the tabs?
Thanks in advance!