OTBI Custom Prompt for Company Fiscal Period, Quarter, and Year

Summary:

We have a need to report out on our fiscal calendar dates vs. the standard out of box calendar month dates. I was hoping there was a way to set-up our own fiscal calendar dates and use those as prompt selections in an OTBI dashboard so our users can select 2026-P01 or 2026-Q1 or FY2026 vs. FY2025, etc. We are based on a 5-4-4 fiscal calendar with the fiscal month start and end dates changing each year.

I thought I could use a CASE statement with the logic below to help, but I can't get it to work.