Query failing due to Session variable in obiee11g

Question

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

Query Failed: [nQSError: 23006] The session variable, NQ_SESSION.RTLRM_CITY, has no value definition.Please have your System Administrator look at the log for more details on this error. (HY000)

But I have checked the log files(nqquery.log), there the particular init block is executing successfully and returning values also, but in Presentation layer its giving me this error.

what could be the possible reasons??

Regards,

Abinash

AbinashBehera · Answer

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

SriniVEERAVALLI · Answer

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.

AbinashBehera · Answer

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)

@3183445 @Srini VEERAVALLI