Hi I have a time dimension which has hierarchy as Total Year->Years->Quarters->Months
How can i dynamically filter time dim so that it shows current month.
You will need to base it on some sort of rule. Are you just trying to find the last month in the time dimension (ie the latest month)? If so, you can use the tail() function (among others) to get the last member in a specific level. Any more information you have would help me suggest a solution. Thanks!