mdx

Hi, I need to amend the following (SELECT ( [Action date].[Calendar].[Date].&[20230413] : [Action date].[Calendar].[Date].&[20230401] ) so the actual data range is always "execution day minus 7 days : execution day". I need to see last seven days worth of data on a day report runs basically...