Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Passing a presentation variable to a session variable.

anwickesSep 10 2013 — edited Sep 11 2013

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!!!

Comments

Locked Post
New comments cannot be posted to this locked post.