OBIEE 12c: Setting a Presentation Variable using the GO URL

OracleUser_MUC6U

Hi,

I'm using a GO URL to call a dashboard which has a few variable prompts (Dashboard Prompts Type=variable).  The variable prompts are set via SQL Results in the Default section of the prompts.

I've created a Prompted Link to see how its done in a static link and I can see from the link syntax it uses &var with matching &varSQL see below for variable p_metric_summ_label

......

&var44=dashboard.currentPage.variables%5B%27p_metric_summ_label%27%5D - dashboard variable

&valsql44=%22SELECT%20%5C%22MetricName%5C%22.%5C%22Attribute%201%5C%22%20FROM%20%5C%22Date%20Interval%5C%22%20WHERE%20%5C%22MetricName%5C%22.%5C%22Property%20type%5C%22%20%3D%20%27TRAFFIC_OVERVIEW_METRIC%27%20AND%20%5C%22MetricName%5C%22.%5C%22Property%20Id%5C%22%20%3D%20%27%40%7Bp_col1_name%7D%7B%5C%22Site%20Traffic%5C%22.%5C%22Visits%5C%22%7D%27%22 -- SQL Results

&psa44=%22Date%20Interval%22 - Subject Area

.......

Does anyone know how the same can be done via a GO URL i.e set the variable p_metric_summ_label with the results of the SQL?

Thanks