How do i filter the data that is shown in a Tree Prompt?
For example, lets say that the Time Dimension is from 1990 through 2007. I want the Tree Prompt to only display the years from 2002 through 2007. How can this be done?
Thank you in advance and hope you all have a wonderful New Year.
Julio
Wow... This was simple. Solution was to get the query that the Tree Prompt creates and:
[Time].[TimeH].[Year].[YearId] between '2002' and Year(getDate())