Categories
- All Categories
- 93 Oracle Analytics News
- 7 Oracle Analytics Videos
- 14.2K Oracle Analytics Forums
- 5.3K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 53 Oracle Analytics Trainings
- 59 Oracle Analytics Data Visualizations Gallery
- 2 Oracle Analytics Data Visualizations Challenge
- 4 Oracle Analytics Career
- 4 Oracle Analytics Industry
- Find Partners
- For Partners
Query failing due to Session variable in obiee11g
Hi All,
Need an urgent solution....
I have created non system session variables with initialization Blocks. And also having Application Roles for Row-Level security.
When i am trying to run the a sample report, its throwing me this error...
Answers
-
How you are calling that variable?
0 -
Hi,
Please verify, how did you call a system variable in the Logical Table in the RPD.
The correct form its with de function VALUEOF before calling. For example, VALUEOF(NQSESSION."variable")
0 -
Hi All,
This is how I am calling the variable. Here I am using the below statement within an application Role for restriction of data.
"CAMS"."F_MFD_INDSUMM_FINYEAR"."Broker Code" = VALUEOF(NQ_SESSION.RM_BROKER) AND "CAMS"."F_MFD_INDSUMM_FINYEAR"."Location" = VALUEOF(NQ_SESSION.RTLRM_CITY)
0 -
You telling that to the BI server if you want BI Server to act on this?!! You need to enclose the same in CASE statement.
0 -
Hi Srini,
I got the problem for it. It was because of NULL values in data. If the variable will have a NULL value then it will through this error.
Thanks,
abinash
0