Hi all,
I realise this has probably been asked a million times but i've searched the WWW all day and am yet to find an answer to what i'm trying to do.
Goal: Set a session variable using the date prompt's presentation variable so that I can create 4 other session variables (1 month ago, 2 month ago, 3 month ago etc) for dynamic column names.
I have tried the SET VARIABLE in the prefix section of one of the answers. This didn't work.
I am now trying to go down the javascript route and have placed the following code in a blank HTML section in my dashboard.
I know that the call works fine as I have tested it in the "Issue SQL" window but I can't for the life of me work out why the javascript doesn't work.
From the looks, the code used to work out the scid is returning NULL.
<script language="javascript">document.write("<iframe width=0px height=0px src=" + document.location.href.match(/^[^?]+/) + "?IssueRawSQL " + document.location.href.match(/&_scid=[^&]+/) + "&SQL=CALL+NQSSetSessionValue('String+s_MonthPrompt=test;')></iframe>");</script>
Any ideas?
This is frustrating me so much!!!