5 Replies Latest reply: Feb 18, 2013 12:55 AM by sayak RSS

    [nQSError: 46036] Internal Assertion: Condition pLeftOperand in obiee 11g

    sayak
      Hi ,

      I am trying to display text data from Essbase Cube in OBIEE report , had one thread already opened for this :

      Displaying text data from Essbase Cube in OBIEE report

      I'm approaching in the following way :

      1. Created one session initialization block "TEXT_ID_VALUE" , having below query :

      select TEXT_ID, VALUE from HSP_TEXT_CELL_VALUE ;

      2. Matching the data populating in "TEXT_ID"(numeric data) session variable, with one of my measure column and fetching the corresponding "VALUE" session variable (text data) . (both the session variable's belong to TEXT_ID_VALUE initialization block , with 'row wise initialization' )

      3. Wrote below expression in measure column(in BMM layer) :

      CASE WHEN  "CAPEX_inteliplan"."CAPEX"."Capex Description" = VALUEOF(NQ_SESSION.TEXT_ID)  THEN  VALUEOF(NQ_SESSION.VALUE)  END

      Its throwing this error message :

      *[nQSError: 46036] Internal Assertion: Condition pLeftOperand, file server\Query\Optimizer\Request\Src\SQORRqExprCond.cpp, line 158.*

      Am I missing anything / is it the correct way to do it?