Query failing due to Session variable in obiee11g

AbinashBehera

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

SriniVEERAVALLI

How you are calling that variable?

3183445

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")

AbinashBehera

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

SriniVEERAVALLI

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

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