I have multiple dashboards that share a single analysis and a hidden dashboard prompt. The hidden dashboard prompt sets a presentation variable named p_selected_metric. The default selection for the p_selected_metric variable depends on name of the dashboard and it is set by using the following query:
SELECT CASE WHEN '@{dashboard.name}' ='Drill to Detail UDT' then '"Completed"."UDT Vol"'
WHEN '@{dashboard.name}' ='Drill to Detail UDM 'then '"Completed"."UDM Vol"'
WHEN '@{dashboard.name}' ='Drill to Detail Delay Days' then '"Completed"."Delay Days Vol"'
END FROM "TEST"
Then, the analysis will use the p_selected_metric presentation variable in the criteria to pull the report.
The dashboard and analysis work correctly on the dashboard page. However, when I click the export link on the analysis, it does not work. I looked at the log and I saw that the @dashboard.name variable was empty. I am not sure why the @dashboard.name becomes empty during export. Does anyone have solution to this problem?
Thanks,
J