OLAP Query Dynamic MDX

[idahoboi]

Hi MrExcel Board!

I'm hoping you can help me. I have a pivot table set up using an OLAP Query that I need to set up a custom MDX filter for time. I need it to dynamically update to pull the last 7 days worth of data for our subset. Can you help me figure out how to change these static dates into dynamic dates? Here is a sinppet of the MDX code currently in place with the static dates.

{([Time].[Months].[Year].&[20120000],[Measures].[HRID]),([Time].[Months].[Day].&[20120109],[Measures].[Referral Rate]),([Time].[Months].[Day].&[20120109],[Measures].[% Warm Transfer Rate - Total]),([Time].[Months].[Day].&[20120110],[Measures].[Referral Rate]),([Time].[Months].[Day].&[20120110],[Measures].[% Warm Transfer Rate - Total]),([Time].[Months].[Day].&[20120111],[Measures].[Referral Rate]),([Time].[Months].[Day].&[20120111],[Measures].[% Warm Transfer Rate - Total]),([Time].[Months].[Day].&[20120112],[Measures].[Referral Rate]),([Time].[Months].[Day].&[20120112],[Measures].[% Warm Transfer Rate - Total]),([Time].[Months].[Day].&[20120113],[Measures].[Referral Rate]),([Time].[Months].[Day].&[20120113],[Measures].[% Warm Transfer Rate - Total]),([Time].[Months].[Day].&[20120114],[Measures].[Referral Rate]),([Time].[Months].[Day].&[20120114],[Measures].[% Warm Transfer Rate - Total])}

Any help you can provide would be greatly appreciated!
Thanks!

 

[Jerry Sullivan]

Hi and Welcome to the Board!

This thread shows how to set filters based on variable dates for a PivotTable with an OLAP data source.

http://www.mrexcel.com/forum/showthread.php?t=598416

Just ask if you want some help adapting that to your application.