I have a Date Hierarchy from a Transformer Cube that provides date members Year, Quarter, Month, and Week for the last 3 years (in this case 2018, 2019, 2020).
I want to set the default selection for a Tree Prompt to the current year (2020) and then allow the business user to select any member as they see fit.
I can set the default selection to the value [Cube Name].[Date Hierarchy].[Date Hierarchy].[Year]->:[PC].[@MEMBER].[2020] and this works for now.
However, when we role into 2021 this will not be the most current year, and eventually, this will not work at all when [2020] is not a valid member.
How can I set the default selection to in effect be the last child in the Year level?
Any help will be gratefully appreciated.
Thanks in advance,
------------------------------
Adam McIlravey
------------------------------
#CognosAnalyticswithWatson