Version: 11.1.1.5First of all, it's a Session variable, not a repository variable. Whatever.
OS: OEL 5
So I had created a PIPELINED function to serve as the source of a table. From the analysis side, we wanted to use a presentation variable to set a session variable that was referenced in the table source.
Here's the SQL for the Stored Proc call:
SELECT *I hardcoded 4 in there just to see how it worked. BTW, Gerard Nico describes the process here.
FROM TABLE( get_key_value_pairs( 4 ) )
I then created a session variable along with the init block.
SELECT 5 FROM dualwhich would populate the P_LIMIT session variable. Nothing terribly fancy.
I then ran a simple report based off of the new table source (with the hardcoded value):
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgNvY4_K2BZm_uZfDBp_czonu-hv9kSyslL5_e8MHuUCGtEfoo8WZNcH0NEOTQz6hu9Ll98Ar0rzDya__a_KY3prwLGXLIYUTYhynG_km0XlvNghcQ6oPqjHmPHM4WfUCgZ_jAsaYmNwRc-/s800/01_obiee.jpg)
Cool, now let's swap out the hardcoded value with the reference to the session variable.
Since I don't do a lot of front-end stuff, this post at Siebel Essentials has been my bible.
I locate what I am trying to do in the matrix:
VALUEOF("NQ_SESSION.P_LIMIT")Like a big jerk, I have to add spaces to it, you know, for readability. My SQL looks like this:
SELECT *
FROM TABLE( get_key_value_pairs( VALUEOF( "NQ_SESSION.P_LIMIT" ) ) )
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi6CJGdJyeU_KF3gOXlchd6PfTgXoaXkxH440N_Zknq4h3Rd3i_nDwnsvxsmapaTsm1Uq4BbNgYr1ZudGnn9DC6ATQ2kz73qJ_xxwzPqvXBHPLd9EYTUjZrfCTW3-hAf9rt9IlohWGKq6ug/s800/03_obiee.jpg)
OK, let's try without the quotes ("):
SELECT *Same thing.
FROM TABLE( get_key_value_pairs( VALUEOF( NQ_SESSION.P_LIMIT ) ) )
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi6CJGdJyeU_KF3gOXlchd6PfTgXoaXkxH440N_Zknq4h3Rd3i_nDwnsvxsmapaTsm1Uq4BbNgYr1ZudGnn9DC6ATQ2kz73qJ_xxwzPqvXBHPLd9EYTUjZrfCTW3-hAf9rt9IlohWGKq6ug/s800/03_obiee.jpg)
Let's gid rid of the spaces (I've had issues with spaces before, but I can't seem to find the post).
SELECT *
FROM TABLE( get_key_value_pairs( VALUEOF(NQ_SESSION.P_LIMIT) ) )
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgNvY4_K2BZm_uZfDBp_czonu-hv9kSyslL5_e8MHuUCGtEfoo8WZNcH0NEOTQz6hu9Ll98Ar0rzDya__a_KY3prwLGXLIYUTYhynG_km0XlvNghcQ6oPqjHmPHM4WfUCgZ_jAsaYmNwRc-/s800/01_obiee.jpg)
Voilá!
Fun. I have noticed that certain areas of the RPD treat spaces slightly differently. If I ever find the other post, I'll link it up here.
Lesson? Be careful with your space.
No comments:
Post a Comment