LoV of Dates, Conditional Filter

[moebe]

Hello everybody

I have a customer who extracts data at irregular intervals and stores it in our DWH.
Now I am looking for a possibility to show him a LoV of the available days in the reporting.
My wish would be:

Conditional Filter: latest_etl_rundate
Unless: Select different date from LoV

Getting the latest date is still easy:
select max(etl_valuation_date) from table

But how do I get into a LoV of available days?
If I format this as a date, no suggestion appears.
Unfortunately, if I format this as a string, no suggestion appears either.
And of course I don’t want to lose the functionality of a dimensiongroup (drill etc.).

Do you have solutions for “my” problem?