i have some calculated members and dimensions etc. in aquery based on a cube.
but i want to filter it dynamically by date range. suppose the user selected
a date range, the query should be in the selected date range (eg: 'trndate
between this and that'). how can i achieved in this in mdx?

thanx in advance for help

You can have calculated members like
Current Month, Prior Month calculated members which uses Lastperiods
function and Time.currentmember and Time.prevmember to show the results
dynamically based on the Time dimension selection

Regards
Prasanna