Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Query failing due to Session variable in obiee11g

Received Response
31
Views
5
Comments
AbinashBehera
AbinashBehera Rank 5 - Community Champion

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

Answers

  • SriniVEERAVALLI
    SriniVEERAVALLI Rank 6 - Analytics Lead

    How you are calling that variable?

  • 3183445
    3183445 Rank 1 - Community Starter

    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
    AbinashBehera Rank 5 - Community Champion

    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
    SriniVEERAVALLI Rank 6 - Analytics Lead

    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
    AbinashBehera Rank 5 - Community Champion

    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