Hi everyone,
I am new to OBIEE and I have a question regarding my variable hidden prompts.
I hope I used the right category for my question.
Use Case:
As a user I want to change the year and/or month in the column prompts (you can see the two column prompts at the top of the screenshot) and visualize the values with the correct month and year in the column “Initial acceptance Date”.
Further information:
- The variable prompt (you can see it at the bottom of the first screenshot above) has been inserted in the dashboard properties because it should be hidden.
The SQL statement of the variable prompt is:
SELECT "Snapshot Date"."Fiscal Month (YYYY/MM)" FROM "<Folder>" WHERE "Snapshot Date"."Fiscal Month (YYYY/MM)" = CONCAT(CONCAT('@{<Foldername>_ACCEPT_DATE_FY} ','/'),' @{<Foldername>_Acceptance_Date_Fiscal_Month_Prompt}')
- In the screenshot below you can see my analysis where I am using the filter “Fiscal Month (…)” with a default value of “2024 / 12”.
Problem
Everything works fine as long as the variable prompts stays in the dashboard together with the other elements:
I can change the year and/or the month in the column prompts in order to visualize the corresponding data in the column “initial acceptance date”.
However, as soon as I remove the variable prompt from the dashboard, the column “Initial acceptance Date” does not react whenever I try to change the year and/or the month in my column prompts.
Where is the mistake?
Please let me know if you need more information.
Thank you in advance for your support.
Best regards
Lara Cancellario d'Alena